Smart Shopping Math: Unit Prices, Pack Sizes, Multi-Buy Offers, Coupons and a Personal Price Book
Work out what things really cost: price per 100 g or per litre, whether the big pack or the «3 for 2» deal wins, coupons and points, shrinking packs and which shop is cheapest for your basket, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you shop like a calculator. You turn shelf prices into unit prices per 100 g, per litre or per piece and find the cheapest option with MINIFS and INDEX/MATCH. You check pack-size ladders for big packs that are not cheaper, model «3 for 2», half-price seconds and «buy 4, save» offers with INT and MOD, and test whether a bulk pack still pays off when you count only what you really use. You apply capped coupons, minimum spends, points and cashback in the right order, track shrinking packs over time, build a personal price book per shop and finish with a monthly savings dashboard and chart.
Lessons
- Unit Prices: Price per 100 g, per Litre and per Piece Pro
- Pack-Size Ladders: Is the Bigger Pack Always Cheaper? Pro
- Multi-Buy Offers: «3 for 2», Half-Price Seconds and «Buy 4, Save» Pro
- Bulk vs Actual Use: Months to Use Up, Leftovers and the Real Cost Pro
- Coupons, Points & Cashback: Percent vs Fixed, Caps and the Order of Discounts Pro
- Shrinking Packs: Same Price, Less Inside – Tracking the Unit Price over Time Pro
- Your Personal Price Book: Cheapest Shop per Item and the Basket Total per Shop Pro
- Capstone: The Monthly Savings Dashboard by Category with a Chart Pro