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

Price: £185 + vat

Dates

Tuesday 15th April 2025
Friday 16th May 2025
Wednesday 18th June 2025
Wednesday 16th July 2025
Thursday 14th August 2025
Wednesday 17th September 2025
Wednesday 15th October 2025
Wednesday 19th November 2025
Wednesday 10th December 2025

Follow on courses:

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