Masterclass in Excel Tips & Tricks Intermediate – 27th & 28th Oct 9.30-12.30

Date Location Price / Members Price Places Trainer Book Online or Enquire

This course is not suitable for beginners

INTERMEDIATE – Online Workshop Duration 2 x Half day workshops 27th & 28th October 9.30-12.30(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.



  • Overview – Tips & Tricks
  • Customise Excel
  • Formula – Best Approach
  • Functions
    • Stats
    • Date
    • Text
  • Freeze Panes
  • Formatting
  • Audit Options
  • Sub-Totals – Paste Options
  • IF Statements
  • Pivot Tables
  • Pivot Charts
  • Reports
  • Conditional Formatting