Advanced Excel: Power Query & Power Pivots
Course Info
Length:
Type:
City:
Course Details
Introduction
Objective
Who should attend
Course Location
Though many professionals use Excel on a daily basis, Excel has many undiscovered functions that can increase productivity even further. In this course, we will explore one of the relatively new tools brought by Excel to help professionals in cleaning up and preparing data for further analysis and reporting: Power Query.
We will also take a look at PowerPivots, another powerful tool in Excel which will put your pivot tables on turbo. While pivot tables have some limitations, PowerPivots can be used when you have significantly big data.
In this advanced Excel course, we look at two crucial advanced Excel features Power Pivot and Power Query, This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.
Course Outline
Key functions to prepare data for pivot table reporting
- Table format
- Lookup functions
- Text functions
- Naming cells
