Excel Yourself/Dashboard Bundle 2024

Dashboard Bundle 2024

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.

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)

  • Dashboard #5 - Dynamic Arrays (1.5 hrs)

  • BONUS! Excel Chart Hacks (1 hr)

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

  • $100

Dashboard Bundle 2024

  • 15 Products

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.

Contents

  • Free

Dynamic Arrays Introduction

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: Free

  • $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

  • Free

Excel Chart Tips and Tricks

  • Closed

Discover quick and easy ways to edit charts.

  • 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

  • Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.

  • Free

Excel Dashboards #1 - Guidelines - 2024

Lots of ideas to improve your charts and dashboards. Version: All Versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: Free

  • $25

Excel Dashboards #2 - Formula-based 2024

Discover how to use classic Excel formulas to create charts for your dashboard. Version: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

  • $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

  • $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

  • $25

Excel Dashboards #3 - Sparklines & Conditional Formats 2024

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. This sessions has been updated to use dynamic arrays. Version: Microsoft 365 Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

  • $25

Excel Dashboards #4 - PivotCharts and Slicers 2024

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Versions: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

  • $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

  • $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

  • $25

Excel Dashboards #5 - Dynamic Arrays 2024 (1.5hrs)

This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays. Subscription version required. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail and a total in a single formula. Version: Microsoft 365 Recorded: March 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

  • 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