Custom Course
This is a custom course that may have been designed with a specific client in mind. If you arrived here without being directed by a Webucator representative and are interested in learning more, please email sales@webucator.com.
Microsoft Office Excel 2016: Data Analysis with Power Pivot (EXC603)
Course Length: 1 day
In this Data Analysis with Power Pivot training class, students will learn to use Power Pivot to organize, manipulate, and report on data in the best way possible.
Register or Request Training
- Private class for your team
- Live expert instructor
- Online or on‑location
- Customizable agenda
- Proposal turnaround within 1–2 business days
Course Overview
In this Data Analysis with Power Pivot training class, students will learn to use Power Pivot to organize, manipulate, and report on data in the best way possible.
This course is intended for experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
This is class is 4 hours of instruction.
Course Benefits
- Get started with Power Pivot.
- Visualize Power Pivot data.
- Work with advanced functionality in Power Pivot.
Delivery Methods
Microsoft Certified Partner
Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and meets the highest instructional standards.
Course Outline
- Getting Started with Power Pivot
- Enable and Navigate Power Pivot
- Manage Data Relationships
- Visualizing Power Pivot Data
- Create a Power Pivot Report
- Create Calculations in Power Pivot
- Working with Advanced Functionality in Power Pivot
- Create a Key Performance Indicator
- Work with Dates and Time in Power Pivot
Class Materials
Each student receives a comprehensive set of materials, including course notes and all class examples.
Class Prerequisites
Experience in the following is required for this Microsoft Office class:
- Experience working with Excel 2016 and PivotTables.
- Understanding of spreadsheet concepts and comfort creating basic PivotTables.
Have questions about this course?
We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.
