Normal Pivot Table Formulas 1

Sorting & Filtering the Pivot Table 1

Calculated Items 1

Calculated Fields 1

Conditional Formatting in the Pivot Table 1

Consolidated Pivot Tables 1

Importing data from Excel into PowerQuery – normal data 1

Splitting & Merging Columns in the PowerQuery 1

Calculate age in the PowerQuery 1

Adding Custom Calculations in PowerQuery 1

Importing data from a website into the PowerQuery 1

Refreshing the data in PowerQuery 1

Importing data from Excel into PowerQuery – formatted tables 1

Importing Access, SQL Server, and text files into PowerQuery 1

Append Queries 1

GroupBy Queries 1

Merge Queries 1

More Calculations including a conditional column in PowerQuery 1

Activating PowerPivot 1

Exploring the PowerPivot menus 1

Starting the Pivot Table from PowerPivot 1

Managing Table Relationships 1

Slicers & Timelines in PowerPivot 1

Using Sets in PowerPivot 1

Importing Data directly into the PowerPivot 1

Measures & KPI’s in PowerPivot 1