Login
Excel Yourself/Dashboard Bundle 2023
Buy now

Dashboard Bundle 2023

In the Bundle there are four webinars that create a different Dashboard each. Learn about the formulas, features and techniques that allow you to make Dashboards in Excel.

A new course has been added that builds a dashboard with dynamic arrays. This needs the subscription version of Excel.

A BONUS course has been added with Excel Chart Hacks. 

The Bundle includes

  • Chart Tips and Tricks (1 hr)

  • Interactive Charts (1 hr)

  • Dashboard #1  - Guidelines and techniques including a  Bullet Chart (1 hr)

  • Dashboard #2 - Formula-based Dashboard (1 hr)

  • Dashboard #3 - Sparklines and Conditional Formats (1 hr) 

  • Dashboard #4 - PivotCharts and Slicers (1 hr)

  • NEW! Dashboard #5 - Dynamic Arrays - added March 2023 (1.5 hrs)

  • BONUS! Excel Chart Hacks (1 hr)

Level: Intermediate to Advanced
Duration: 8.5 hours
Price: AU$80

  • $80

Dashboard Bundle 2023

Find out about the different ways you can create dashboards in Excel using: 
  • Formulas and functions
  • Sparklines
  • Conditional formats
  • PivotCharts
  • Slicers
  • Dynamic arrays
BONUS Excel Hacks course included.
Buy now AU$80

Contents

  • $25

Excel Chart Hacks

Learn how to create non-standard charts in Excel. Includes using text boxes, high/low charts, variance charts, conditional colours, Waterfall charts, banding and expanding ranges. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25
View product

  • Free

Excel Chart Tips and Tricks

  • Closed

Discover quick and easy ways to edit charts.
View product

  • Free

Excel Chart Tips and Tricks 2021

Discover quick and easy ways to edit charts. Version: All Versions Recorded: Nov 2021 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.
View product

  • $25

Excel Dashboards #2 - Formula based dashboard

Discover how to use classic Excel formulas to create charts for your dashboard. Lots of different techniques covered. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25
View product

  • $25

Excel Dashboards #3 - Sparklines and Conditional Formats

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25
View product

  • $25

Excel Dashboards #4 - PivotCharts & Slicers

  • Closed

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Version: All versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25
View product

  • $25

Excel Dashboards #5 - Dynamic Arrays (1.5 hours)

  • Closed

This is the fifth in the dashboard series & focuses on creating a dashboard using dynamic arrays. This session requires the subscription version of Excel. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail & a total in a single formula. Version: Microsoft 365 Recorded: Mar 2023 Level: Advanced Duration: 1.5 hours Price: AU$25
View product

  • Free

Interactive Excel Chart 2022

Learn how to build in interaction to your charts. Includes worksheet controls - combo boxes and a scroll bar. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1 hour Price: Free
View product