Microsoft Excel Adv Course
Microsoft Excel Adv Course
Take the ultimate deep dive into Excel. Learn advanced features such as pivot tables and VLOOKUP to help analyse and summarise large datasets.
Perform more complex data analysis to help you make informed business decisions. Discover techniques to reduce audit risk by ensuring data accuracy and integrity.
Enhance your ability to manage and manipulate data effectively, saving time and increasing productivity. This course will give you the advanced Excel skills necessary to excel in your professional career.
Key Learning Points
Key Learning Points
- Master VLOOKUP, INDEX, MATCH and nested formulas
- Reduce audit risk with data validation techniques
- Build and manage PivotTables with slicers
- Create interactive charts linked to PivotTables
- Automate tasks with macros and Power Query
If attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have attended our Excel Intro and Intermediate courses or have equivalent working knowledge before joining this class.
Who is this course for?
For experienced Excel users in finance, data analysis and operations who want to master advanced formulas, PivotTables and automation. Requires our Excel Intro and Intermediate courses or equivalent.
Expert Trainers
Course leader is an experienced industry expert
Course Dates
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | Online | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 15th Jul 26 | Wed | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 28th Aug 26 | Fri | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 25th Sep 26 | Fri | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 13th Oct 26 | Tue | Online | Available | £349.00 | £349.00 + VAT | ||
| 6th Nov 26 | Fri | London Islington | Available | £349.00 | £349.00 + VAT | ||
| 16th Dec 26 | Wed | Online | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 15th Jul 26 | Wed | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 25th Sep 26 | Fri | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 6th Nov 26 | Fri | London Islington | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | Online | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 28th Aug 26 | Fri | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 13th Oct 26 | Tue | Online | Available | £349.00 | £349.00 + VAT | ||
| 16th Dec 26 | Wed | Online | Available | £349.00 | £349.00 + VAT |
Course Dates
26th Jun 26 (Fri)
15th Jul 26 (Wed)
28th Aug 26 (Fri)
25th Sep 26 (Fri)
13th Oct 26 (Tue)
6th Nov 26 (Fri)
16th Dec 26 (Wed)
Course Outline
Expanding your functions toolbox
Using Nesting formulas
Using AND & OR
VLOOKUP
IFERROR/IFNA
INDEX & MATCH
Reducing your audit risk
Data validation
Using Trace Precedents
Using Trace Dependents
Removing Arrows
Error checking
Evaluate Formula
Effectively analysing your data
Creating Pivot Tables
Changing the look of your pivot
Grouping your data
Updating Pivot Tables with new data
Filtering your data with a Slicer
Linking slicers to more than one Pivot Table
Using a timeline
Creating a Pivot chart
Using What If Analysis
Goal Seek
Scenarios
Career paths
Roles this course supports
People training on Microsoft Excel Adv often work in the careers below.
Who attends?
Career Progressives
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
Career Changers
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Graduates
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn Your Way
Face To Face
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Live Online
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Team Training
Upskill your team together. Build your team and develop consistency, and collective confidence.
Three Steps To Success
Identify Your Path
Define your direction with purpose, aligning your learning journey to personal and career goals.
Learn With Experts
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Earn Certification
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
Further Reading
Why You Should Learn Microsoft Power BI?
Microsoft Power BI turns raw data into clear, actionable insights. Find out what it can do, how businesses use it and…
8 Tips To Make You An Excel Expert
Learning Excel is always useful whether you work with data or in finance. Here are 8 tips to help you master…
How Learning Power BI can help your Career
Power BI is one of the most in-demand data skills in business. Find out what it can do, who uses it and how learning…