What 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.
About this course
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.
Key information
- 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 (Excel 2019 for MAC support will end in October 2023).
- 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.
