Excel Advanced Level

Description

Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.

The purpose of this two half-day course is the teach delegates some of the advanced features of Excel.Working with Pivot Tables, Using What If Analysis Tools, Auditing tools and Writing Macros are all covered in this module. Extensive hands-on classroom training is provided throughout.

Pre-Requisites

Delegates should be proficient in essential excel skills before starting this module- See Excel Introduction & Intermediate.

Contents

· Create a PivotTable

· Create a PivotChart

· Create a Macro

· Use Goal Seek

· Use Scenarios

· Use Solver

· Audit Worksheets

· Protect Worksheets and Workbooks

· Use Consolidation

· Apply Conditional Formatting

· Apply Data Validation

· Import and Export information