This Advanced Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, audit and analyse worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Course outline

Module 1: Using Pivot Tables

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • More Pivot Table Functionality

Module 2:  Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Module 3: Data Tools

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Module 4:  Working with Others  

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Module 5: Recording and Using Macros

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Module 6: Random Useful Items

  • Sparkline
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files
  • Merge Workbooks

Module 7: Microsoft Excel Features that were New in 2013

  • Using Slicers to Filter Datas
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Module 8: Features New in 2016

  • PivotTable Updates
  • Ink Equations
  • Multi-Select Option in Slicers
  • Quick Shape Formatting
  • Sharing with SharePoint or OneDrive

Course cost

R1,700 p/p

Course Duration
One Day

Every individual that attends this course will receive a comprehensive training manual as well as an attendance certificate. Catering will be provided.

Gallery, coming soon!