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 u2013 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 u2013 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 & KPIu2019s in PowerPivot 1