Microsoft Excel – Advanced
← 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 Advanced 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 – Build more productive workbooks using formulas, functions, advanced formatting, charts, tables, and analysis tools such as Goal Seek and Quick Analysis.
- Microsoft Excel Advanced (on this page!) – 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 Advanced – Course Overview
The Microsoft Excel Advanced course is designed for experienced Excel users who work with large or complex datasets and need advanced tools to analyse, validate, protect, and share data effectively. This one‑day course focuses on advanced data manipulation, summarisation, automation, and collaboration features.
Participants learn how to work with imported and linked data, create advanced summaries using PivotTables and consolidations, apply validation and protection techniques, and record macros to automate repetitive tasks. These skills help users build more robust, efficient, and reliable Excel solutions.
In this course, you will learn how to:
- Protect worksheets and workbooks to secure data
- Import, export, and link data across workbooks
- Create summaries using subtotals and data consolidation
- Build and work with data tables, scenarios, and Scenario Manager
- Create, analyse, and customise PivotTables and PivotCharts
- Use advanced filters and data validation techniques
- Work with form controls and collaboration features
- Record macros to automate common Excel processes
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 Advanced course is a one‑day, hands‑on program for experienced Excel users who want to take full advantage of Excel’s advanced data analysis and automation capabilities. 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 – Highly interactive training tailored to your data, processes, and business scenarios
- Live online training – Instructor‑led, hands‑on sessions delivered via your preferred online platform
- Customised delivery – Combine topics from across Excel courses to design a program aligned to your organisation’s needs
All training is delivered by experienced Excel specialists with a strong focus on real‑world use.
About the Courseware
Some of the courseware provided is based on the 2016 edition of Microsoft Excel. While the edition may appear older, the advanced data tools, PivotTable concepts, validation techniques, collaboration features, and macro recording covered remain fully relevant and accurate across current versions of Excel.
Where newer features, interface changes, or enhanced tools are relevant to this course level, our trainers will highlight and incorporate these during the session, ensuring participants receive up‑to‑date, practical guidance aligned to their Excel environment. We do hope to update them in the future.
Level:
Training Pathway
Microsoft Excel Advanced is the final level in the three‑course core Excel pathway, supported by specialist courses for deeper capability in functions, data analysis, and automation. It can be taken as a standalone course or as part of a customised training program.
Use the related‑course links on this tab to explore Introduction, Intermediate, or specialist Excel training options.
Prerequisites & Requirements
- Participants should be confident working with formulas, functions, charts, and tables
- Experience with Intermediate‑level Excel features is strongly recommended
- Completion of Microsoft Excel Intermediate or equivalent experience is assumed
Software Versions
Training can be delivered using current versions of Microsoft Excel for Windows, with demonstrations and examples adapted to suit your organisation’s software environment.
Related Course:
Learning Outcomes:
By the end of this course, participants will be able to:
- Modify Excel options to suit advanced working requirements
- Protect worksheets and workbooks to safeguard sensitive data
- Import, export, and link data to create more efficient workbooks
- Group data and use outlines to manage complex worksheets
- Create summaries using subtotals and data consolidation
- Build and manage data tables, scenarios, and Scenario Manager
- Create, analyse, and customise PivotTables and PivotCharts
- Apply advanced filters and data validation techniques
- Create and use form controls within worksheets
- Share workbooks and collaborate with other users
- Record macros to automate repetitive Excel tasks
These outcomes enable users to build sophisticated Excel solutions and provide a strong foundation for progression into specialist Excel courses such as Data Analysis Add‑Ins or VBA for Excel.
Our Success Program
CTO’s Success Program ensures your Excel Advanced training delivers meaningful, long‑term value beyond the classroom.
What you can expect:
- Customised learning pathways aligned to your team’s roles, data, and complexity of work
- Highly experienced Excel facilitators who bring practical, real‑world expertise
- Hands‑on, advanced‑level training using realistic scenarios and datasets
- Post‑training support options, including refresher sessions or progression to specialist Excel courses
- A partnership approach focused on improving efficiency, accuracy, and confidence in Excel
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,210 | per day |
| 4-8 trainees | $1,650 | per day |
| Each additional trainee | $132 | per day |
