Excel - Data Analytics

Level - Advanced.

Turn Excel into a decision-making tool. Transform the way you work with data by using Excel’s advanced analytic functions and modelling tools.

You’ll build the skills to compare scenarios, optimise results and interpret complex information with confidence.

Location

Date

Duration

1 Day

Time (AWST)

Address

Participants

Total

What to expect

Excel offers a powerful suite of tools for exploring data, understanding trends and informing decisions. This course builds your capability with advanced analytic functions and structured techniques that help you interpret results with confidence.

You will learn how to apply descriptive analytics, use advanced sorting and conditional formatting, and work with functions designed for deeper investigation. Guided practice with SUMPRODUCT, database functions and What-If Analysis tools shows you how to test scenarios, compare options and refine your thinking.

The course also introduces Solver and the Excel Analysis ToolPak to support optimisation and more complex modelling. By the end of the program, you will be equipped to move from simple reporting to meaningful analysis that supports forecasting, planning and better decision making.

Is this course for you

This course is ideal for anyone who wants to get more out of Excel by moving from reporting to real business analysis, modelling, and forecasting.

This course is suited to individuals who want to:

use Excel for deeper business analysis and insight
build models and forecasts to support decision-making
move beyond reporting to analytical problem-solving
apply Excel tools to real business scenarios

What you will explore

During this training course, you will develop advanced analytical skills in Excel to interpret data, identify patterns and support informed decision-making. The course focuses on applying a range of analytics techniques, using powerful Excel tools and functions, and building confidence to analyse complex scenarios and optimise outcomes.

By the end of this training course, you should be able to:

Understand different types of analytics techniques and when to use them
Apply advanced conditional formatting to highlight key patterns
Work with complex analytic functions such as SUMPRODUCT and database functions
Use What-If Analysis tools including Goal Seek, Scenario Manager and Data Tables
Apply Solver to calculate multiple outcomes and optimise results
Build confidence using the Excel Analysis ToolPak for deeper insights

Where this course can take you

During this training course, you will explore different types of analytics techniques and how they can be applied to business problems. You will develop skills in advanced sorting for descriptive analysis and use advanced conditional formatting to highlight trends and key patterns in data.

The course also focuses on analytic functions such as SUMPRODUCT and database functions including DSUM and DAVERAGE, along with What-If Analysis tools. You will learn how to use Goal Seek to calculate required values for known outcomes, Scenario Manager to switch between calculations with different variables, Data Tables to compare results from one or two variables, Solver to optimise outcomes, and the Excel Analysis ToolPak to support deeper analysis.