Excel PivotTables and PivotCharts

Microsoft Excel PivotTables and PivotCharts are powerful data processing tools that facilitate data summarisation and visualisation, they are found in data visualisation programs and business intelligence software. The course builds on participants’ existing Excel knowledge, integrating advanced tools and functions to analyse information and use PivotTables as a foundation for Dashboard reports.

1-Day Course

Max 15 Learners

Virtual, On-Site or Hybrid


Participants must have advanced knowledge and skills in Excel and Dashboard Reporting.

Why Attend?

PivotCharts complement PivotTables by adding visualisations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns and trends. Both PivotTables and PivotCharts enable you to make informed decisions about critical data in your enterprise. Being equipped with the Excel PivotTables and PivotCharts you will be able to advance onto other Excel workshops.


What Will You Gain?

After this course, you will:

  1. Analyse and process data in advanced ways
  2. Create and manipulate advanced charts
  3. Format charts in powerful and impactful ways
  4. Create combination charts and use graphical elements
  5. Sort, filter and advanced filter data
  6. Work effectively in tables
  7. Create and modify PivotTables
  8. Use lookups and data tables

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

Brilliant workshop!

What a brilliant workshop, very helpful, I will use a lot of what I learnt in everyday work.

Shona Galal

Assistant Manager, EY

Completing reports will never be the same again!

I have learnt a lot from this workshop, I was able to understand it thoroughly. Completing reports will never be the same again.

Tshimangdzo Loshiwha

F&R Graduate, Thomas Reuters

Simplified all the different tools!

Great workshop, I now have a better understanding of all the different tools that are available – it has simplified it for me.

Tabea Manne

Account Manager, BASF