Capstone: A One-Screen Pet Health Dashboard
This lesson is part of the course
In this lesson
You build Pepper's dashboard: the weight trend in kg per week with SLOPE, the next open care date with MINIFS, the number of open items due within 30 days and a weight chart.
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
- The Weight Log: Weekly Gain in Grams and Percent, Average Daily Gain Locked
- Estimating Adult Weight: Size Classes and Multipliers with XLOOKUP Locked
- Growth Chart: Above/Below Flags Against a Reference Band and a Line Chart Locked
- Body Condition Score Log and the Implied Target Weight Locked
- Age in Human Years: A Linear Rule vs a Log Formula with LN Locked
- The Care Calendar: Next Due Dates with EDATE, Days Left and Overdue Flags Locked
- Activity Log: Weekly Walk and Play Minutes with ISOWEEKNUM and SUMIFS Locked
- Capstone: A One-Screen Pet Health Dashboard Locked