Excel Advanced

This course is designed to take delegates through performing complex data analysis, using complex formulae, importing and exporting of data and introducing them to recording macros and editing in the Visual Basic environment.

 

One Day Course 

Course Outline (PDF)

Course Objectives:

  • Consolidate the basics 
  • Data Validation 
  • Look Up Function
  • If Statements 
  • Protection 
  • Beyond Basic Functions 
  • Views and Reports
  • Combine Formula
Excel Green Logo Microsoft. Green book with white x in centre
Price: £185 + vat

Dates

  • Wednesday 17th September 2025
  • Wednesday 15th October 2025
  • Wednesday 19th November 2025
  • Wednesday 10th December 2025
  • Tuesday 20th January 2026
  • Thursday 19th February 2026
  • Tuesday 17th March 2026
  • Thursday 9th April 2026
  • Tuesday 19th May 2026
  • Tuesday 16th June 2026
  • Thursday 16th July 2026
  • Wednesday 19th August 2026
  • Tuesday 15th September 2026
  • Thursday 8th October 2026
  • Tuesday 17th November 2026
  • Thursday 10th December 2026

Excel VBA

This comprehensive course is designed to teach students how to save time in Excel with the easy-to-use VBA programming language and macros.

Find out more...

Excel Formulae & Functions

This course will provide a thorough grounding in the use of calculations in Excel.

Find out more...

Excel Charts, Pivot Tables & Macros

For delegates who use Excel to store and analyse data instead of Microsoft Access.

Find out more...