Excel Masterclass

Description

An advanced workshop based course for a small group of 6.
This will include Excel sophisticated exercises of a lengthy nature to stretch your Excel imagination and skills!

Who is this course for?
This should only be attended by a trainee who has been on a Chamber Advanced Excel course and wants to improve further their skills in the workplace.

• Logistics planner
• Office specialist
• Accountant or finance specialist
• IT person
• Involved with regular Excel work

Course Overview
This highly interactive course will take the format of:

• Looking at problems and solutions using nested statements
• Developing Pivot Tables and Charts
• Writing macros and editing them
• Understanding scenario and Indexes
• Understanding conditional formatting with formulas

Course Agenda
• Open workbook and Consolidations, ISERROR, VLOOKUP, IFERROR
• Pivot Tables, Charts, Sorting, Slicing
• Macros and Editing Macros
• Nested Statements using VLOOKUP
• Nested INDEX MATCH function and VLOOKUP with Indirect Functions
• Scenario manager and Data Tables
• Conditional formatting