Our Solutions

Master Microsoft Excel in just 45 minutes Become a whiz at Pivot tables

A pivot table is an incredibly powerful tool in Excel that can be used to analyse, explore and summarise your data, allowing you to create reports in seconds

Pivot tables extract meaning from that seemingly endless jumble of numbers on your screen. And more specifically, it lets you group your data together in different ways and reorganise it so you can reveal useful information and draw helpful conclusions more easily.

What will you learn?

  • Getting to know Pivot tables
  • Prepare your data for various analysis
  • Learn how to analyse data using the many pivot table features
  • Explore how to segment, organise, subtotal and use calculated field
  • Use formulas and pivot tables together for a deeper dive
  • Create standard dashboards using pivot tables

Pivot

Pay R250 per 45-minute course
or
R747 for the bundle of 6 courses

These 45 minutes training sessions are delivered via our practical and engaging VILT (Virtual Instructor-Led Training) solution.

Our VILT training simulates our quality classroom learning experience as you can see, hear and engage with the Instructor in real-time, all from the comfort of your own space.
The short, impactful sessions enable you to easily move from learning to application.