Introduction to Power Pivot & Power Query in Excel

In this Power Pivot and Power Query tutorial from Simon Sez IT. Excel expert, Deb Ashby teaches you how to get started with the Power Pivot and Power Query tools in Excel

In this Advanced Microsoft Excel tutorial, she looks at the following:

• PivotTables – a quick reminder 😉
• Importing data into Excel from multiple sources
• Cleaning data using power Query
• Creating a Power Pivot table
• Creating relationships using Power Pivot
• Using Measure and KPIs in Power Pivot
• Displaying data in a Pivot Chart

Download the Excel file used by Debs and follow along.

We hope you enjoyed this video. For more, free, Simon Sez IT Excel tutorials, take a look at our Excel Resources.