top of page
Online Microsoft Excel advanced training class

Advanced Excel Course

Master Excel’s most powerful tools – transform data into insights and automation into action.

5 Star Rated

In-House Training

Public Courses

1 Day Course

Trainer guiding participant during advanced Excel course

Master Advanced Excel Skills and Functions

If you’re already confident using Excel but want to unlock its full potential, this Advanced Excel Course is designed for you.

​

Across a single, intensive 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.

​

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.

Excel Advanced Course Content

For in-house training the course can be tailored to your specific requirements

​

All learners on our Excel Advanced Course receive:

​

  • 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.

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 Arrays

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.

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.

  • Build drop-down lists and dependent drop-down lists for structured data entry.

PivotTables and PivotCharts

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 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.

Course Delivery

In-House Training

Private in-house courses are available by contacting us. Delivered in-person at your site or another location of your choice. Training can also take place online via Teams.

​

In-house sessions allow us to tailor the content to your organisation’s specific goals, culture, and challenges.

Public Courses

Regular public courses available to everyone. Live, online training classes delivered via Microsoft Teams.

 

Perfect for individuals or a small number of attendees. Interactive and engaging to give you the classroom experience while building your skills and confidence.

Public Course Dates

​Book instantly onto one of our regular public courses below.​​​ Our online Excel courses are delivered as live instructor-led training via Microsoft Teams.

​

Looking for in-person or remote training for your team?

​

Please contact us to discuss our in-house training options.

Who Is This Advanced Excel Course For?

This 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 take you there.

​

We recommend that you either complete our Beginner and Intermediate courses first, or have equivalent existing Excel knowledge.

​

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.

Not sure which level of Excel training is right for you?
Don't worry - just get in touch and we'll be more than happy to advise.
Trainee practising Excel PivotTable

Why Choose Mark Baglow Training

Thank you for today’s Excel training - it was engaging, well-paced, and full of practical tips I can use right away.​

 

I especially appreciated how interactive the session was. Your clear explanation of formulas helped me finally understand how they work, boosting my confidence and accuracy.

Team learning Excel together in office

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

Please select whether you are contacting us:
For an organisation or business
Just for myself
Area of Interest

Ready to Master Advanced Excel Skills?

bottom of page