Capstone: The Monthly Savings Dashboard by Category with a Chart
This lesson is part of the course
In this lesson
You turn Lena's October receipts into a dashboard: the saving per receipt line, regular price, paid and saving per category with SUMIFS, the overall saving rate and a column chart of the savings by category.
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
- Unit Prices: Price per 100 g, per Litre and per Piece Locked
- Pack-Size Ladders: Is the Bigger Pack Always Cheaper? Locked
- Multi-Buy Offers: «3 for 2», Half-Price Seconds and «Buy 4, Save» Locked
- Bulk vs Actual Use: Months to Use Up, Leftovers and the Real Cost Locked
- Coupons, Points & Cashback: Percent vs Fixed, Caps and the Order of Discounts Locked
- Shrinking Packs: Same Price, Less Inside – Tracking the Unit Price over Time Locked
- Your Personal Price Book: Cheapest Shop per Item and the Basket Total per Shop Locked
- Capstone: The Monthly Savings Dashboard by Category with a Chart Locked