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.
- 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
- Order Export Cleanup: Order Numbers, SKUs and Line TotalsFree
- Profit per Order after Payment Fees and Shipping Locked
- Product Margin Table: Which SKUs Earn Enough? Locked
- Pricing with a Target Margin (Not a Markup) Locked
- Ad Spend: ROAS, Cost per Order and Break-even ROAS Locked
- Discount Codes: What 15% Off Really Costs Locked
- Returns and Breakage: Return Rate and Cost per SKU Locked
- Inventory: Days of Stock and When to Reorder Locked
- Bestseller Ranking with SORT and LARGE Locked
- Monthly Sales by Channel with SUMIFS (Chart) Locked
- Customer Repeat Rate and Revenue from Returning Buyers Locked
- Half-Year Dashboard: Profit, Margin, Chart and Colour Scale Locked
- SKU Codes Decoded: Scent and Size with LEFT, FIND and MID – and New SKUs with TEXT Locked
- Joining Two Exports: Unit Costs into Order Lines with XLOOKUP and a «missing» Safety Net Locked
- Customer List Cleanup: Clean Emails, Duplicate Flags, Missing Countries & the Real Customer Count Locked
- Scent × Size Matrix: One SUMIFS with Mixed References and a Colour-Scale Heat Map Locked
- Order Values in Bands: COUNTIFS from–to, Median vs AOV and a Column Chart Locked
- Product Reviews by the Numbers: Average Stars, Low-Star Share and Review Rate per SKU Locked
- Growth over Time: Month-over-Month vs Year-over-Year and a 3-Month Average (Line Chart) Locked
- Final Project: Year-End Seller Report – Channels, Profit, Margin, Growth and a Stacked Chart Locked
Learner reviews
Be the first to review this course.