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.
Other Excel classes you might like:
Take a look at more recorded live classes from Simon Sez IT.
We hope you enjoyed this video. For more, free, Simon Sez IT Excel tutorials, take a look at our Excel Resources.
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.