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.

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.