Power Pivot

Create data models and powerful integrated dashboards

Overview

Power Pivot is more than just a more powerful version of PivotTables. Power Pivot includes a Data Model which allows you to build relationships between data tables and create PivotTables from multiple data sources.

Using hands-on examples throughout, you will learn how to create a data model, manage relationships between data tables and create integrated dashboards.

Please note, this is the same course featured in the Power Query, Power Pivot and Power BI pack.

Learning outcomes
Additional information

You will learn:

how to load, link and update data in Power Pivot
how to write formulae in Power Pivot’s Data Analysis Expressions (DAX) language
the use of Time Intelligence functions to analyse data across periods.

This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
This course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021.
The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
This course requires you to have a basic understanding of Microsoft Excel.
CPD certificate is available upon successful completion of the course.
12-month access.

Price

Price 200 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning

Course providers