Date: | 21/03/2024 |
---|---|
Time: | 1:00 PM AEDST |
Event: | Dashboards #3 - Sparklines and Conditional Formats |
Topic: | Dashboards #3 - Sparkline and Conditional Formats |
Public: | Public |
Registration: | Click here to register. |
Webinar – Dashboards #3 – Sparklines and Conditional Formats
Price: AU$25
This session requires the subscription version of Excel.
This is the third in the series and focuses on Sparkline charts as well as using Conditional Formatting with dashboards.
Sparkline charts are small charts that are specifically designed for dashboards.
We will add ticks and crosses using conditional formats to identify measures (good and bad) that may need review.
The Chart Data sheet structure has already been populated so we will review some of the formulas used in its creation.
The session includes
- reviewing report formulas
- MATCH function
- Dynamic arrays
- handling high score is bad vs low score is bad in a formula
- default settings you may need to change for Sparkline charts
- controlling the display of ticks and crosses
- formats for dashboards
As always, I will share other tips and tricks along the way.