Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Microsoft Excel Intermediate
What Your Team Will Learn
Ready for your team to supercharge their Excel skills and work smarter, not harder? Welcome to our “Microsoft Excel Intermediate” course, where we’ll transform your staff from basic formula users into confident data wranglers!
Ever found colleagues repeating the same formula over and over, knowing there must be a faster way? Or seen staff staring at complex spreadsheet references wondering why formulas aren’t working quite right? Get ready for your group to master Excel’s most practical features and discover the time-saving techniques they’ve been missing!
This course is perfect for teams who already know their way around Excel but are ready to level up their skills with powerful functions and efficient techniques. By the end of the day, your staff will be confidently building sophisticated formulas, creating smart conditional formatting, and using advanced lookup functions that make finding data a breeze. Plus, they’ll discover dozens of time-saving shortcuts that will transform daily Excel tasks from tedious to triumphant!
What You'll Get With This Course
Live Instructor-Led Training
Highly experienced and approachable trainers
Comprehensive Materials
eCertificate of Completion
Proudly recognise your achievement
Lifetime Support
Expert help, always within reach
Skill Level: Intermediate
Duration: 1 Day
Time: 9:00am – 4:00pm
CPD Hours: 6hrs
Microsoft Excel Intermediate Course Content
Cell Referencing
- Relative and Absolute References What’s the difference?
- Relative References
- Absolute References
- Mixed References
Linking and 3D Formulas
- Thinking in 3 Dimensions
- Working with Multiple Worksheets
- Building 3D Formulas
- Creating Linked Workbooks
- Updating Links
Lists, Tables and Subtotals
- Sorting Lists
- Filtering Lists
- Lists vs Tables
- Working with Subtotals
IF Functions
- Logical Functions
- Using True and False
- Using Comparison Operators
Nested IF Functions
- Logical Functions
Conditional Formatting
- About Conditional Formatting
- Applying Conditional Formatting
- Using Data Bars and Colour Scales
- Modifying Formatting Rules
- Finding and Clearing Formats
Choose Function
- Using the Choose Function
Lookup Functions
- Using Lookup Functions
- Lookup
- VLookup
- HLookup
- XLookup
Index and Match Functions
- Using Index
- Using Match
- Using Index and Match Together
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.
Want to run this course for your staff?
Standard course ready to go — customisation available if your team needs it.
Only need to train one or two people? Book a seat in our public Microsoft Excel Intermediate course.
Our Clients
FAQ's
We know team training comes with a lot of questions, who, what, how many, when, where, and sometimes even why. To save you a few clicks (and a few minutes), we’ve pulled together the most common ones we get from other HR managers, L&D teams, and people just like you.
Where can this Microsoft Excel Intermediate training be delivered?
We can deliver the course at your workplace for face-to-face learning, or online with live facilitation if remote access is preferred. A hybrid setup is also possible, combining both in-person and online participants. We’ll make sure the format works seamlessly for your team.
How many staff can attend a Microsoft Excel Intermediate training session?
Small to medium groups work best for this level of Excel training. This ensures participants can practise more complex functions while still getting guidance from the trainer. We’ll provide advice on the ideal numbers but can adapt to suit your organisation.
Can we schedule the Microsoft Excel Intermediate training at a time that suits us?
Yes, the course can be arranged around your team’s calendar. You can choose a half-day refresher, a full-day deep dive, or split the sessions across multiple days. We’ll make sure the timing reduces disruption and maximises learning.
What will my team be able to do after the Microsoft Excel Intermediate course?
After completing this course, participants will be able to use more advanced formulas like IF and XLOOKUP, apply conditional formatting, and manage larger spreadsheets with ease. They’ll also explore tools that improve efficiency, such as working with Subtotals and linking sheets. These skills help staff take their Excel use to the next level, giving them more control over their data.
Do participants need any prior knowledge of Microsoft Excel?
Yes. Participants should already be confident with the basics, such as entering data, creating simple worksheets, and using basic formulas. This foundation allows them to keep pace as we move into more complex topics.
Can the Microsoft Excel Intermediate training content be customised to our needs?
Yes. If your organisation regularly works with particular types of data, we can adapt examples and exercises to fit. That way, the training directly reflects the challenges your staff face and gives them practical solutions they can apply straight away.
Will staff receive a certificate of completion?
Yes, each participant will receive a certificate when they complete the course. This provides recognition for their learning and demonstrates your organisation’s commitment to ongoing development.
Do you provide support after the Microsoft Excel Intermediate training?
Yes, we provide lifetime support. If staff run into challenges with functions or data management later, they can email us for help. This support helps them apply their new knowledge with confidence.
Get your team members to try our short, anonymous Microsoft Excel Intermediate skills test.
You’ll discover your true proficiency level in minutes, no registration required
Prior Knowledge
Our Intermediate Microsoft Excel training is for regular users of Excel who are familiar with the basics and who want to broaden their knowledge. You should be comfortable with creating worksheets, basic formulas, and simple formatting. This course builds upon these fundamentals to explore more advanced features and functions.
Required Software
You will need Microsoft Excel installed on your computer to participate in this course. This can be through a Microsoft 365 subscription or a perpetual license version.
Course Materials
All exercise files needed for the course will be provided. In some cases, you may receive them by email prior to the training so you can download them in advance. Otherwise, everything will be supplied during the session, and no preparation is required.
Note About Different Versions
Our Intermediate Microsoft Excel training is for regular users of Excel who are familiar with the basics and who want to broaden their knowledge. You should be comfortable with creating worksheets, basic formulas, and simple formatting. This course builds upon these fundamentals to explore more advanced features and functions.
Brendon Farrell
Co-Founder / Facilitator
From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.
As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.
Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.
Mark Finney
Co-Founder / Facilitator
With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.
Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.
When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.