Tutorvo

Capstone: KPI Table with Sparklines, Rules & a Chart

Lesson 8 of 820 minLab

This lesson is part of the course

In this lesson

You finish Brightwater's half-year KPI table: the change from July to December, a sparkline per store, red for the stores that shrank, and a sorted bar chart of the change.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Highlight Cell Rules: Greater Than, Between, Text ContainsLab15 min Locked
  2. Top/Bottom Rules & Above/Below AverageLab15 min Locked
  3. Duplicate & Unique ValuesLab14 min Locked
  4. Colour Scales: Two Heat MapsLab15 min Locked
  5. Data Bars: In-Cell Bar ChartsLab13 min Locked
  6. Formula-Based Rules: Overdue Invoices & Banded RowsLab18 min Locked
  7. Combining Rules & Rule Order: One Status, Three ColoursLab16 min Locked
  8. Capstone: KPI Table with Sparklines, Rules & a ChartLab20 min Locked