Excel Power Tools: Power Query and Power Pivot
Accelerate your spreadsheet data analysis proficiency. This LIVE, virtual, hands-on data management course provides the essential 21st century Microsoft Excel training you need to get ahead. It goes beyond the fundamentals of PivotTables to explore more advanced topics, such as calculated fields, calculated items and conditional formatting. Then it brings you up-to-date and up-to-speed with Excel for Office 365 Power Tools, including Power Query and Power Pivot.
With Excel Power Tools, you’ll be equipped to analyze an unlimited amount of data, combine multiple data sources into a single report, analyze data across multiple tables and create more sophisticated calculations.
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Course Outcomes
- Build advanced PivotTables with calculated items and fields
- Combine separate sheets into one report with the PivotTable PivotChart Wizard
- Automate repetitive importing and data cleansing tasks instead of writing complicated VBA macros
- Merge multiple data sets into a single report using Power Query
- Import data into a Power Pivot data model
- Create and edit relationships between two data tables in Power Pivot
4.5out of 5
1,000
people have taken this course
96%
found this course to be helpful in their workplace
Course Agenda
Event Dates & Locations
Date | Time | Price | Action |
---|---|---|---|
January 21 | 3:00 PM-6:00 PM UTC | $199 | |
January 21 | 7:00 PM-10:00 PM UTC | $199 | |
February 10 | 3:00 PM-6:00 PM UTC | $199 | |
February 10 | 7:00 PM-10:00 PM UTC | $199 | |
March 4 | 3:00 PM-6:00 PM UTC | $199 | |
March 4 | 7:00 PM-10:00 PM UTC | $199 |
Live Virtual Workshop
Save when you enroll multiple attendees!
Just $189 per person when you enroll 4+ learners
Included in
SkillPath Unlimited+Live
$ per year
- Access this course and 6000+ other live virtual workshop sessions(includes live virtual events priced $399 or less)
- 500+ webinars broadcast daily
- 2,000+ on-demand resources
- And so much more!
More Courses in