Masterclass in Excel Tips & Tricks Intermediate – 9th & 10th June

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 9th & 10th June 9.30-12.30 (both days)

 

Objectives

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.

 

Content

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