Power Pivot: 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

About the course

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.

Note: Power Pivot is not currently available in Excel for Mac.