Microsoft Excel - Advanced

Course Overview

This 1-day course is designed for anyone creating large reports / dashboards and need options to automate and streamline the initial build time and refresh time using advanced functions and techniques.

Related Courses

Here is a selection of courses that we think you might also be interested in.

Introduction to Microsoft Excel
Microsoft Excel - Intermediate

This course qualifies for Continuous Professional Development hours. Learn more about CPD

Timetable

This course runs from 09:30-16:30 and covers the following topics:

Template Design
Array Formulas
Dynamic Named Ranges
Text manipulation Functions

Non 365 version
Recording Macro
The Visual Basic Editor
Editing Macro concepts

365 version
Recording Office Scripts
Script Editing / Sharing

 

Benefits

  •  Create dynamic lists and Charts using named ranges
  •  Understand the use and implement array Formulas
  •  Manipulate Text with Excel
  •  Automate spreadsheets and make them interactive for other users
  •  Record repetitive series of keystrokes and commands
In-Person Training
Live Virtual Training
Book your place on one of our scheduled courses...
There are currently no dates scheduled for this course.

If you would like to take this course please consider one of the three alternative booking options detailed below.
...or create a training session that suits you using one of the options below.
Inhouse Training
1-5 delegates £1,250.00
6-10 delegates £1,690.00
Each additional £100.00
1-2-1 Executive Coaching
½ day on-site£800.00
1 day on-site£1,250.00
Please choose a training location
Duration
Places
Book your place on one of our online courses...
24th Sep 2025
Full Day
£325.00
Places
23rd Oct 2025
Full Day
£325.00
Places
28th Nov 2025
Full Day
£325.00
Places
...or create a training session that suits you using one of the options below.
Private Virtual Training
1-2 delegates £800.00
Each additional £325.00
1-2-1 Virtual Executive Coaching
½ day 1-2-1 virtually£400.00
1 day 1-2-1 virtually£650.00
U-Choose Virtual Training
Per delegate£325.00
Places
Duration