Master Class Excel Tips & Tricks Advanced – 14/15 February 2023 – €65

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)



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


Validation Lists

Macro Buttons

Nested If Statements

V Lookups – Nested V Lookups




Pivot Tables

Pivot Charts



Goal seek

Using more Advanced Formulas

( Indirect, Match Etc)


The Developer Tab

·       Index

·       Nested If Statements

·       PMT Function


Q&A and Review