Your Personal Price Book: Cheapest Shop per Item and the Basket Total per Shop
This lesson is part of the course
In this lesson
You keep a price book of six items at three shops, find the cheapest price per item with MINIFS, total the monthly basket per shop with SUMIF or SUMPRODUCT, price the split basket and decide whether the extra trips are worth it.
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