Masterclass in Excel - the tricks, tips and shortcuts
Mon 18th Jan 9:30am to 12:30pm - Continues Tues 19th Jan 9:30am to 12:30pm
Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.
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.
Overview – Tips & Tricks
Customise Excel – Quick Access Tool Bar
Audit Options- Advanced Options
Mixed Absolute Reference
The Outline Feature
Advanced Filter Macros
Nested If Statements
V Lookups – Nested V Lookups
Using more Advanced Formulas ( Indirect, Match Etc)
Templates The Developer Tab ·
Q&A and Review