Excel - Interactive Dashboards

Level - Advanced

If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you.

It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.

Location

Date

Duration

Time (AWST)

Address

Participants

Total

What to expect

This course introduces the financial tools and formulas available in Excel.

You will learn how to handle raw data, use functions to create performance metrics, and build mini charts, pivot tables and pivot charts typically used in dashboards.

What you will explore

Participants should be able to:

Have the understanding of what type of data is required to be collected and how best to format in order to create useful KPI Dashboards
Know how to access, construct and order nested and concatenated formulas in order to turn simple collated data into suitable KPI Dashboard data
Know how to convert KPI Dashboard data into effective reporting graphs and PivotTables which can be used in forecasting and performance review meetings.

Where this course can take you

During this training course, you will explore:

Understand KPI data
Advanced functions
Advanced protection
Advanced charts
PivotTables and PivotCharts
Conditional formatting
Hyperlinks

Related Results

Word - Templates, Forms and Macros

Level – Advanced.

If you want to save time and standardise your documents, this course builds the skills to create templates, forms and simple macros that streamline everyday work.

You will learn practical tools that improve consistency and reduce repetitive tasks.

See course page

Excel - Advanced Functions

Advanced Excel functions can help you analyse, clean and manipulate business data with greater efficiency and accuracy.

This practical one-day course develops your ability to build well-structured, complex formulas. You will work with advanced logical, lookup, reference, statistical, date and text functions, along with defined names, nested functions, Flash Fill, spill formulas and dynamic arrays.

See course page

AI Essentials with Claude

Build practical confidence using Claude for everyday workplace tasks.

This course helps non-technical professionals use Claude to draft, summarise, analyse, structure and refine work with clearer prompts, stronger judgement and responsible AI practice.

See course page

AI Essentials with ChatGPT

Use ChatGPT to draft, analyse, research and refine everyday workplace tasks.

This course helps non-technical professionals get more value from ChatGPT by improving how they prompt, question, verify and adapt AI-generated outputs for practical work tasks.

See course page

size? 4 newAIMWASpecialCourse, aIMWACoursePage, aIMWACoursePage

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs