Intermediate Excel Course
Move beyond the basics and unlock the true power of Excel with practical tools, smart formulas, and time-saving techniques.
Duration
1 Day in-person training
Funding Availability
Funding is currently available to Tees Valley residents. See full funding requirements here.
Course Overview
Our Intermediate Excel Course is designed for anyone who wants to take their spreadsheet skills to the next level. Whether you already use Excel at work or in personal projects, this course will help you become more efficient, confident, and accurate in managing data.
We’ll start with a quick refresher of the essential formulas before diving into powerful functions, logical statements, and error handling. You’ll also learn how to make your spreadsheets look professional, stay clean, and communicate insights visually with charts and conditional formatting. By the end of the course, you’ll have the confidence to tackle everyday tasks with ease and deliver results that stand out.
What To Expect
During the course, you’ll get hands-on experience with practical exercises and step-by-step demonstrations. Each topic is explained clearly with real examples, so you can immediately apply what you learn. Expect to walk away not just with knowledge, but with the skills to use Excel more effectively the very next day.
What You Will Learn
Here’s what we’ll cover in the Intermediate Excel Course:
- Function Refresher – Revisit key formulas like SUM and AVERAGE.
- Focus on Functions – Learn MIN, MAX, COUNT, COUNTA, and COUNTBLANK.
- Logical IF Functions – Test conditions with IF statements for smarter results.
- Handling Errors – Keep spreadsheets neat with IFERROR.
- Relative vs Absolute References – Master the difference to work formulas more effectively.
- Print Optimisation – Create professional-looking print layouts.
- Data Validation – Control input for clean, reliable data.
- Conditional Formatting – Highlight key insights automatically with colour and icons.
- Chart Creation – Turn data into clear, impactful visuals.
- Good Practice – Build simple habits to keep spreadsheets accurate and tidy.
Who Should Take This Course
This course is ideal for:
- Professionals who use Excel regularly and want to boost efficiency.
- Small business owners and managers who need to present data clearly.
- Students and job seekers aiming to improve employability with stronger Excel skills.
- Anyone who already understands the basics of Excel and wants to feel more confident using it day to day.
Key Information
Course length: 1 sessions
Course availability: Click here to check our next starting date.
Cost: Fully funded for eligible residents
Funding requirements:
Tees Valley
Must be a Tees Valley resident. 19 years old and over.
Check Your Availability; Enquire Now
