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

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

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...