ACPD logo

Power Pivot: Getting Started

(25 reviews)
by Paula Guilfoyle

This course has been designed to take the novice Power Pivot user to a level where they are comfortable working with Power Pivot models and using Pivot tables and charts. You'll also be able to carry out calculations and time intelligence functions by learning the basics of DAX.

£100+vat
4 CPD hours
120 days' access

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.

    Look inside

    Contents

    How it works

    Author

    Paula Guilfoyle

    Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

    Reviews

    4.2
    (25 reviews)
    5
    4
    3
    2
    1
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.