Transform your team’s productivity with expert-led advanced Excel training
This advanced Excel training course is designed specifically for teams to work through together, using real-world scenarios and business cases that mirror the challenges your organisation faces daily.
Your team will build practical expertise in complex data analysis, task automation and advanced reporting, skills they can apply immediately to actual projects and everyday tasks.
What will be covered:
- Extract and analyse complex data using nested formulas with multiple criteria
- Automate repetitive tasks with macros, saving hours of manual work each week
- Generate accurate forecasts using what-if analysis and scenario planning tools
- Create powerful reports with advanced Pivot Table calculations and groupings
- Improve data accuracy through conditional formatting and formula protection
Click to see some of our training in action!
Flexible training options
We offer a wide range of Microsoft Excel training courses to suit all skill levels, from introductory to advanced and specialist topics. Our courses are available online and on-demand, with options for group training. Whether you’re part of a small team or a larger group, our flexible onsite and live online sessions can accommodate anywhere from 2 to 20 participants.
6 lessons cover:
Nesting Formulas and Conditional Formatting
Learn to nest multiple formulas, using AND and OR functions within IF statements. This module includes applying Conditional Formatting to format table rows based on criteria and dates using the TODAY function.
Advanced Pivot Tables
Explore advanced Pivot Table reporting tools, including grouping numeric and date fields, running percentage analyses, and writing field calculations. Learn how to create Pivot Tables from multiple tables.
Array Formulas and LOOKUP Functions
Discover the advantages of array formulas for formula protection, and use LOOKUP functions like INDEX and MATCH for versatile data retrieval. Participants will also learn to write SUMIFS, AVERAGEIFS, and COUNTIFS for calculations based on multiple criteria.
What-If Analysis and Macros
Utilise Goal Seek and Scenario Manager for forecasting reports. This module covers macro security, recording, running, and editing macros, as well as managing the Personal Workbook and an introduction to VBA code editing.
Customising the Quick Access Toolbar and Ribbon
Learn to add macro buttons to the Quick Access Toolbar (QAT) and customise the Ribbon by adding groups and buttons to enhance your Excel experience.
Text Functions and Data Integration
Gain proficiency in text functions such as CONCATENATE, UPPER, LOWER, and PROPER, along with MID, LEFT, RIGHT, REPT, and FIND. Learn to integrate various Excel features effectively for streamlined workflows and improved data management.
Excel Training FAQs
This course works well for teams who use Excel regularly in their day-to-day work and are comfortable with the basics, things like formulas (SUM, AVERAGE, basic IF statements), formatting and simple Pivot Tables.If your team is still getting to grips with Excel basics, our Intermediate course might be a better starting point.
Basic Excel covers the essentials like entering and organising data, simple formulas, formatting, basic charts and tables. It’s about getting comfortable with the interface and everyday tasks.
Advanced Excel takes things further. You’re looking at complex formulas (nested functions, arrays), sophisticated data analysis using Pivot Tables and What-If scenarios, automation with Macros and VBA, plus customising Excel to work the way your team needs it to.
Not sure which level suits your team? Get in touch and we’ll help you figure out what makes sense for each person.
Our Advanced Excel course includes:
- Nesting formulas and conditional formatting
- Advanced Pivot Table techniques
- Array formulas and LOOKUP functions (INDEX/MATCH, SUMIFS, etc.)
- What-If Analysis and forecasting tools
- Macros and basic VBA automation
- Customising Excel for improved efficiency
- Text functions and data integration techniques
The full breakdown is in the modules section above. If you’d like more detail about this course or want to explore our other Microsoft training options, just drop us a message and we’ll point you in the right direction.
Here’s what sets our approach apart:
- Training created to meet your team’s skill level and business needs. We talk to you beforehand to understand where your team is at, so the content hits the right level for everyone.
- You get one dedicated contact who handles everything. No bouncing between different people or chasing responses. They understand your business and make sure the training runs smoothly from start to finish.
- We’ve spent 20+ years figuring out what actually works for businesses. Our 60+ experienced instructors know how to make complex topics click and our 4.7/5 average satisfaction rating reflects that.
- Flexible delivery across the UK and internationally to fit your team’s schedule.
Want to chat about what your team needs? Get in touch and we’ll have a quick conversation about the right approach for you.
