Ranked Among Australia’s Top 20 Corporate Training Providers (2026): View Courses

Microsoft Excel Training for every
level and every goal

Six courses, one clear pathway — whether you are opening Excel for the first time or
gearing up to automate complex data workflows with VBA

Explore all Excel courses
Call 1300 667 660

About CTO Microsoft Excel Training

CTO delivers customised Excel training programs for every skill level – from foundation formatting and formulas through to PivotTables, Power Query, advanced functions and automation. All Excel courses – Introduction, Intermediate and Advanced – are tailored to your team’s actual workflows and data, not generic spreadsheet exercises.

Select your course

Microsoft Excel TrainingMicrosoft Excel Training – customised for
your team

CTO’s Microsoft Excel Training can be fully customised to your team, your data, your industry and your level. All courses can be delivered onsite at your workplace anywhere across Australia, or live online.

Not sure which course your team needs? Call us today and our specialist facilitator will help you design the right program for you.

Call 1300 667 660

Onsite training

Delivered at your workplace, any state, any territory across Australia.

Hybrid delivery

Onsite and online participants together for distributed teams.

We deliver with impact

Onsite and online participants together for distributed teams.

Fully customised

Tailored to your data, workflows and team’s current skill level.

Know your Excel Training journey

Think of these six courses as building blocks, not a fixed schedule. Most organisations mix and
match — taking participants from where they are to exactly where they need to be.

📗 Core Excel Courses: The Progressive Pathway
Introduction
→
Intermediate
→
Advanced
🔬 Specialist Excel Courses: Go Deeper
Functions
→
Data Analysis Add-Ins
→
VBA for Excel

How it works in practice: Many teams complete Introduction, Intermediate and Advanced as a structured sequence, while others start at Intermediate or Advanced based on existing skills. Specialist courses sit alongside the core pathway. Participants typically take these after Advanced, though Functions can be combined with Intermediate, depending on need. When you choose CTO, all courses can be customised, combined or scaled to the number of days that suits your organisation.

Select a course to see what it covers

Who it’s for, what you’ll learn and how it’s delivered.

  • Core Course · Level 1

    Microsoft Excel Introduction

    Build a confident Excel foundation from day one

    Course overview

    New to Excel or never had a proper foundation? This one-day course gives you everything you need to work confidently with spreadsheets from day one. You’ll learn how Excel actually works, not just what buttons to press.

    The emphasis throughout is on building accurate, well-designed workbooks you can maintain and share with confidence. By the end of the day, you’ll be ready to handle real workplace data with clarity and control.

    What you’ll be able to do

    • Navigate confidently within Excel workbooks and worksheets. No more getting lost in the interface
    • Create, open and manage workbooks, including moving and organising between worksheets
    • Enter, edit, copy, move and fill data using efficient Excel techniques that save real time
    • Build formulas and use basic functions including SUM, AVERAGE, MAX and MIN
    • Apply correct cell referencing so your formulas work exactly as intended, even when copied
    • Format worksheets professionally: fonts, alignment, number formats, rows and columns
    • Sort and filter data to organise and extract what you need
    • Create clear and effective charts to present data visually
    • Prepare and print worksheets ready for sharing and reporting
    • Avoid common spreadsheet mistakes by applying good design principles from the start

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    Learning materials are available for purchase at the time of booking. Materials are based on Excel 2016. All core concepts remain fully relevant across current versions. Trainers highlight any interface differences during the session, so participants always learn what applies to the version they use.

    Course at a glance

    Beginner
    1 full day
    None required
    Onsite or online
    Intermediate

    Ready to equip your team with an Excel foundation? Get in touch to design the right program.

    Book a Discovery Call Download Course PDF
  • Core Course · Level 2

    Microsoft Excel Intermediate

    Work smarter with more powerful workbooks and data tools

    Course overview

    You know Excel basics. Now it’s time to work smarter with it. This one-day course builds on your existing skills to help you create more powerful workbooks, work faster with data and make better decisions using Excel’s analytical tools.

    If you’ve ever wasted time wrestling with a complex formula, struggled to make charts look professional, or wished Excel could do more of the heavy lifting. This course is for you.

    What you’ll be able to do

    • Use Fill operations to create and extend data series efficiently, including custom lists and Flash Fill
    • Build more complex formulas and nested functions: IF, CHOOSE, LOOKUP and date/financial functions
    • Use defined names to make formulas cleaner, more readable and easier to maintain
    • Apply advanced formatting: custom number formats, conditional formatting, sparklines and data bars
    • Manage page setup and print layouts professionally for reports and distributed documents
    • Use Goal Seek to work backwards from a result, a game-changer for planning and forecasting
    • Work with Excel Tables and Quick Analysis tools to explore, filter and summarise data faster
    • Create and enhance charts with formatting, trendlines, error bars and WordArt

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    High quality printed materials available for purchase per participant. Based on Excel 2016. All core concepts remain relevant. Trainers highlight version differences and newer capabilities during the session.

    Course at a glance

    Intermediate
    1 full day
    Introduction level
    Onsite or online
    Advanced

    Need training tailored to the specific tools and data your team uses every day?

    Book a Discovery Call Download Course PDF
  • Core Course · Level 3

    Microsoft Excel Advanced

    PivotTables, macros and professional-level data analysis

    Course overview

    This is where Excel gets serious. If you’re working with large, complex datasets and need tools to analyse, protect and present data at a professional level, this course is your next step.

    From PivotTables that summarise thousands of rows in seconds to macros that automate your most repetitive tasks, the Advanced course equips experienced users to build sophisticated, reliable Excel solutions.

    What you’ll be able to do

    • Protect worksheets and workbooks with password protection and restricted cell access
    • Import, export and link data from external sources: CSV files, Access databases and other workbooks
    • Group data, create outlines and use subtotals to manage and navigate complex worksheets
    • Build and manage PivotTables and PivotCharts, the most powerful data summarisation tool in Excel
    • Create data tables and scenarios for what-if analysis and decision modelling
    • Apply advanced filters and data validation to control what gets into your spreadsheets
    • Add form controls (combo boxes, sliders and check boxes) to build interactive worksheets
    • Share workbooks and track changes for collaborative editing via OneDrive
    • Record and edit macros to automate repetitive tasks without writing a single line of code

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    High quality printed materials available for purchase per participant. Based on Excel 2016. Foundational concepts remain fully relevant. Trainers point out version differences and incorporate current features during the session.

    Course at a glance

    Advanced
    1 full day
    Intermediate level
    Onsite or online
    Functions, Add-Ins or VBA

    Want to combine Advanced with VBA or Data Analysis Add-Ins? Let’s talk.

    Book a Discovery Call Download Course PDF
  • Specialist Course

    Microsoft Excel Functions

    The full toolkit: from VLOOKUP to financial functions and beyond

    Course overview

    Formulas are where Excel earns its reputation, and functions are what make formulas powerful. This specialist course takes you well beyond SUM and AVERAGE to the full toolkit of Excel’s built-in functions.

    Whether you’re calculating loan repayments with PMT, retrieving data with VLOOKUP, manipulating text strings or validating data with information functions, this course gives you the practical skills to make your spreadsheets work harder with fewer errors.

    What you’ll be able to do

    • Use logical functions: IF, nested IFs, IFERROR, AND, OR and NOT to test conditions and control calculations
    • Apply lookup and reference functions: VLOOKUP, HLOOKUP, INDEX, MATCH and OFFSET to cross-reference data accurately
    • Use mathematical functions: ROUND, SUMIF, SUMIFS and SUMPRODUCT for complex multi-condition calculations
    • Apply statistical functions: COUNTIF, MODE, MEDIAN, STDEV, LARGE and SMALL to analyse and summarise data
    • Use financial functions: PMT, FV, NPV, PV, RATE and EFFECT for common financial calculations
    • Work with date and time functions: TODAY, WORKDAY, EOMONTH, WEEKDAY and WEEKNUM
    • Manipulate text using: CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, TEXT and VALUE
    • Use information functions: ISBLANK, ISNUMBER, ISERR, CELL and TYPE to validate worksheet data

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    High quality printed materials available per participant. Based on Excel 2016. All function logic, syntax and use cases remain fully accurate. Trainers flag newer equivalents during the session.

    Course at a glance

    Specialist
    1 full day
    Formula knowledge
    Onsite or online
    8 function types

    The Functions course pairs naturally with Advanced Excel. Talk to us about combining them.

    Book a Discovery Call Download Course PDF
  • Specialist Course

    Microsoft Excel Data Analysis Add-Ins

    Power Pivot, Power Query, Power View and Power Map

    Course overview

    Excel is not just a spreadsheet tool. It’s a serious data analysis platform. This specialist course unlocks a set of powerful add-in tools that let you work with data from multiple sources, build relational data models and create interactive visual reports.

    If your work involves large datasets, multiple data sources or a need for interactive dashboards and geographic visualisations, this course gives you the tools to make Excel do that work properly.

    What you’ll be able to do

    • Use Power View to examine, explore and interact with data visually: filter, highlight and drill into it in real time
    • Build data models using Power Pivot: create relationships between tables and analyse data at scale without complex formulas
    • Import, clean and combine data from multiple sources using Get and Transform (Power Query)
    • Create geographic visualisations with Power Map: plot data on 3D maps, build animated tours and export as videos
    • Perform advanced analysis on large datasets that would be impractical using standard Excel features alone

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    High quality printed materials available per participant. Core concepts behind Power Pivot, data modelling and Power Query remain fully relevant. Trainers incorporate newer features into the session.

    Course at a glance

    Specialist
    1 full day
    Advanced Excel
    Onsite or online
    Power View, Pivot, Map, Query

    Not sure if your team is ready for Add-Ins? Call us and we’ll help you assess that.

    Book a Discovery Call Download Course PDF
  • Specialist Course · 2 Days

    VBA for Excel

    Automate Excel: write code that removes the ceiling on what’s possible

    Course overview

    If Microsoft Excel Advanced is the ceiling of what you can do without code, VBA is the door that removes the ceiling. This two-day course teaches you to automate Excel: writing code that handles repetitive tasks, builds interactive tools and creates solutions that would take hours to do manually.

    No programming experience required. The course introduces coding concepts in a practical, step-by-step way, always grounded in real Excel use cases. By the end of day two, participants leave with working VBA solutions, not theoretical knowledge.

    What you’ll be able to do

    • Navigate and use the VBA Editor confidently: the environment where all Excel automation is written and tested
    • Understand the Excel object model: how VBA sees and interacts with workbooks, worksheets, cells and ranges
    • Write Sub routines and macros to automate repetitive Excel tasks without manual steps
    • Declare and use variables: including data types, scope and arrays for flexible, reusable code
    • Create user-defined functions that extend Excel’s built-in formula library with custom logic
    • Write programming logic using IF statements, Select Case, For loops and Do loops
    • Build custom user forms with text boxes, combo boxes and command buttons for professional data entry
    • Create event-driven code that runs automatically when a workbook opens or a cell changes
    • Implement error-handling routines so your solutions behave reliably, even when users do the unexpected

    Delivery options

    Onsite
    At your workplace, Australia-wide
    Live Online
    Instructor-led, real-time sessions
    Hybrid
    Onsite and online participants combined

    Courseware

    High quality printed materials available per participant. The VBA language, Excel object model and automation techniques remain highly relevant across all current versions. Trainers highlight newer tools and VBA-related updates during the session.

    Course at a glance

    Specialist
    2 full days
    Advanced Excel
    Onsite or online
    None required

    VBA is the most powerful course in our Excel pathway. If your team spends hours on tasks Excel could handle automatically, this is the investment that changes that.

    Book a Discovery Call Download Course PDF

Why organisations choose CTO for Microsoft Excel Training

Built around your team, not a textbook

Every program can be customised to your data, your workflows and your level before we walk in the door. No time wasted on things your team already knows.

Facilitators who know Excel and your industry

Our trainers are Excel specialists with real-world data experience. They explain complex concepts clearly, adapt on the fly and make the learning stick.

Delivered anywhere across Australia

Onsite at your workplace, any state, any territory, including regional locations. Or live online via Microsoft Teams with the same quality and customisation.

Mix, match and scale the program

Take one course or build a multi-level program. Combine topics across levels. We design what’s right for your team’s time, budget and goals.

Skills that show up at work

Participants leave with practical tools they apply the next day. We follow up after training to check the learning is translating into real behaviour at work.

Ranked in Australia’s top 20, 2026

Over three decades helping Australian organisations build capability and get more from their software tools. That track record matters.

Frequently asked questions

How do I know which Excel course my team needs?

The quickest way is a brief conversation with a CTO specialist. As a starting point: if participants have never used Excel, start with Introduction. If they use it daily but know there are gaps, Intermediate. If they work with large datasets, complex formulas or need to build reports, Advanced. Specialist courses are for users who have completed Advanced and want to go deeper in a specific area. Call us and we will help you determine the right level based on what your team currently does with Excel.

Can we combine content from multiple courses into one session?

Yes. A two-day program covering Introduction and Intermediate, or Intermediate and Advanced, is one of the most common formats we deliver. You can also combine topics from different levels into a single customised session. Talk to a CTO specialist about what you are trying to achieve and we will design the program around that.

Is this training available onsite across all of Australia?

Yes. CTO delivers Microsoft Excel training onsite at client locations in every state and territory, including regional and remote areas. All courses are also available as live, instructor-led online sessions via Microsoft Teams with the same content and quality as in-person delivery.

Do participants need any software installed?

Participants will need Microsoft Excel installed on their computers — ideally the version their organisation currently uses. For onsite sessions, participants work on their own machines with their own data wherever possible, which makes the learning immediately applicable. We will confirm software requirements when we finalise your program.

Can Excel training be combined with other Microsoft 365 programs?

Yes. Combining Excel training with other Microsoft 365 programs — particularly SharePoint and OneDrive for file management, or Teams for collaboration — is particularly effective for organisations looking to improve their overall data and productivity workflows. Talk to a CTO specialist about the right combination for your team.

Not sure which Excel course is right for your team?

Call us and we will help identify the right level and format for your team’s skill level and goals.

Call 1300 667 660