Microsoft Excel Advanced

Microsoft Applications

Find out more

Download PDF copy

Course Code: XL19L3

Duration: 1 Day

Delivered: Virtually


This course is aimed at people who want to expand their knowledge into some of the more advanced functions, analyse/summarise tables of data and automate common tasks.


Students who wish to attend this course must have a good knowledge of Excel and be competent at working with formulas using absolute cell references, use basic functions like sum, average, max, min, count and be able to write formulas across multiple sheets and multiple workbooks.


On completion of this course delegates will be able to:


Introduction and Objectives

Using Logical, Lookup and Statistical Functions

Using Auditing Tools

Creating/Revising Pivot Tables and Pivot Charts

Using Range Names

Protecting Excel Data

Using Data Validation

Introduction to Basic Macros

Action Planning

Review of Programme

Download PDF copy

Excel Frequently Asked Questions

Pricing from

Dedicated Courses

Virtual - £645 per day for up to 8 delegates

Onsite - £695 per day for up to 10 delegates

Public Schedule Courses - £150 per delegate


Onsite prices are for courses in London. For other locations, trainer expenses will apply.

All prices displayed are exclusive of VAT.

Apply for this course

Leave us your email address and phone number and one of our team will be in touch to find out a bit more about you and discuss next steps.

Thank you, we'll get in touch
Oops! Something went wrong while submitting the form. Please try again or give us a call.