Power Pivot Training - Advanced Excel - 1 Day Course

Power BI team training  |  Hosted on-site or remotely  |  Book your training today!

Key Points

  • Power Pivot is a self-service BI solution
  • It is a FREE for Excel 2010 and part of Excel 2013, Excel 2016, Microsoft 365 and Power BI Desktop
  • Power Pivot is often used to automate routine reporting
  • Power Pivot avoids the need to use VBA, macros, and VLOOKUPs for complex reports
  • CMBI provides training on Power Pivot, Power Query and Power BI

Unlock the full reporting and data analytics capability of Excel with Power Pivot

Excel is the analysis tool of choice for many power users and analysts. CMBI's Power Pivot training course can help you realise the full capability of Excel and its latest features.

CMBI's "Introduction to Power Pivot" training introduces you to some of the most powerful data analysis capabilities within the Excel environment.

Leverage your Excel knowledge

If you or your team are spreadsheet gurus then nothing short of full spreadsheet functionality will do. Power Pivot is an end user data integration and analysis tool that can be used to automate even the most complex reports and analytics whilst remaining completely within the Excel environment.


Using Power Pivot, users can quickly automate routine reporting and analysis because they are already familiar with the spreadsheet tool and data. They can continue to use the spreadsheet to create the layout and presentation but the content will now update automatically when the underlying source acquires new data.


How it works

We come to you or host remotely

saving you travel time

Interactive workshop

giving you valuable hands-on experience with personalised support

One day course from 9am-5pm

Team can't spare a full day? Ask us about splitting the course across multiple sessions.

Training Materials provided

so you can recap after the session.

See full details below

$1,999 + GST per team per day

Each day of training includes optional Q&A, plus supporting course guide.

Want more info?

Contact us today

How can Power Pivot help me?

With Power Pivot you can:

  • Create faster, more efficient spreadsheets
  • Reduce report preparation time
  • Reduce workbook complexity and reliance on VBAs and macros
  • Provide greater insight to stakeholders

During the training workshop you will gain valuable hands-on experience with Power Pivot through a series of practical exercises. At the end of the session you will know how to use Power Pivot to simplify your existing Excel spreadsheets, as well as be able to design flexible and scalable data models for your future reporting requirements.


Topics Covered

Introduction to Power Pivot

Learn how Power Pivot can help you create reports that add real business value in Excel

Building a data model with Relationships

Understand how to create a flexible and scalable data model for your reporting solution using relationships

Using DAX to create calculated columns & measures

Learn how to use DAX, Power BI's powerful formula language to add new columns and measures to your reporting and analytics

Time intelligence

Create time intelligence analytics to gain instant insight into year-to-date and prior period performance

Creating a Dashboard in Excel

Learn techniques for creating professional-looking and interactive reports in Excel

Introduction to Power BI Desktop

Learn how to import your Excel data model into Microsoft's Power BI Desktop application, to make use of the extensive visualisation library

Want more info?

Download a detailed course overview


Delivery Method

Each workshop is presented as a series of practical exercises, that give attendees hands-on experience of all aspects of Power BI. All our training exercises are supported by detailed course materials for reference during and after the training day.


CMBI can present this training session either in-person onsite, or host it live remotely, using industry-leading video conferencing software. Learn more about Remote Training here.


Materials and support

Our course materials support learning and re-enforcement well beyond the workshop.

Each session includes an associated set of support materials to help attendees complete the tasks on the day, as well as provide support after course completion:

  • Supporting course notes PDF document (approx 90 pages, printed on request)
  • Complete Excel models for all exercises
  • Datasets for all examples
  • Optional Q&A time at the end of the session for anyone interested in asking specific questions

More Training Options

Don't see what you're looking for? CMBI offer a variety of training to suit all levels of experience:

See CMBI's training page for details of all courses we offer.