Course Overview
For experienced Excel users, mastering advanced formulas, dynamic data analysis, and automation can significantly boost efficiency and accuracy.
Our Advanced Excel training is designed for those who already use Excel regularly but want to learn high-level functions that improve productivity, automate repetitive tasks, and enhance data reporting.
Advanced Logical Functions & Conditional Formulas
-
Recap of Absolute, Relative, and Mixed Referencing
-
Using IF, AND, OR for complex logical tests
-
Writing nested IF and IFS functions for multi-condition formulas
-
Applying COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS and AVERAGEIFS for summarising data
Lookup & Reference Functions – Mastering Data Retrieval
-
Go deeper with VLOOKUP, HLOOKUP and XLOOKUP
-
Performing both approximate and exact searches for maximum lookup flexibility
-
The new XLOOKUP function and why it's one of the best features in Excel
-
Applying dynamic arrays (UNIQUE, SORT, SEQUENCE, RANDARRAY) for flexible data analysis
Advanced Data Validation & List Management
-
Creating dependent dropdown lists for structured data entry
-
Using advanced data validation rules to improve spreadsheet integrity
-
Creating forms and dashboards in Excel for quick data entry and analysis
PivotTables & PivotCharts – Data Analysis & Reporting
-
Creating PivotTables to summarise large data sets efficiently
-
Customising PivotCharts for clear visual reporting
-
Using slicers and timelines to filter data interactively
Excel Automation with Macros – Saving Time on Repetitive Tasks
-
Introduction to the Macro Recorder – recording and running basic macros
-
Automating repetitive Excel processes without coding experience
-
Understanding macro security and best practices
Upcoming Public Courses
Book instantly onto one of our regular public courses below.
Are you an organisation with four or more attendees?
Please contact us to arrange a private in-house course at a discounted rate per person.
Contact Us
Whether you are looking for a quote for group training, or just want to know more, we'd love to hear from you.
Key Benefits
Our Excel Advanced training course will elevate you to the level of an Excel power user, equipping you with advanced tools and techniques for sophisticated data analysis and workflow automation.
-
Master advanced formulas to handle complex calculations with ease.
-
Use lookup functions to retrieve and organise data efficiently.
-
Create PivotTables and PivotCharts for powerful data analysis.
-
Set up data validation and lists to control and structure data input.
-
Automate repetitive tasks with macros to improve efficiency.
Who is it for?
-
Experienced Excel users who have completed Excel Level 2: Intermediate or possess equivalent Excel experience.
-
Data analysts, business analysts, financial analysts, and professionals who work extensively with large datasets and complex data analysis.
-
Excel users who need to create sophisticated reports, dashboards, and models.
-
Individuals who want to automate repetitive Excel tasks and streamline their workflows for maximum efficiency.
-
Anyone seeking to achieve Excel mastery and unlock the full potential of Microsoft Excel for advanced data analysis and automation.
Delivery and Logistics
Delivery: live online or in-house delivery at your premises (for private in-house courses).
Duration: 1 day.
Included: comprehensive course materials. Hands-on exercises and detailed notes for every topic so you will be able to do everything that the instructor does. By the end of the day you will have a course file filled with practical notes and examples for easy reference.