Microsoft Excel Data Analysis Add-Ins
← 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 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.
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 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.
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:
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 |


