This course is not suitable for beginners

ADVANCED – Online Workshop – Duration 2 x Half day workshops, 14th and 15th February 2023, 9.30am to 12.30pm (both days)

 

Objective

Many experienced excel users are self-taught. They know how to use most of the main Excel tools, but they don’t know how to use many of them to the best effect, or just aren’t using the power of excel to help them do their work. Taught by someone who has been working with and teaching Excel for 30 years, you will be amazed by how much you will learn.

 

Topics Include 

Overview – Tips & Tricks Customise Excel – Quick Access Tool Bar Audit Options- Advanced Options Mixed Absolute Reference Named Areas Default Settings The Outline Feature Advanced Filter Macros Validation Lists Macro Buttons Nested If Statements V Lookups – Nested V Lookups

Pivot Tables Pivot Charts Consolidation Scenarios Goal seek Using more Advanced Formulas ( Indirect, Match Etc) Templates The Developer Tab ·       Index ·       Nested If Statements ·       PMT Function   Q&A and Review