About Course

Pivot tables help office teams turn long lists of figures into clear summaries. In this course, Johan Botha shows you how to build, sort and group a pivot table in Excel using the kind of sales, stock and attendance sheets your team already works with. You will finish able to answer a manager’s questions in minutes, not hours. Classes run at our Bryanston centre or online.

What Will You Learn?

  • Practise your new skills with real workplace scenarios and worked answers
  • Use simple templates and checklists in your own team
  • Get friendly and fast support from your trainer
  • Downloadable notes, forms and guides for every module

Course Content

Getting Started
A short summary to prepare learners for the lessons in this topic. It appears on the course page under the topic name, so everyone knows what is coming.

  • Introduction to Pivot Tables
    03:54
  • What Is Data?
    04:33
  • Course Outline
    02:44
  • Getting Started
    04:05
  • Pivot tables: Group by month
    07:00
  • Quiz -Pivot Tables
  • Pivot tables: Filter by region
    19:00

Practising the Basics

Project – Master Pivots!

Value Fields

Related Courses

Microsoft Teams & Outlook for Beginners

 (5.00/2)
Thandiwe MokoenaThandiwe Mokoena
R650
See More

Customer Service Skills for Call Centres

 (5.00/2)
Thandiwe MokoenaThandiwe Mokoena
Free
See More

Basic Business English and Email Etiquette

 (5.00/3)
Thandiwe MokoenaThandiwe Mokoena
Free
See More