Tabellab

Excel for Online Sellers: Profit per Order, Fees, Ads & Stock

20 hands-on labs for small Shopify, Etsy and marketplace sellers: clean an order export, profit per order after fees and shipping, product margins, target-margin pricing, ROAS and break-even ROAS, discount codes, returns, days of stock and reorder points, bestsellers, sales by channel, repeat customers and a half-year dashboard, then decode SKU codes with text formulas, join exports with XLOOKUP, clean a customer list, build a scent × size heat map, band order values, analyse product reviews, separate season from growth and finish with a year-end seller report.

20 lessons 20 labs Certificate

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

About this course

This course is for small online sellers who want answers their shop dashboards do not give, in 20 auto-graded spreadsheet labs built on a fictional candle shop. You clean an order export, calculate profit per order after payment fees and shipping, build a product margin table, price with a target margin, judge ads with ROAS and break-even ROAS, cost a discount code, measure returns, set reorder points, rank bestsellers, sum sales by channel, measure repeat customers and build a half-year dashboard. Part two adds the everyday Excel skills behind good reports: decoding SKU codes with text formulas, joining two exports with XLOOKUP, cleaning a guest-checkout customer list, a scent × size heat map with one SUMIFS, order-value bands with COUNTIFS, product review statistics, month-over-month versus year-over-year growth and a year-end seller report with a stacked channel chart.

Lessons

  1. Order Export Cleanup: Order Numbers, SKUs and Line TotalsLabFree
  2. Profit per Order after Payment Fees and ShippingLab Locked
  3. Product Margin Table: Which SKUs Earn Enough?Lab Locked
  4. Pricing with a Target Margin (Not a Markup)Lab Locked
  5. Ad Spend: ROAS, Cost per Order and Break-even ROASLab Locked
  6. Discount Codes: What 15% Off Really CostsLab Locked
  7. Returns and Breakage: Return Rate and Cost per SKULab Locked
  8. Inventory: Days of Stock and When to ReorderLab Locked
  9. Bestseller Ranking with SORT and LARGELab Locked
  10. Monthly Sales by Channel with SUMIFS (Chart)Lab Locked
  11. Customer Repeat Rate and Revenue from Returning BuyersLab Locked
  12. Half-Year Dashboard: Profit, Margin, Chart and Colour ScaleLab Locked
  13. SKU Codes Decoded: Scent and Size with LEFT, FIND and MID – and New SKUs with TEXTLab Locked
  14. Joining Two Exports: Unit Costs into Order Lines with XLOOKUP and a «missing» Safety NetLab Locked
  15. Customer List Cleanup: Clean Emails, Duplicate Flags, Missing Countries & the Real Customer CountLab Locked
  16. Scent × Size Matrix: One SUMIFS with Mixed References and a Colour-Scale Heat MapLab Locked
  17. Order Values in Bands: COUNTIFS from–to, Median vs AOV and a Column ChartLab Locked
  18. Product Reviews by the Numbers: Average Stars, Low-Star Share and Review Rate per SKULab Locked
  19. Growth over Time: Month-over-Month vs Year-over-Year and a 3-Month Average (Line Chart)Lab Locked
  20. Final Project: Year-End Seller Report – Channels, Profit, Margin, Growth and a Stacked ChartLab 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