All courses available in-class or via remote login

Nexacu Excel Specialist
Nexacu Excel Specialist

Excel Analysis and Dashboards Training

Learn to use Excel tools to build effective actionable dashboards.

All courses available in-class or remotely. 
To attend remotely, select "Remote Online" as your location on book now.

Excel’s ability to integrate and visualize data is the focus of this day long course, using the latest features in Excel. Work through multiple exercises to learn to master the tools of data modelling, analysis and building visuals for effective Dashboards.

Participants will create a data model with a range of data sources using Power Pivot and use Get and Transform to connect and manipulate a range of data sources including cloud databases, websites and Facebook. Learn how to fully utilise Excel to create interactive Dashboards, Charting tools and Visualisation techniques.

We complete the course by working through a Case Study pulling all the aspects we teach on the day together.

  • Business Case Study – We start with raw sales data for a Comedy Roadshow. We model the data using PowerPivot, creating relationships and the necessary calculations to build our interactive Dashboard for assessing Sales performance and profitability across various cities. Read our full course outline here.

Excel Analysis and Dashboards Training

4.68
Nexacu Excel Specialist

Analyse your data in Excel with Power Pivot and build effective dashboards. Led by our experienced trainers.

$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day

Remote

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Fri 12-Mar-21
Fri 12 Mar
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Mon 12-Apr-21
Mon 12 Apr
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Fri 28-May-21
Fri 28 May
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Tue 1-Jun-21
Tue 1 Jun
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Tue 8-Jun-21
Tue 8 Jun
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Tue 22-Jun-21
Tue 22 Jun
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Fri 9-Jul-21
Fri 9 Jul
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Wed 4-Aug-21
Wed 4 Aug
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Mon 9-Aug-21
Mon 9 Aug
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Thu 2-Sep-21
Thu 2 Sep
Analysis & Dashboards
Remote Online
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Fri 12-Mar-21
Fri 12 Mar
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Mon 12-Apr-21
Mon 12 Apr
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Fri 28-May-21
Fri 28 May
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Fri 9-Jul-21
Fri 9 Jul
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Mon 9-Aug-21
Mon 9 Aug
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Thu 2-Sep-21
Thu 2 Sep
Analysis & Dashboards
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Tue 8-Jun-21
Tue 8 Jun
Analysis & Dashboards
Sydney
Status: Scheduled
Scheduled
Fri 9-Jul-21
Fri 9 Jul
Analysis & Dashboards
Sydney
Status: Scheduled
Scheduled
Mon 9-Aug-21
Mon 9 Aug
Analysis & Dashboards
Sydney
Status: Scheduled
Scheduled
Thu 2-Sep-21
Thu 2 Sep
Analysis & Dashboards
Sydney
Status: Scheduled
Scheduled
Parramatta
Date
Course
City
Status
Tue 1-Jun-21
Tue 1 Jun
Analysis & Dashboards
Parramatta
Status: Scheduled
Scheduled
Wed 4-Aug-21
Wed 4 Aug
Analysis & Dashboards
Parramatta
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Mon 12-Apr-21
Mon 12 Apr
Analysis & Dashboards
Melbourne
Status: Scheduled
Scheduled
Fri 28-May-21
Fri 28 May
Analysis & Dashboards
Melbourne
Status: Scheduled
Scheduled
Fri 9-Jul-21
Fri 9 Jul
Analysis & Dashboards
Melbourne
Status: Scheduled
Scheduled
Mon 9-Aug-21
Mon 9 Aug
Analysis & Dashboards
Melbourne
Status: Scheduled
Scheduled
Thu 2-Sep-21
Thu 2 Sep
Analysis & Dashboards
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Tue 1-Jun-21
Tue 1 Jun
Analysis & Dashboards
Canberra
Status: Scheduled
Scheduled
Wed 4-Aug-21
Wed 4 Aug
Analysis & Dashboards
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Tue 1-Jun-21
Tue 1 Jun
Analysis & Dashboards
Adelaide
Status: Scheduled
Scheduled
Wed 4-Aug-21
Wed 4 Aug
Analysis & Dashboards
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Tue 22-Jun-21
Tue 22 Jun
Analysis & Dashboards
Perth
Status: Scheduled
Scheduled
Fri 16-Jul-21
Fri 16 Jul
Analysis & Dashboards
Perth
Status: Scheduled
Scheduled
Mon 16-Aug-21
Mon 16 Aug
Analysis & Dashboards
Perth
Status: Scheduled
Scheduled
Thu 9-Sep-21
Thu 9 Sep
Analysis & Dashboards
Perth
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
L10, 333 Adelaide Street, Brisbane QLD 4000

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 37 Pitt Street, Sydney NSW 2000

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 90 Phillip Street, Parramatta NSW 2150

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 466 Little Lonsdale St, Melbourne VIC 3000

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 97 Pirie Street, Adelaide SA 5000

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Analysis and Dashboards Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4, 220 St Georges Tce, Perth WA 6000

*Limited in-class seats due to COVID-19.
microsoft_gold

Excel Specialist Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Project Training Courses
Data Analytics Training Courses
Python Training Courses
Microsoft Power Apps Training Courses
Microsoft SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Project Training Courses
Data Analytics Training Courses
Python Training Courses
Microsoft Power Apps Training Courses
Microsoft SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Course Rating
Excel Specialist Training Courses

4.68 5 Excel Specialist Training Courses
4.68 out of 5
840 Student Reviews

Contact Us



What do I need to know to attend?

This Excel Analysis & Dashboards training course is suitable for those who already have an intermediate level knowledge of Excel.

The course is aimed at those who want to use the latest features of Excel to their full capability.

Attendance of our other courses is not a pre-requisite for this course.

This course is not recommended for MAC users.

Excel Analysis and Dashboards Learning Outcomes

  • Connect to cloud databases and websites
  • Create relationships using a Power Pivot data model
  • Effectively analyse data in Excel
  • Create interactive visualisations

 

  • Review Pivot Tables and Charts within a data model
  • Extend Pivot Table and Chart technical skills and features
  • Use a from web data forlive share price connection
  • Manipulate data sources using query editor

Excel Analysis and Dashboards Course Content

  • Data Modelling
  • Starting a dataset in Excel
  • Multiple Tables
  • Data Modelling
  • Get & Transform
  • Understanding Get & Transform
  • Understanding the Navigator Pane
  • Creating a New Query From a File
  • Creating a New Query From the Web
  • Understanding the Query Editor
  • Displaying the Query Editor
  • Managing Data Columns
  • Get & Transform (cont'd)
  • Reducing Data Row
  • Adding a Data Column
  • Transforming Data
  • Editing Query Steps
  • Merging Queries
  • Working With Merged Queries
  • Saving and Sharing Queries
  • The Advanced Editor
  • Power Pivot
  • Understanding Relational Data
  • Common Sense Data Modelling
  • Enabling Power Pivot
  • Connecting to a Data Source
  • Working with The Data Model
  • Working with Data Model Fields
  • Changing A Power Pivot View
  • Power Pivot (cont'd)
  • Creating A Data Model PivotTable
  • Using Related Power Pivot Fields
  • Creating A Calculated Field
  • Creating A Concatenated Field
  • Formatting Data Model Fields
  • Using Calculated Fields
  • Creating A Timeline
  • Adding Slicers
  • Great functions for Analysis
  • Understanding Data Lookup Functions
  • Using CHOOSE
  • Using VLOOKUP
  • Using VLOOKUP For Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using SUMIF
  • Using SUMIFS
  • Using SUMPRODUCT
  • Data Validation
  • Validation Criteria
  • Input Messages & Error Messages
  • Drop-Down Lists
  • Formulas
  • Customised Validation Criteria
  • Creating A Number Range Validation
  • Data Validation (cont'd)
  • Testing A Validation
  • Creating an Error Message
  • Creating a Drop Down List
  • Using Formulas as Validation Criteria
  • Circling Invalid Data
  • Removing Invalid Circles
  • Using Sparklines to show trends
  • What is a Sparkline?
  • Types of Sparklines
  • Showing Sparklines only
  • Specifying a Date Axis
  • Hidden Data and Sparklines
  • Sparklines and Targets
  • Using Conditional formatting
  • Using Conditional Formatting with a Dashboard
  • Top 10 & Custom Formatting
  • Data Bars
  • Show data bars outside the data cell
  • Colour Scales
  • Icon Sets
  • Creating Rules Based Icon Set
  • Removing unnecessary icons
  • Using Symbols in Reporting
  • Using the Camera Tool
  • Pivot Tables
  • Structure of Pivot Tables
  • Using Compound Fields
  • Counting in A PivotTable
  • Formatting PivotTable Values
  • Working with Grand Total & Subtotals
  • Finding the Percentage of Total
  • Finding the Difference From
  • Grouping in PivotTable Reports
  • Creating Running Totals
  • Pivot Tables
  • Creating Calculated Fields
  • Providing Custom Names
  • Creating Calculated Items
  • PivotTable Options
  • Sorting in a PivotTable
  • Top and Bottom Views
  • Date Grouping Options
  • Hiding or Showing Data Items
  • Conditional Formatting and Sparklines in Pivot Tables
  • Pivot Caches and File Size
  • PivotCharts
  • Inserting a PivotChart
  • Defining the PivotChart Structure
  • Changing the PivotChart Type
  • Using the PivotChart Filter Field Buttons
  • Moving Pivot Charts to Chart Sheets
  • Moving Pivot Charts to Chart Sheets
  • Slicers in Reports
  • What are Slicers?
  • Creating Slicers
  • Using a Slicer on Multiple Pivot Tables
  • Renaming Pivot Tables
  • Timeline Slicer
  • Trending Charts
  • Why do we use Trending Charts?
  • Appropriate Chart Types for Trending
  • Vertical or Y-Axis Scales
  • Chart Titles linking to a Cell
  • Comparative Trending
  • Labelling
  • Using a Secondary Axis
  • Formatting Key Data Points
  • How to display Actuals and Forecasts
  • Averages and Data Smoothing
  • Other Report Charts
  • Top and Bottom Charts
  • How to show Top or Bottom in Data Labels
  • Waterfall Charts
  • Histograms
  • Creating Histograms using Formulas
  • Creating Histograms using Pivot Tables
  • Creating Histograms using Excel’s Statistical Charts
  • Charting performance against a target
  • Performance against Targets
  • Creating Thermometer Chart
  • Bullet Graph
  • Defining Dashboards
  • Purpose of a Dashboard
  • Working out what is needed
  • What are the data sources
  • Will the audience need further data to drill-down to?
  • How often will/can the data refresh?
  • Does it need to be maintained?
  • How easy will it be to maintain?
  • Dashboard Design Principles
  • Thirteen common mistakes in dashboard design
  • Making an Interface
  • Using Macros with Dashboards
  • Recording a Macro
  • Navigation using Macros
  • Macros to Change Chart types
  • Macros and Pivots
  • Pulling it all together – Case Study
  • We start with raw sales data for a Comedy Roadshow. We model a the data using PowerPivot, creating relationships and the necessary calculations to build our interactive Dashboard for assessing Sales performance and profitability across various cities.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25785 Reviews
Excellent course which was very well presented by Steve. Looking forward to getting hands on and applying the learnings. Thanks -Power BI Beginner Brisbane
David - Power BI Beginner, .
Steven was very clear and passionate about the course. I really enjoyed it and I feel much more confident using it after the course. Thank you so much. -Power BI Beginner Brisbane
Myrna - Power BI Beginner, .
The faciitator was great and very engaging. Was awesome that he kept checking in with how everyone was progressing to make sure nobody was left behind! The course was informative. However, I found that a large amount of the session I had already accomplished in my own time. So a more detailed description on the course overview/syllabus documents would be useful, explaining that it was an introductory level review for each of the components - as I feel the intermediate session would have been more benificial to me. -Power BI Beginner Melbourne
Ben - Power BI Beginner, .
the course improved my current level of expertise for using SharePoint. -SharePoint Site Owner Adelaide
kiran - SharePoint Site Owner, .
Great course. Taught me a variety of skills. Jagg is very welcoming and down to earth. -SharePoint Site Owner Adelaide
Jennifer - SharePoint Site Owner, .
Excellent course, keep up the good work! -SharePoint Site Owner Adelaide
Harold - SharePoint Site Owner, .
Great introduction to BI :-) -Power BI Beginner Melbourne
Jules - Power BI Beginner, .
I thoroughly enjoyed the course - Ken is entertaining and engaging, I will be back for the intermediate course -Power BI Beginner Melbourne
Hollie - Power BI Beginner, .
Ken Powell was an excellent presenter. He is very knowledgeable and explains everything very clearly and concisely. I would definitely recommend the course to anyone wanting to be able to confidently start using Power BI. -Power BI Beginner Melbourne
ALISON - Power BI Beginner, .
Very thorough and informative. Great program and the trainer demonstrated that very well. -Power BI Beginner Canberra
Ashlie - Power BI Beginner, .
Very knowledgeable facilitator. At times, it was a bit fast but I got there in the end. Thank you. -Power BI Beginner Melbourne
Cristian - Power BI Beginner, .
The course content was very good and easy to follow for beginners. -Power BI Beginner Melbourne
Kiley - Power BI Beginner, .
Excellent customization of course for audience good interactive learning well paced -SharePoint Site Owner Canberra
Tony - SharePoint Site Owner, .
Good cross section of information and a nice balance between theory and real world practicality. -SharePoint Site Owner Canberra
Tonya - SharePoint Site Owner, .
Great training from John. Very informative and patient when anyone asked questions or needed assistance. -Excel Beginner Remote Online
Greg - Excel Beginner, .
The course was very helpful , I will be using these new skills to complete my quarterly report's . I found each chapter very useful and cant wait to use these new skills at work . John was extremely helpful and very patient . -Excel Beginner Melbourne
Cheryl - Excel Beginner, .
John made it learning excel seem easy. He was patient, thorough and positive. I honestly didn't think I would come away with some of the skills I learned today and I thought it may be a bit boring, but the day went really quickly and John maintained my interest the whole time. -Excel Beginner Melbourne
Fiona - Excel Beginner, .
great :) cant wait to come back.. -Excel Beginner Melbourne
Caitlin - Excel Beginner, .
This course was very well-structured, John was a very thorough teacher who made learning enjoyable. I look forward to the intermediate excel course! -Excel Beginner Melbourne
Demelza - Excel Beginner, .
Very good training, easy to learn and understand from the trainer. John went in depth without confusing us. I feel competent using Excel now. :) -Excel Beginner Remote Online
Caitlin - Excel Beginner, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us