Excel Intermediate
Many employees use Excel every day but only scratch the surface of its capabilities. As job demands increase, staff often need to work with larger datasets, perform more complex calculations and produce meaningful reports quickly and accurately.
Excel Intermediate helps participants develop the skills and confidence to analyse data more effectively, automate repetitive tasks and create professional reports that support better decision-making. Through practical exercises and real-world examples, learners will discover smarter ways to work with data, improve spreadsheet reliability and increase productivity. Participants will also explore how Excel and AI-powered tools can work together to support data analysis, reporting and workplace efficiency while maintaining accuracy and control.
£275+VAT per person
Intermediate
Common challenges
- Spending too much time manipulating and analysing data manually.
- Difficulty extracting meaningful insights from spreadsheets and reports.
- Errors caused by formulae being copied or applied incorrectly.
- Repetitive manual processes that could be automated more effectively.
- Presenting data in ways that are difficult for others to interpret.
- Understanding how Excel and AI tools can support analysis, reporting and productivity.
We’ll help them to
- Analyse data using advanced functions and formulae.
- Use IF and nested functions to create more sophisticated calculations.
- Work confidently with date calculations and date-based reporting.
- Apply absolute referencing techniques to improve spreadsheet reliability and accuracy.
- Create professional charts that communicate information clearly and effectively.
- Reduce manual work through smarter spreadsheet design and automation.
- Explore how AI-powered tools can support data analysis, formula development and reporting while maintaining accuracy and professional judgement
The Sterling Way: Learner-centred training with real-world impact
All of our courses are designed around participation, not passive learning. Through activities, discussion, real-life scenarios and practical exercises, delegates build confidence by applying new skills during the course itself. During this course you will:
- Work through realistic spreadsheet challenges and workplace scenarios.
- Practise intermediate Excel techniques using hands-on exercises and guided activities.
- Apply tools and techniques that can immediately improve efficiency and productivity at work.
- Develop confidence using advanced functions, calculations and data analysis tools.
- Explore practical approaches to automating routine tasks and reducing spreadsheet errors.
- Discover how AI can complement Excel by supporting analysis, formula suggestions and reporting while ensuring human oversight remains central to effective decision-making.

Course Details
- 2 weeks, 2 x 2-hour live online sessions a week
- £275+VAT per person

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