In addition to the Essential Excel Tools and Techniques course, we plan to offer in-depth training of advanced-level topics that we believe cannot be adequately covered in a general course. At present we offer just one course under the Excel Advanced Topics heading, namely PivotTables and PivotCharts.

This course is aimed at the delegate who has a very sound knowledge of Microsoft Excel, but needs to understand the use of PivotTables and PivotCharts to analyse large amounts of raw data.

  • Course Name: PivotTables and PivotCharts
  • Duration: One day
  • Requirements: Sound MS Excel literacy
  • Cost: R2100 per person
  • Topics:
    • Introducing PivotTables
    • Building a PivotTable
    • Manipulating a PivotTabel
    • Changing the PivotTable View
    • Filtering a PivotTable
    • Customising PivotTable Fields
    • Setting PivotTable Properties
    • Creating a PivotChart
    • Calculating in a PivotTable