ICAEW.com works better with JavaScript enabled.

Supercharge your PivotTables with Power Pivot

Author: Excel community

Published: 02 Nov 2020

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.
Broadcast on 4 November 2020

Webinar resources

In this webinar we examine:

  • Connecting related tables quickly and easily using the Data Model
  • Using calendar tables to iron out problems with time-based data
  • Using intelligent DAX functions to easily make running totals, prior year figures, grand totals, and more
  • Create KPIs and visually present them easily

This webinar assumes prior knowledge of basic Pivot Tables – if you need a refresh check out our comprehensive guide!

This content is only visible when the visitor has consented to allow all cookies. stream amg title

This video content is provided by StreamAMG. We ask for your permission before anything is loaded, as they are using cookies and other technologies. You may want to read StreamAMG owner's PA Media Group privacy policy before accepting. If you are happy to view this content, please choose Allow all cookies.

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid