Click here to send this to a colleague or friend.

Making head or tail of PivotTables

Microsoft Office version 2013, 2016 & 365

Use PivotTables and PivotCharts with comfort and ease

One of the most powerful features in the Excel package, PivotTables are widely recognised for their applications – but very rarely is their full functionality ever harnessed. In fact, current estimates show that as few as 12% of Excel users ever utilise PivotTables – with only a handful of that 12% harnessing the full range of functionality available to them.

PivotTable power has increased and if you do any of these, you can do it better and faster and with PivotTables:

  • Analyse data to identify trends
  • Detailed reporting and analysis
  • PivotTables are the answer to get the reports you want


Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists


Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

Register now for this workshop

Understanding PivotTables and PivotCharts

  • Understanding How PivotTables Work
  • Working with PivotTables
  • Creating a PivotTable Report
  • Creating a PivotTable Report with Multiple Columns
  • Creating a PivotChart

Understanding Data Sources for PivotTables

  • Using Excel Data from the Same Workbook
  • Using Excel Data from another Workbook
  • Using Data from Databases
  • Queries
  • OLAP Cubes
  • Creating a PivotTable Report from Data in an Access Database
  • Using Other External Data Sources

Using PivotTable Tools and Formatting

  • Using the Layout Dialog Box in the PivotTable and Pivot Chart Wizard
  • Understanding the PivotTable Toolbar
  • Customizing the PivotTable Toolbar
  • Using the PivotTable Menu
  • Setting PivotTable Options
  • Format Options
  • Data Options
  • Formatting PivotTables
  • Autoformatting a PivotTable
  • Changing the Number Format
  • Changing Other Formats
  • Applying Formatting to a PivotTable Report

Working with PivotTable Components

  • Using Drop Areas
  • Using the Column Drop Area
  • Using the Data Drop Area
  • Using the Page Drop Area
  • Using Settings for Data Fields
  • Using Different Summary Functions
  • Sort Options

Understanding and Using PivotCharts

  • Understanding PivotCharts
  • Creating a PivotChart
  • Create a PivotChart from an Existing PivotTable
  • Create a PivotChart from Scratch
  • Understanding and Changing PivotChart Types
  • Understanding a PivotChart's Structure
  • Creating a 3-D PivotChart

Using PivotTables with Multidimensional Data

  • Using Multidimensional Data
  • Understanding Multidimensional Data
  • Flat Data
  • Relational Data
  • Multidimensional Data
  • Creating a PivotTable from a Cube File
  • Working with OLAP PivotTables
shadow shadow

Who should attend?

  • Marketing Managers
  • Sales Managers
  • Financial Managers
  • Chief Information Officers
  • Business Analysts

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 14th October 2020 at Benvenuto Conference in Randburg

13th November 2020 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

4th December 2020 at Benvenuto Conference in Randburg

26th January 2021 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

Map: View map
Duration: 1 Day
Cost: R2 350.00 excl VAT
R2 702.50 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates

In-house at your offices
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions



Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Microsoft workshop presenters are Certified Microsoft Office Specialists
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time

Workbooks and workshops are aligned to the prevailing Unit Standard;
Front Foot provide business training to business people;
Training is held at premium training venues