Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Retail Math & Excel: How to plan & evaluate buys & sales
Rating: 4.0 out of 5(1 rating)
1 students

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

Learn how the big companies plan their apparel business
Last updated 1/2026
English

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

Course content

4 sections5 lectures1h 9m total length
  • Retail Math Metrics (in Excel)21:55
  • Excel Formulas Part 13:37

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 the retail math and Excel foundations used inside large companies to plan sales, inventory, and profitability.

If you want to break into or succeed in corporate 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 shows how the math fits into the job:



Who This Course Is For

  • Aspiring or early-career assistant buyers,  allocators, and inventory analysts

  • Professionals transitioning into corporate 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.