Upcoming Courses
Excel Intermediate
When staff use Excel efficiently, everyday tasks take minutes instead of hours — saving time, reducing errors and improving productivity. Take your team’s everyday Excel skills to the next level and build their confidence to tackle more demanding and complex tasks. The lovely Claire will reveal new ways to manipulate data, analyse information and automate processes, making your team quicker and more effective all at once. Ask us about a bespoke course, just for your staff.
£275+VAT per person
Intermediate
Benefits
What they’ll be able to do after this course:
Analyse Data Effectively: Use advanced functions to examine and interpret information, uncovering insights that drive better business decisions
Master Date Calculations: Work confidently with dates, performing calculations and analysis that support project planning and reporting
Apply Advanced Referencing: Use absolute referencing techniques to create robust, reliable spreadsheets that maintain accuracy when copied or moved
Create Conditional Logic: Implement IF functions to automate decision-making within spreadsheets, reducing manual work and errors
Build Complex Functions: Nest functions together to create sophisticated calculations that handle multiple conditions and scenarios
Visualise Data Professionally: Create clear, impactful charts that communicate data insights effectively to colleagues and stakeholders
What they will learn
Course content includes:
- Advanced functions for data analysis and interpretation
- Working with dates: calculations, formatting, and analysis
- Absolute referencing techniques for robust spreadsheet design
- IF function applications for conditional logic and automation
- Nesting functions to create complex, multi-layered calculations
- Basic charting techniques for professional data visualisation
- Advanced data manipulation and analysis techniques
- Automation strategies to reduce manual work and errors
- Answers to burning questions and advanced challenges
Course Details
- 2 weeks, 2 x 2-hour live online sessions a week
- £275+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
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.