Retail Math & Excel: How to plan & evaluate buys & sales

Retail Math & Excel: How to plan & evaluate buys & sales
Published 1/2026
Duration: 1h 10m | .MP4 1920×1080 30fps(r) | AAC, 44100Hz, 2ch | 831.71 MB

Learn how the big companies plan their apparel business

What you’ll learn
– Sell thru calculation (ST%)
– Markup
– AUR Average Unit Retail
– % Ttl Category mgmt
– Buying Excel Formulas
– Assortment Planning
– Excel Formulas
– SUMIF
– Vlookup
– Conditional Formating
– Filter
– Average Incentory
– EOH BOH

Requirements
– Calculator and or Excel
– Desire to learn retail math

Description
Apparel industry

Retail Math & Excel: How Big Companies Actually Plan Their Business

This course teaches theretail math and Excel foundations used inside large companiesto plan sales, inventory, and profitability.

If you want to break into or succeed incorporate buying, apparel planning, allocation, or inventory analyst roles, these are the core skills you’re expected to understand-often without being taught them clearly.

Core retail math metrics used by buyers, planners, and merchants(sales, inventory, sell-through, AUR, Markup)

How these metrics connect to real business decisions

How Excel is used to plan and track bought and designed inventory

How to structure spreadsheets the way corporate teams expect

How to think like a buyer, planner, and analyst-not just calculate numbers

Most retail math content explains formulas in isolation.This course showshow the math fits into the job:

Who This Course Is For

Aspiring or early-career assistantbuyers, allocators, and inventory analysts

Professionals transitioning intocorporate retail or apparel roles

Sales or merchandising professionals who want to better understand how decisions are made

Boutique buyers looking to be more profitable

What You Need

Basic Excel familiarity (opening files, tapping into a cell)

No prior retail planning experience required

EXCITMENT!!! Love what you do!

Who this course is for:
– This is for anyone looking to brush up skills, validate or learn from begging how retail math is used in big corporations. This can be used for small boutique buyers as well.
More Info