This advanced Excel level 3 course is for delegates who have a good working knowledge of Excel, but want to take things further.
The day will consist of 3 x 90 minute sessions.
Course Objectives
Be the end of the day you’ll be able to:
- Apply conditional formatting using a formula
- Nest functions together (e.g. nested IF, IF with AND/OR)
- Use dynamic array functions to create formulas whose results spill across multiple cells
- Perform LOOKUPs
Course Outline
Session 1
- Understand absolute, relative and mixed cell references
- Use conditional formatting with a formula
- Recap – using Names
- Use data validation (drop-down boxes) to enter data
Session 2
- Recap IF / COUNTIFS / SUMIFS
- Nested IF / IFS
- Nesting IF with AND and OR
Session 3
- Intro to using Lookups – VLOOKUP, HLOOKUP
- Using IFNA to mask errors
- Limitations of VLOOKUP
- XLOOKUP (or INDEX & MATCH if using older versions of Excel)
- Using the FILTER function
If there’s time: splitting text using TEXTSPLIT, TEXTBEFORE and TEXTAFTER, joining text using TEXTJOIN and CONCAT.
Next Date: 30th September 2026, 30th November 2026
At a Glance…
Level: Excel Advanced Course (Level 3)
Equipment/Account needed: Microsoft Excel
Duration: 9:30 am – 3:30 pm
Class Size: 8 approx.
Course Materials: Manual & quick reference guide included
Requirements: It is expected that delegates can use Excel competently, enter formulas and functions e.g. IF, COUNTIF, SUMIFS etc
Cost: £250 (+ VAT)
Course Delivery
There are two options:
Public Courses
Regular public courses are available to everyone. Delivered live with an expert trainer via MS Teams. Perfect for individuals or small groups of attendees. Fully interactive. Delegates will need cameras and mics to participate fully.
Private Courses
Held either in-person (at your venue or ours) or online via MS Teams or Zoom. Private courses allow us to tailor the content to your organisation’s challenges and goals. If you have 3 or more delegates, please contact us to book a private course.