Advanced Excel Course
Master Excel’s most powerful tools – transform data into insights and automation into action.
5 Star Rated
10+ Years Experience
In-House Training
Public Course Dates
Public course places from £250 per person. In-house team training from £1,000 remote or £1,200 in-person per day for your group.
See detailed pricing information below
Trusted By Teams Across the UK
In the private and public sectors, from SMEs to publicly-listed companies, I've delivered training across a wide range of organisation sizes and sectors.
Not Sure Which Excel Course Is Best?
Not sure if you're quite ready for Advanced Excel?
Take my quick 2-minute Excel quiz or just ask me and I'll point you to the right level.
Training your team? Get in touch and I can help assess the training needs for your organisation.
Master Advanced Excel Skills and Functions
If you’re already confident with the basics and intermediate skills, this course will help you take the next big step into real Excel mastery.
Across a single, practical day, you’ll learn the features and techniques that separate everyday users from true Excel experts - from advanced formulas and data analysis to automation and dynamic arrays.
My Excel training is very hands-on. In your course workbook you will be following along and practising everything that I show you, making the training practical and engaging for you.
My Advanced Excel course will give you the skills and confidence to use some of the most powerful features in Microsoft Excel.
You’ll discover how to:
-
Use advanced Excel functions and dynamic formulas to solve complex problems.
-
Build interactive PivotTables and PivotCharts for professional reports and insightful data analysis.
-
Use Power Query to clean, transform, and combine data effortlessly.
-
Automate repetitive tasks with macros and the macro recorder.
-
Learn the new dynamic array functions to create formulas which produce results in multiple cells at once.
-
Understand advanced logical functions such as nested IF, IFS, AND/OR, SUMIFS, COUNTIFS.
-
Perform advanced lookups using wildcards, multiple criteria and handling duplicates with XLOOKUP, INDEX/MATCH, XMATCH.
Whether you’re an analyst, manager, or experienced Excel user, this course will give you the confidence and technical skill to work faster, smarter, and more accurately than ever before.
You also receive 3 months of personal email support from me for any follow-up questions.
This hands-on course leads on from my Beginner and Intermediate Excel courses, giving you the practical tools and confidence to handle real-world Excel challenges.
View all Excel courses.
Why Advanced Excel Training Matters
Whether you're an analyst drowning in manual work, a manager who lives in spreadsheets, or the unofficial "Excel person" on your team, advanced skills pay for themselves fast.
Advanced Excel skills are some of the most valuable - and most in-demand - in the modern workplace.
With so many features and functions in Excel it can be hard to know where to start. This advanced Excel course guides you through the most useful and practical tools to help you work smarter.
Want Some Extra Tips?
Grab my free Excel Productivity Toolkit to discover features which most people don't know about to save time and make your work easier.
Excel Advanced Course Content
My Excel courses are very hands-on and practical. You will be using Excel throughout the day to practice everything we cover.
For in-house training the course can be tailored to your specific requirements.
Please Contact Me to discuss in-person or remote training for your team.
Every participant receives:
-
A detailed course workbook with step-by-step explanations for all topics.
-
Hands-on examples for everything to make learning practical and engaging.
-
Post-course exercises to help you keep practising what you’ve learned.
-
Certificate of Completion after the course.
-
Post-course email support - you can email me with questions for 3 months after the course, answered personally.
Advanced Logical Functions
Learn to make Excel truly intelligent with logic that responds to any situation. Combine multiple conditions and automate complex decision-making across your spreadsheets. ✔ Use AND and OR to combine criteria. ✔ Create nested IF and IFS formulas for multi-level logic. ✔ Summarise and filter data using COUNTIFS, SUMIFS, and related functions.
Advanced Lookups and Data Retrieval
Master the next generation of lookups and learn to pull exactly the data you need, even in complex, multi-sheet workbooks. ✔ Harness XLOOKUP and XMATCH for flexible searching. ✔ Combine INDEX and MATCH for powerful, dynamic lookups. ✔ Use wildcards and multi-criteria lookups to find anything fast. ✔ Handle duplicates and missing results confidently.
Importing and Cleaning Data
Before you can analyse data, it needs to be tidy and usable. This module shows quick, practical ways to clean and prepare data for accurate analysis. ✔ Remove blank rows and duplicates instantly. ✔ Adjust text formatting with UPPER, LOWER, and PROPER. ✔ Eliminate extra spaces to tidy your data with TRIM. ✔ Separate and reformat data using Text to Columns and Flash Fill.
Advanced Data Cleaning with Power Query
Take data transformation to the next level. Power Query lets you import, reshape, and combine data from multiple sources without formulas or a lot of manual edits. ✔ Import data from spreadsheets and external sources. ✔ Clean and transform data using Power Query steps. ✔ Combine tables, remove errors, and automate repetitive cleaning tasks.
Dynamic Array Functions
Explore Excel’s most exciting recent upgrade: dynamic arrays. These advanced formulas spill results automatically and can completely change the way you analyse data. ✔ Work with UNIQUE to extract items from a list. ✔ Use SORT and SORTBY to sort multiple columns. ✔ Create number lists with SEQUENCE and RANDARRAY. ✔ Filter and reshape data dynamically using FILTER. ✔ Understand how to combine arrays with traditional functions to create brand new outcomes
Data Validation and Control
Keep your data clean, consistent, and error-free by controlling what users can enter. ✔ Apply different types of validation rules. ✔ Create custom alerts to guide users when entering data. ✔ Build drop-down lists and dependent drop-down lists for structured data entry.
Pivot Tables and Pivot Charts
Learn to analyse and summarise large datasets in seconds. PivotTables and PivotCharts are Excel’s most powerful analysis tools once you know how to use them effectively. ✔ Build PivotTables from raw data and adjust layouts. ✔ Group, filter, and summarise information visually. ✔ Create multiple calculations from the same data. ✔ Create interactive PivotCharts for professional reporting. ✔ Add slicers for easy dashboard-style interactivity.
Macros and Automation
Automate repetitive tasks to save time and reduce errors. You don’t need to be a programmer to start recording your own macros. ✔ Understand how macros can save you time and effort. ✔ Record actions using the Macro Recorder. ✔ Save and reuse your macros across workbooks. ✔ Create a custom ribbon for easy access to macros and common tools.
Meet Your Trainer
Mark Baglow
Hi, I'm Mark. When you book this course, you get me – not an associate, not a script read off a slide.
I use Excel every day - not as a party trick, but for real work - so the training is genuinely practical, focused on what actually saves you time rather than clever functions you'll never touch.
I've spent fifteen years in the world of education, training and development. During my career I learned the thing that still shapes every course I run: people don't remember what you tell them, they remember what they do.
My training is practical, hands-on and refreshingly jargon-free – real tools you'll use on Monday morning, not dry theory you'll have forgotten by lunch.
I'm a certified DISC analyst, and I've designed and delivered leadership, management and communication training across sectors including education, software and financial services.
I'm based in Birmingham – right in the middle of the country – so I can reach you easily for in-person training anywhere in the UK, or even internationally! I also provide live online training if that suits you better.
I keep my business deliberately personal: you deal with me directly, from first enquiry to post-course follow-up, and every session is built around your people and your real-world challenges.
Pricing & Learning Options
Live Online Public Course
Live interactive online training with Mark Baglow via Microsoft Teams.
Small groups with a maximum of 8 participants.
Course file with notes, activities and post-course exercises.
Hands-on training with questions welcomed at any time.
3 months of email support for follow-up questions.
£250
per person
Best suited for individuals or if you have 1 - 3 participants
In-House Group Course Live Online
Private hands-on group training with Mark Baglow for your organisation live online.
Tailored to your requirements.
Detailed course file and resources included.
Recommended group size of up to 10 participants.
Pricing is a day rate for the group - not per person
from £1,000
per day
Works out at £100 per person for a group of 10
In-House Group Course In-Person
Private hands-on group training with Mark Baglow in-person at your workplace.
Tailored to your requirements.
Detailed course file and resources included.
Recommended group size up to 12 participants.
Pricing is a day rate for the group - not per person
from £1,200
per day
Works out at £100 per person for a group of 12
Best Value for Teams
Half-day courses for in-house training are available on request.
Your satisfaction, guaranteed. I'm confident you'll find this genuinely valuable. If you attend a public course and don't feel it was worth your time, I'll refund your place. For in-house training, if it doesn't deliver what we agreed, I'll put it right.
The final cost of in-house training depends on delivery format, location (including London), group size and any specialist tailoring; travel and accommodation may apply for in-person sessions. No VAT is currently charged.
How In-House Training Works
Bringing training in-house for your team - whether in-person or online - is simpler than you might think.
I can also help assess your team's training needs with my Excel Team Skills Audit - which you can download instantly.
Here's the whole journey:
Get in touch: Tell me a bit about your team and what you'd like to achieve.
Fill in the form or book a free 30-minute call.
Free scoping call: We talk through your goals, your team and any specific challenges. No charge, no obligation.
Tailored proposal: I send a clear proposal with tailored content and a price. Tailoring and prep are included as standard - no hidden extras. No VAT is currently charged on top of my prices.
Delivery: I deliver the session at your site or live online, fully tailored to your organisation.
Follow-up: Everyone leaves with a workbook and post-course resources to embed what they've learned.
Want to Learn More?
No VAT currently charged · Free discovery call · Tailoring & prep included
Public Course Dates
Book instantly onto one of my regular public courses below. My online Excel courses are delivered as live instructor-led training via Microsoft Teams at £250 per person.
Looking for Microsoft Excel in-person or remote training for your team?
Public courses suit individuals or 1–3 people. For 4+, in-house is more cost-effective per person and I'll tailor it to the way your team uses Excel: your own spreadsheets, reports and workflows.
Please contact me to discuss in-house training options.
- Excel Advanced - 29/10/2629 Oct 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Advanced - 11/12/2611 Dec 2026, 09:30 – 16:30 GMTLive Online Training
Advanced Excel Training Across the UK
Looking for an advanced Excel course in Manchester, Leeds, Birmingham or elsewhere?
There are two options:
Join one of my live online public courses from anywhere - no travel needed, ideal if you're sending one or two people.
Or, for teams, I deliver in-person (or remote) in-house Excel training across the UK.
Remote training is delivered live online via Teams and is as interactive and hands-on as in-person courses. Perfect if you have a remote or international team.
For in-house training the content can be tailored to suit your organisation and offers excellent value per-person.
I'm Birmingham-based, and travel nationwide.
Get in touch to learn more and get a custom quote.
Who Is This Advanced Excel Course For?
This Excel Advanced course is designed for confident Excel users who want to move beyond formulas and formatting into real data mastery.
If you already work with spreadsheets regularly and want to automate, analyse, and report at a professional level, this course will give you the skills you need.
I recommend that you either complete my Beginner and Intermediate courses first, or have equivalent existing Excel knowledge.
If you're unsure which course is right for you, try my quick 2-minute Excel quiz to get a recommendation, or download my more detailed Excel Skills Audit.
This course is especially valuable for:
-
Professionals wanting to upskill - advanced Excel skills are incredibly valuable. Progress your career and work smarter.
-
Analysts, Finance and HR Professionals – who need to work with large datasets, reports, and dashboards efficiently.
-
Team Leaders and Managers – who rely on Excel to make data-driven decisions and want to get more from the tools they already use.
-
Office and Admin Staff – who handle spreadsheets daily and want to learn time-saving automation and data-cleaning techniques.
-
Power Users – who want to take full advantage of advanced Excel functions, Power Query, and macros to become faster and more effective in their day-to-day work.
Still unsure which level of Excel training is right for you or your team?
Don't worry - just get in touch and I'll be more than happy to advise.
Frequently Asked Questions
For more general questions about booking, pricing, delivery and more, please visit the main FAQ Page
Why Choose Mark Baglow Training
Practical & Interactive
Every course is full of real examples, and designed so you can immediately apply what you learn on Monday morning.
My Excel courses are hands-on and practical with post-course exercises for further learning.
Delivered By A Real Expert
You learn directly from me - an experienced Excel trainer - whether you join a public date or book in-house.
Small public groups mean real attention, not a lecture to a crowd of fifty.
Flexible Delivery
Join a live online public course as an individual, or bring the training in-house for your team, in person across the UK or online.
In-house content and length can be flexed to suit your requirements.
Proven Track Record
Trusted by organisations nationwide
Consistent 5-star feedback and repeat clients across a wide variety of sectors and types of organisation who value practical, impactful learning.
Helpful Excel Articles
Whether you're brand new to Excel or have been using it for years without any formal training - this course is the place to start.
Want to move beyond the basics of Excel? Learn logical functions, lookups, data validation, advanced charts and much more.
Boost personal and team productivity with the latest Artificial Intelligence tools with courses on Claude, Copilot and ChatGPT.
I also deliver training in Microsoft Office, Personal Effectiveness, Leadership & Management, Project Management, and more.
Whether you want to build better reports, clean and analyse data faster, or start automating tasks, this course will transform the way you use Excel.
My Advanced Excel classes will teach you the functions, formulas and skills you need to take your Excel abilities to the next level.
Join one of my upcoming online Excel courses or contact me to discuss tailored in-house options.
I also have Beginner and Intermediate Excel courses available to cater to all abilities.
Just fill in the form to get the conversation started.
You can also book a free 30 minute no-obligation consultation call here
