Master Class Excel Tips & Tricks – 14th & 15th April 2021

Date Location Price / Members Price Places Trainer Book Online or Enquire
14th April 2021 @ 9.30-12.30 Online € 50.00 / € 50.00 4 available

This course is not suitable for beginners

Online Workshop – Duration 2 x Half day workshops 14th & 15th 9.30-12.30 (both days)

Most Excel users, once they have learnt the core Excel skills, are largely self taught. You can pick a lot of how to’s along the way. But you’ve never been shown how to use Excel the best way, by a professional.  The aim of this course is to achieve two goals. To show delegates how to do most every-day tasks much more productively, PROBABLY saving you hours of boring routine work. Along with this we will cover new topics which will broaden your knowledge of use of Excel.


Session 1

Overview – Tips & Tricks

Customise Excel

Formula – Best Approach


•       Stats

•       Date

•       Text

Freeze Panes


Audit Options



Data Functions


IF Statements


Drop-Down Lists


Session 2

Advanced Filter



Import /  Export


Pivot Tables –

Pivot Charts


Conditional Formatting