Mastering SQL+Data analytics with Excel

General Discussion
3

To master Excel data analytics, we must familiarize ourselves with 3 tools:

  1. Pivot Table (mandatory).
  2. Power Query + Power Pivot
  3. MS Query

1. Pivot Table quick tutorial:

2. Pivot Table step by step:

3. Excel 2013 PowerPivot Basics

4. Excel 2016 Power Query + Power Pivot: