MICROSOFT EXCEL

Mastering PowerPivot

Mastering PowerPivot is a course that introduces a powerful Excel add-on offering Business Intelligence functionality and reporting within the familiar Excel environment. This course is ideal for individuals seeking a comprehensive understanding of Excel PivotTables and those who need to summarise and manipulate substantial volumes of data efficiently.

3

2-Day Course

Max 15 Learners

Virtual, On-Site or Hybrid

Pre-requisites

Participants must have very good knowledge of Excel, including a working knowledge of PivotTables and an understanding of nested functions.

Why Attend?

By the end of this course, you will have gained the skills necessary to become a proficient Excel user with the added power of Visual Basic for Applications (VBA). With this knowledge, you can streamline your workflow and automate repetitive tasks in Excel, saving valuable time and effort. You’ll be able to create custom functions and macros to perform complex calculations and data manipulations, making data analysis more efficient and accurate. The ability to interact with Excel objects through VBA code opens up new possibilities for data visualization and reporting. Moreover, you’ll have the expertise to customize Excel to suit your specific needs, whether it’s creating user-friendly interfaces with custom forms or extending Excel’s functionality with personalized macros. Excel VBA empowers you to be more productive, solve complex problems, and leverage Excel’s full potential as a powerful and flexible tool for data management and analysis in various personal and professional scenarios.

 

What Will You Gain?

After this course, you will learn how to:

  1. Start Excel and launch the PowerPivot window
  2. Add data to PowerPivot
  3. Prepare data for analysis
  4. Format and amend the layout of data
  5. Create a Relationship between Two Tables
  6. Preform calculations in PowerPivot Graphics
  7. Create a PivotTable or PivotChart Report
  8. Create Key Performance Indicators (KPI’s) in PowerPivot

What Learning Materials Are Included?

We supply the following for virtual and face to face training:

  1. Comprehensive learner manual
  2. Digital cue cards with quick tips and shortcut keys
  3. Highly practical, integrated and engaging learning experience

For all virtual sessions we provide an end-to-end service including:

  1. Scheduling and hosting of all Microsoft Teams sessions
  2. Delegate invitations and reminders
  3. All related training correspondence and IT support during workshops
CONNECT WITH OUR TEAM

Gained practical knowledge!

This workshop exceeded my expectations. The facilitator worked at a good pace and really knows her stuff.
I gained practical knowledge through the use of the training examples and shortcuts. Thank you!

Cale Hollis

CA, EY

I left feeling confident!

Great workshop! A lot was covered in a short space of time and yet I left feeling confident. Well done!

Lindelani Dali

CSO, BASF SA