Event Details

This event is running from 27 September 2022 until 5 October 2022. It is next occurring on September 27, 2022 9:00 am

  • Venue: online
  • Categories: ,
  • Upcoming Dates:

Looking to take your Excel skills to the next level?

You may have been working with Excel in you role and may be confident with the basics. If this is you then this training will help you grow your confidence and cement your current knowledge. This will be a full days training course and you will be encouraged to ask questions through out the training. This training will be delivered over 2 sessions.

The course will include content –

  • Working with multiple Excel workbooks and worksheets
  • Formulas recap – to ensure everyone understands the basic concepts
  • Using formula auditing tools
  • Excel worksheet tables (The must use tool)
  • Filtering data (We’ll delve deep in to this – it’ll wow you)
  • Freeze panes (There are 2 golden rules to getting this right)
  • Logical Functions – IF and IFS
  • Lookup functions – VLOOKUP and XLOOKUP
  • An Introduction to Pivot Tables (including Slicers)
  • All about conditional formatting
  • Using Filling techniques
  • Plenty of tips, tricks and shortcuts

This training will be delivered over two parts:

Part 1 – 27 Sept 9am-12pm

Part 2 – 5 Oct 9am-3pm

£130pp

Book onto this course