• View Cart
  • Trainer Login
  • Customer Login
  • 1300 667 660
Corporate Training Options
Menu
  • Home
  • Courses
    • Corporate Training
      • Leadership Training
      • Customer Service Training
      • Planning & Organisation
      • Personal Development
      • Sales Training
    • Microsoft 365 Training
    • Online Training
  • Event Replays
  • Blog
  • Success Stories
    • Testimonials
    • Business Case Studies
  • About
    • Meet the Team
    • FAQ’s
    • Careers
  • Locations
    • Canberra
    • Sydney
    • Melbourne
    • Brisbane
    • Gold Coast
    • Perth
    • Adelaide
    • Hobart
    • Darwin
Home > Courses > Microsoft Computer Training > Microsoft 365 Training > Microsoft Excel > Microsoft Excel Data Analysis Add-Ins

Microsoft Excel Data Analysis Add-Ins

← Back
  • Overview
  • Course details
  • Level
  • Outcomes
  • Success Program
  •  

Overview:

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 Excel Data Analysis Add-Ins 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 – 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 (on this page!) – 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 Data Analysis Add‑Ins – Course Overview

The Microsoft Excel Data Analysis Add‑Ins course is designed for users who work with large or complex datasets and want to move beyond standard Excel features. This specialist course focuses on Excel’s advanced data analysis and visualisation tools that allow users to import, model, analyse, and present data more effectively.

Participants learn how to work with tools such as Power View, Power Pivot, Get & Transform, and Power Map to analyse data from multiple sources, build data models, create interactive reports, and visualise trends and geographic information.

In this course, you will learn how to:

  • Analyse and explore data using Power View
  • Build and work with data models using Power Pivot
  • Import, refine, and combine data from multiple sources using Get & Transform
  • Create interactive and geographic visualisations using Power Map
  • Work more efficiently with large datasets within Excel

 

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.

 


 

Microsoft Excel Introduction TrainingWhat 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 Data Analysis Add‑Ins course is a specialist, hands‑on program focused on advanced data analysis and visualisation within Excel. It is ideal for users who need to work with complex or high‑volume data and want to gain deeper analytical insight using Excel’s extended toolset.

Download links for course materials and reference content are available on this tab.


Delivery Options

We offer flexible delivery options to suit your team and environment:

  • Onsite at your workplace – Practical training using realistic, data‑driven examples
  • Live online training – Instructor‑led, interactive sessions focused on advanced analysis tools
  • Customised delivery – Focus on specific add‑ins or tailor content to your organisation’s data sources

All training is delivered by experienced Excel specialists with strong data analysis expertise.


About the Courseware

Some of the courseware provided is based on the 2016 edition of Microsoft Excel. While the edition may appear older, the fundamental concepts behind Power Pivot, data modelling, Get & Transform, and Excel‑based visualisation remain fully relevant across current versions of Excel.

Where newer features, interface enhancements, or updated workflows are relevant, our trainers will incorporate these into the session, ensuring participants receive current, practical guidance aligned to their Excel environment.  We do hope to update them in the future.

Duration:

  Microsoft Excel - Data Analysis Add-Ins - Download the course outline in PDF Format

Level:

Training Pathway

Microsoft Excel Data Analysis Add‑Ins is a specialist course that complements the three‑level core Excel pathway. It is commonly undertaken after completing Microsoft Excel Advanced, or by users with equivalent experience.

This course can be delivered as a standalone program or combined with other Excel or data‑focused training as part of a customised learning pathway.


Prerequisites & Requirements

  • Strong working knowledge of Excel
  • Confidence working with formulas, tables, and basic data analysis
  • Familiarity with Excel Advanced features is recommended
  • No prior experience with Excel add‑ins is required

Software Versions

Training can be delivered using current versions of Microsoft Excel for Windows.
Demonstrations and examples are adapted to suit your organisation’s Excel version and data environment.

Related Course:

  • Microsoft Excel - Introduction
  • Microsoft Excel - Intermediate
  • Microsoft Excel - Advanced
  • Microsoft Excel Functions

Learning Outcomes:

By the end of this course, participants will be able to:

  • Use Power View to examine, analyse, and explore data interactively
  • Build and work with data models using Power Pivot
  • Perform advanced analysis tasks on large or complex datasets
  • Import, clean, and combine data from multiple sources using Get & Transform
  • Create interactive and geographic visualisations using Power Map
  • Gain deeper insights from data by extending Excel’s analytical capabilities

These outcomes enable participants to move beyond traditional spreadsheets and use Excel as a powerful data analysis and visualisation platform.

Our Success Program

CTO’s Success Program ensures your specialist Excel training delivers meaningful, long‑term value.

What you can expect:

  • Customised learning pathways combining Excel Advanced, Functions, Data Analysis Add‑Ins, and VBA
  • Experienced Excel and data analysis facilitators with real‑world expertise
  • Hands‑on, scenario‑based training using realistic datasets
  • Post‑training support options, including follow‑on workshops or advanced analytics training
  • A partnership approach to help your organisation build strong analytical capability in Excel

Prices:

Trainees Price
1-3 trainees $3,300 per day
4-8 trainees $3,960 per day
Each additional trainee $154 per day

Click here to Request a Quote

  Get A Quote   Book Onsite Training   Book Online Training
  Download PDF

REQUEST A QUOTE BOOK NOW

Internal Links

  • Home
  • About CTO
  • Services
  • Courses
  • Become a Trainer
  • Blog
  • Contact Us

Secure Payment

Locations

  • Canberra
  • Sydney
  • Melbourne
  • Brisbane
  • Gold Coast
  • Perth
  • Adelaide
  • Hobart
  • Darwin
  • New Zealand
  • United Kingdom
  • USA
  • Canada

Sign Up to our Newsletter

  • This field is for validation purposes and should be left unchanged.

Connect with us

Privacy Policy | Terms & Conditions | Refund Policy | Disclaimer

Sitemap | Copyright © 2017 | All rights reserved. | SEO and Gold Coast Web Design by: Visual Marketing