Tutorvo

Top/Bottom Rules & Above/Below Average

Lesson 2 of 815 minLab

This lesson is part of the course

In this lesson

You find the line a Top 3 rule and an average rule use, then colour Brightwater's three best-selling products and every product with a below-average margin.

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