Microsoft Excel – Intermediate
← BackOverview:
Microsoft Excel Training Pathway
Our Microsoft Excel training is offered across three progressive core one-day courses – Introduction, Intermediate, and Advanced – supported by a range of specialist Excel courses focused on advanced analysis, functions, and automation. Whether you are new to spreadsheets, building stronger analytical skills, or automating complex Excel solutions, there is a course tailored to your needs.
All courses can be delivered as is, or we can customise a training program so your team completes the exact topics they need in the number of days that suits your organisation.
You are currently viewing the Intermediate course page, but you can easily explore the other Excel courses using the links below.
Core Excel Courses
- Microsoft Excel Introduction – Learn the fundamentals of creating, editing, formatting, and managing spreadsheets, with a strong focus on accuracy, good design, and practical everyday use.
- Microsoft Excel Intermediate (on this page!) – Build more productive workbooks using formulas, functions, advanced formatting, charts, tables, and analysis tools such as Goal Seek and Quick Analysis.
- Microsoft Excel Advanced – Work with complex data, including PivotTables, data consolidation, advanced filtering, validation, protection, macros, and collaboration features.
Specialist Excel Courses
- Microsoft Excel Functions – Work confidently with logical, lookup, financial, statistical, text, and date functions.
- Microsoft Excel Data Analysis Add‑Ins – Analyse and visualise data using Power View, Power Pivot, Get & Transform, and Power Map.
- VBA for Excel – Automate Excel processes and build custom solutions using VBA.
Microsoft Excel Intermediate – Course Overview
The Microsoft Excel Intermediate course is designed for users who already understand the basics of Excel and want to work more efficiently with their data. This one‑day course focuses on building more productive workbooks using formulas and functions, improving data presentation, and applying tools that support analysis and decision‑making.
Participants learn to work more effectively with worksheets, apply advanced formatting and charting techniques, and use features such as tables, Quick Analysis, Goal Seek, and Fill operations to save time and improve accuracy.
In this course, you will learn how to:
- Use Fill operations to efficiently create and extend data series
- Apply a range of techniques to work productively with worksheets
- Use page setup and layout features to prepare worksheets for printing
- Create more complex formulas and functions, including the use of defined names
- Apply advanced number formatting, borders, and conditional formatting
- Work with tables and Quick Analysis tools to explore and summarise data
- Use Goal Seek to determine values required to achieve a desired result
- Create, enhance, and format charts for effective data presentation
If you’re ready to explore training for your team, you can request a quote, book onsite or online training, or download the course PDF using the buttons on the top right.
Not sure which combination of topics or course levels is right for you? Call us on 1300 667 660 and we’ll help design the perfect Microsoft Excel training solution for your organisation.
What You Can Expect from Customised Microsoft Excel Training With CTO
When you partner with CTO for onsite or customised Microsoft Excel training, you receive a learning experience designed specifically for your team. We focus on the Excel skills that matter to your work, your data, and your level of experience — no generic content and no time wasted.
Here’s what our clients value most:
- Training tailored to your needs – whether you follow a structured Excel learning pathway or select specific topics relevant to your business.
- Experienced, engaging facilitators who specialise in Microsoft Excel and bring real‑world examples to every session.
- Hands‑on, practical learning that builds confidence and equips your team to apply their skills immediately.
- A supportive and enjoyable experience — our trainers are known for making complex Excel concepts clear, logical, and approachable.
We bring training directly to your team, ensuring the content aligns with your systems, processes, and real-world Excel usage.
About Corporate Training Options
For over 30 years, Corporate Training Options has helped organisations across Australia build capability, improve productivity, and get more value from their software tools. Our customised approach ensures your team gains the right skills, in the right way, for long‑term success.
Whether you want a single Microsoft Excel course or a tailored multi‑level training program, we’re here to help.
Call us on 1300 667 660 to design the perfect training solution for your team.
Course Details:
About This Course
The Microsoft Excel Intermediate course is a one‑day, hands‑on program designed for participants who already use Excel and want to build more efficient, flexible, and professional workbooks. Download links for the course outline and supporting materials are available on this tab.
Delivery Options
We offer flexible delivery options to suit your team and environment:
- Onsite at your workplace – Interactive, practical training tailored to your data and business scenarios
- Live online training – Instructor‑led, hands‑on sessions delivered via your preferred online platform
- Customised delivery – Select and combine topics from across the Excel course range to create a tailored training program
All training is delivered by experienced Excel specialists with a strong focus on real‑world application.
About the Courseware
Some of the courseware provided is based on the 2016 edition of Microsoft Excel. While the version number may appear older, the core concepts, formulas, formatting tools, and data analysis techniques remain fully relevant and accurate across current versions of Excel.
Where newer features or interface changes are relevant to this course level, our trainers will highlight and incorporate these during the session, ensuring participants receive current, practical guidance aligned to their Excel environment. We do hope to update them in the future.
Level:
Training Pathway
The Microsoft Excel Intermediate course forms the middle level of the three‑course core Excel pathway, supported by specialist courses for deeper capability in functions, data analysis, and automation. Each course can be delivered independently or combined into a customised learning program.
Use the related‑course links on this tab to explore the Introduction, Advanced, or specialist Excel courses.
Prerequisites & Requirements
- Participants should be comfortable creating, editing, formatting, and printing basic worksheets
- A working knowledge of ranges, copying, and basic formulas is recommended
- Completion of Microsoft Excel Introduction or equivalent experience is assumed
Software Versions
Training can be delivered using current versions of Microsoft Excel for Windows, with examples adapted to match your organisation’s environment.
Related Course:
Learning Outcomes:
By the end of this course, participants will be able to:
- Use Fill operations to create and extend data series efficiently
- Create more complex formulas and functions to perform calculations accurately
- Apply common worksheet functions to analyse and manipulate data
- Use defined names to simplify formulas and improve workbook readability
- Apply advanced formatting, including borders, number formats, and conditional formatting
- Prepare worksheets for printing using page setup and layout features
- Use Goal Seek to determine input values needed to achieve desired results
- Work with tables and Quick Analysis tools to explore and summarise data
- Create and enhance charts using a range of formatting and design features
These outcomes enable participants to work more efficiently with data‑driven workbooks and provide a strong foundation for progression to Microsoft Excel Advanced.
Our Success Program
At CTO, we’re committed to ensuring your Excel training delivers ongoing value beyond the classroom. Our Success Program is designed to support your team before, during, and after training.
What you can expect:
- Customised learning pathways aligned to your team’s roles, data, and objectives
- Experienced Excel facilitators who use real‑world examples throughout the course
- Hands‑on, practical training focused on solving everyday workplace challenges
- Post‑training support options, including refresher sessions, follow‑on courses, or progression to Advanced or specialist Excel training
- A partnership approach focused on building long‑term Excel capability within your organisation
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,210 | per day |
| 4-8 trainees | $1,650 | per day |
| Each additional trainee | $132 | per day |
