Course Overview

Extend your knowledge of Excel’s advanced features and learn how to perform more complex tasks. This workshop will help put the full power and potential of Excel at your fingertips.

Course Content

•          Pivot tables

•          Data consolidation

•          Using outlines

•          Lookup functions

•          Statistical, Math and Trigs functions

•          Nested and Array functions

•          Data tables

•          Data validation

•          Auditing spreadsheets

•          Introduction to Macros

Benefits for the individual

•          Set yourself apart as an expert user of Excel in the workplace

 •         Streamline your tasks, with all the hints and tips you need to save time and boost efficiency

Benefits for the organisation

•          Microsoft Excel practitioners with high-level skills

 •         Increased productivity, efficiency and morale in the workplace