PowerPivot for controllers

Target Audience

Controllers and business/finance analysts who want to take their reporting and analytical capabilities in Excel one step further.

Why attend?

For years on end Excel has been the most used reporting and analytical tool by finance. With the arrival of PowerPivot, the game might just have changed.

When faced with large amounts of data that need to be integrated from different data sources in one report, the use of Excel often was tedious, sub-optimal and prone to errors.

This training course will show you how PowerQuery and PowerPivot can help you meet your needs as a controller whilst retaining your flexibility compared to larger IT tools.

Course objectives

During this training course we will focus on how you as a controller / finance professional can use PowerPivot in your daily routines. Not merely a "point and click" training but designed specifically for the finance professional / controller and his/her context.

During the training we will:

  • learn how large amount of data can be integrated and combined by using PowerPivot and PowerQuery functionalities.
  • combine different datasources in one powerful pivot table.
  • show how you can apply the PowerPivot functionalities for your analytical and reporting needs as a controller.
  • use PowerPivot as a reporting tool for your standard reports.

Practical information

The training is a 1-day training course. A good understanding of Excel and conceptual understanding of databases is a prerequisite upon joining this training. Please consult our training calendar for the upcoming training courses. The subscription form can be found here as well.

Want more information or you have a specific question? Don't hesitate to contact us via controllertraining@trifinance.be


Subscription fee for this 1-day training course is € 700 (Excl. VAT) for a single subscription. If you would like to subscribe multiple participants, you can contact us and we will provide you with a tailored offer.

More specific training needs?

Have a look at our tailor-made offering, designed specifically to fit your needs and possible within your own ERP/BI. Or contact us for more information on controllertraining@trifinance.be