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.
Level: Intermediate
Duration: 1 hour
Price: AU$25