Tabellab

Excel for Purchasing Buyers: Quotes, Purchase Orders, Savings & Suppliers

20 hands-on labs for buyers and purchasing assistants: PO totals with freight and tax, RFQ comparison, total cost of ownership, price breaks, savings tracking, open PO follow-up, supplier scorecards, spend by category, EOQ, MOQ rounding, currency conversion, a buyer dashboard – then prices per base unit, freight allocation, last-price lookups, lead times, approval levels, blanket orders, a contract calendar and a quarterly supplier review.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

Twenty hands-on Excel labs for buyers and purchasing assistants at a small furniture maker. You check purchase orders with freight and tax, compare RFQ answers, calculate total cost of ownership, pick volume price breaks with XLOOKUP, track savings against the last price, follow up open and overdue POs, score suppliers, analyse spend by category, size order quantities with EOQ and MOQ rounding, convert foreign-currency quotes and build a spend-versus-budget dashboard. The second half adds daily buyer work: prices per kilogram or metre across pack sizes, freight split by value and by weight, the last price paid from a price log, quoted versus actual lead times, approval levels and split orders, blanket-order releases, notice deadlines with EDATE and a quarterly supplier review with a sorted chart. Every cell is checked instantly; all companies and prices are fictional.

Lessons

  1. Purchase Order: Line Totals, Freight and Sales TaxLabFree
  2. RFQ Comparison: Best Price per Item and Best BasketLab Locked
  3. Total Cost of Ownership: Price, Freight, Duty and Payment TermsLab Locked
  4. Volume Price Breaks: The Right Price with XLOOKUPLab Locked
  5. Savings Tracking: Price Variance against the Last PriceLab Locked
  6. Open PO Tracker: Overdue Orders and Days LateLab Locked
  7. Supplier Scorecard: On-Time Delivery, Quality and a Weighted ScoreLab Locked
  8. Spend by Category and Supplier: SUMIFS and SharesLab Locked
  9. Economic Order Quantity: How Much to Order at a TimeLab Locked
  10. Minimum Order Quantity and Pack Sizes: CEILING and MAXLab Locked
  11. Quotes in Foreign Currencies: Converting to USDLab Locked
  12. Buyer Dashboard: Spend vs Budget with a Chart and HighlightsLab Locked
  13. Quotes in Different Pack Sizes: Price per Base Unit and the Real Cheapest OfferLab Locked
  14. Allocating Freight to PO Lines: By Value, by Weight & the Rounding CentLab Locked
  15. Price History: The Last Price Paid with XLOOKUP from the Bottom, Lowest Prices & Price DriftLab Locked
  16. Lead Times: Quoted vs Actual Days per Supplier, the Longest Wait & a Realistic Arrival DateLab Locked
  17. Approval Levels: Routing Requisitions by Amount with XLOOKUP & Spotting Split OrdersLab Locked
  18. Blanket Orders: Monthly Releases, Remaining Quantity & When the Agreement Runs OutLab Locked
  19. Contract Calendar: End Dates & Notice Deadlines with EDATE, Days Left and an Act-Now ListLab Locked
  20. Final Project: Quarterly Supplier Review – Spend, Shares, On-Time Rates, Savings & the First Supplier to CallLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy