Power Pivot and Power Query are free addins for Excel, written by Microsoft (in fact in Excel 2016 and later Power Query is built into the application and not an addin at all).
Power Pivot puts the “power” into Pivot Tables (hence the name!), removing many of limitations and frustrations that many advanced users find with Pivot Tables (such as creating pivot tables from multiple lists and creating pivot tables from large datasets)
Why You Should Attend:
Power Query is used to import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint) and then clean that data to make it useable (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more).
If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query and Power Pivot is a must!
- Importing data into Power Pivot – the why and how
- Using the Data Model to create and manage relationships
- The benefits of using the Data Model
- Creating a Pivot Table from related Excel tables
- Creating a Pivot Table from related data sources (including external sources)
- An introduction to the DAX formula language to create simple calculated columns
- Using the Query Editor to clean and transform data
Who Should Attend:
This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.
IMPORTANT NOTE: Power Pivot and Power Query may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department.