Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This is an intermediate course suited to people with a general knowledge of Excel but not necessarily any knowledge of Power Pivot. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to learn to use Power Pivot.
Course Overview
This Kubicle course contains 15 lessons, 3 exercises and 1 Exam. It covers the following topics:
- Installing Power Pivot
- Loading Data to the Excel Data Model
- Data View and Diagram View
- Relationships
- Calculated Columns
- Remove blank cells with Macros
- Measures
- Creating a PivotTable from Power Pivot Data
- Creating a PivotChart from Power Pivot Data
- Adding Slicers to PivotTables and PivotCharts
- Updating the Data Model
Key Outcomes
Once you’ve completed this course, you’ll understand how the Excel Data Model works. You’ll be able to create a data model by importing several tables, and you’ll be able to generate insights from the data model in just a few clicks. You’ll be able to analyze large amounts of data much quicker than you would with other Excel features.