Power Pivot: getting started

Overview

Power Pivot is an Excel add-in that provides some of the most powerful features for accountants. With its own DAX functions, it can be used to perform multiple calculations and complicated data analysis, enabling you to create sophisticated data models.

This course, goes beyond the basics, to enable you to become more comfortable with Power Pivot models, using Pivot tables and charts, as well as carrying out calculations and time intelligence functions. It is recommended that you have a good understanding of Excel’s standard Pivot tables and charts before taking this course. If you are a beginner with Excel, you will find that this course goes well alongside Data analysis for accountants: getting started.

This course will enable you to:

• familiarise yourself with the user interface of Power Pivot
• use different tools to set up relationships in Power Pivot
• use Power Pivot to quickly insert pivot tables, charts, form multiple tables and analyse data
• work easily with calculations and data models across multiple tables of data using DAX
• understand the basics of DAX, including time intelligence functions that aren’t found in Excel.

Helping accountants grow

Disclaimer: This course and outline is provided by a third-party course provider. All course bookings are subject to the terms and conditions set by the course provider. Please see individual supplier pages for full terms and conditions. ACCA takes no liability for bookings made with third-party suppliers.