Upcoming Courses
Excel Advanced
Take your team from confident users to understanding the power that can come from working with multiple sheets or linked workbooks. This course explores some of the more sophisticated tools and automation techniques and brings confidence and clarity to some frequently-used functions such as VLOOKUP, COUNTIF, SUMIF, COUNTIFS and SUMIFS. Designed to bridge the gap between competence and mastery, it unlocks the high‑impact features that drive smarter decisions and serious efficiency gains from the first session. Recent attendance on our Excel Intermediate course is a pre-requisite.
£350+VAT per person
Advanced
Benefits
What they’ll be able to do after this course:
Take control of complex workbooks — manage, link and organise multi‑sheet files like a pro.
Level‑up their formulae — turn data into instant insights with VLOOKUP, SUMIF, COUNTIF and more.
Solve problems fast — use Goal Seek and auditing tools to fix errors and test scenarios with confidence.
Automate their workload — record macros that save hours and eliminate repetitive tasks.
Create polished, secure reports — apply templates, protection and professional formatting effortlessly.
Communicate with impact — group, outline, comment and print multi‑sheet reports that impress.
What they will learn
Course content includes:
- Using the Quick Access Toolbar
- Working With Multiple Sheets
- Selecting Multiple Sheets
- Modifying Multiple Sheets
- Multiple Sheet Formulae
- Using Edit – Replace in Formulae
- More Multiple Sheet Formulae
- Viewing and Printing Multiple Sheets
- Hiding and Unhiding Sheets
- Comments
- VLOOKUP Function
- SUMIF and COUNTIF Functions
- Goal Seek
- Linking Workbooks
- Data Consolidation
- Grouping and Outlining
- Recording Macros
- Auditing
- Styles, Protection and Templates
- Answers to burning questions and advanced challenges
Course Details
- 2 weeks, 2 x 2-hour live online sessions a week
- 15/06/26 – 24/06/26
- 1.30pm – 3.30pm
- £350+VAT per person
Client Feedback
“Definitely worth attending, whether you use Excel a lot or a little. Lots of useful tricks to make things easier. The hard part will be remembering them all!”
Melody Wareing – SOCOTEC
Learner
“Everything was great. Trainer, engagement, knowledge. I really cannot fault this course. Best one I’ve ever attended.”
Jennie Blake – SOCOTEC
Learner
“The Mastering Excel course has been fantastic. Claire is a great tutor, the content was delivered in a way that made sense and was easy to follow.”
Katie Hutchinson – SOCOTEC
Learner
Reserve a Place
We’ll hold places for 5 days whilst you get internal approvals sorted.
Join Waitlist
Customised Training Enquiry
Live online
Sterling’s live online courses bring expert-led learning straight to your screen. Your staff join interactive, real-time sessions with experienced trainers, ask questions in the moment and collaborate with other professionals. It’s engaging, practical training that delivers immediate impact and keeps them connected, focused and ahead of the curve.
Face-to-face
Working face-to-face with your staff builds teams and buy-in. We love getting into the physical training room, where it’s a great place to be creative and experiential. This method is particularly useful when driving cultural change. We are the voice of your organisation, underpinning your aims and values and helping your teams to find practical ways to work more closely, communicate better and achieve your objectives.