Weekly Summary Report: Time in Ranges, Targets, Highlights & a Stacked Chart
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Readings per Day & Data Sufficiency (% of Expected Readings)Free
- Mean Glucose & Converting mg/dL ↔ mmol/L Pro
- Time in Range, Below & Above: COUNTIFS with 70–180 mg/dL Bands Pro
- Glucose Management Indicator: GMI = 3.31 + 0.02392 × Mean Pro
- Glucose Variability: SD, Coefficient of Variation & a Stability Flag Pro
- Daily Pattern by Hour: AVERAGEIFS & a Line Chart Pro
- Hypoglycaemia Events: Consecutive Readings Below 70 for ≥ 15 Minutes Pro
- Weekly Summary Report: Time in Ranges, Targets, Highlights & a Stacked Chart Pro