Search courses 👉
Professional Training

Excel Advanced

STL, In London (+21 locations)
Length
1 day
Price
195 - 284 GBP excl. VAT
Next course start
8 October, 2024 (+64 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
195 - 284 GBP excl. VAT
Next course start
8 October, 2024 (+64 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Advanced

STL courses

  • At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 64 start dates

8 October, 2024

  • Virtual Classroom
  • Online
  • English

22 October, 2024

  • Virtual Classroom
  • Online
  • English

28 October, 2024

  • Classroom
  • London
  • English

12 November, 2024

  • Virtual Classroom
  • Online
  • English

21 November, 2024

  • Classroom
  • London
  • English

2 December, 2024

  • Virtual Classroom
  • Online
  • English

20 December, 2024

  • Classroom
  • London
  • English

10 January, 2025

  • Classroom
  • London
  • English

14 January, 2025

  • Virtual Classroom
  • Online
  • English

31 January, 2025

  • Virtual Classroom
  • Online
  • English

5 February, 2025

  • Classroom
  • London
  • English

28 February, 2025

  • Virtual Classroom
  • Online
  • English

5 March, 2025

  • Classroom
  • London
  • English

17 March, 2025

  • Virtual Classroom
  • Online
  • English

2 April, 2025

  • Classroom
  • London
  • English

8 April, 2025

  • Virtual Classroom
  • Online
  • English

28 April, 2025

  • Classroom
  • London
  • English

2 May, 2025

  • Virtual Classroom
  • Online
  • English

19 May, 2025

  • Virtual Classroom
  • Online
  • English

23 May, 2025

  • Classroom
  • London
  • English

13 June, 2025

  • Virtual Classroom
  • Online
  • English

18 June, 2025

  • Classroom
  • London
  • English

30 June, 2025

  • Virtual Classroom
  • Online
  • English

14 July, 2025

  • Classroom
  • London
  • English

23 July, 2025

  • Virtual Classroom
  • Online
  • English

8 August, 2025

  • Classroom
  • London
  • English

12 August, 2025

  • Virtual Classroom
  • Online
  • English

29 August, 2025

  • Virtual Classroom
  • Online
  • English

3 September, 2025

  • Classroom
  • London
  • English

19 September, 2025

  • Virtual Classroom
  • Online
  • English

29 September, 2025

  • Classroom
  • London
  • English

13 October, 2025

  • Virtual Classroom
  • Online
  • English

28 October, 2025

  • Classroom
  • London
  • English

7 November, 2025

  • Virtual Classroom
  • Online
  • English

20 November, 2025

  • Classroom
  • London
  • English

24 November, 2025

  • Virtual Classroom
  • Online
  • English

12 December, 2025

  • Virtual Classroom
  • Online
  • English

16 December, 2025

  • Classroom
  • London
  • English

5 January, 2026

  • Virtual Classroom
  • Online
  • English

12 January, 2026

  • Classroom
  • London
  • English

26 January, 2026

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Training Course Content



Using logical functions

The IF function (recap)
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions

Working with Lookups

The VLOOKUP function
The HLOOKUP function
The XLOOKUP function (365)
INDEX and MATCH

Data Validation

Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list

PivotTables and PivotCharts

Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables

Macros

Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Expenses



List price £330, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact form

Fill out your details to find out more about Excel Advanced.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Reviews by course attendees

Average rating 4.8

Based on 12171 reviews.
Reviews are published according to our review policy.
Write a review!
Kimberley
5/5
16 Aug 2024

Very good!

Ben
5/5
16 Aug 2024

Jens was Brilliant!!

Victoria
5/5
13 Aug 2024

Intermediate course was much easier than I expected. This Advanced course was really good.

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads