Webinar – Dashboards #3 – Sparklines and Conditional Formats

Price $25 incl GST

This is the third in the series and focuses on Sparkline charts added in Excel 2010 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
  • SUMPRODUCT function
  • 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
  • using templates

As always, I will share other tips and tricks along the way.

Date: May 29, 2019
Time: 1:00 PM AEST
Event: Webinar - Dashboards #3 - Sparklines and Conditional Formats
Topic: Dashboards #3 - Sparkline and Conditional Formats
Public: Public
Registration: Click here to register.