Excel for the Fashion Industry
Edition: 1
Copyright: 2025
Pages: 122
Choose Your Format
Choose Your Platform | Help Me Choose
Ebook
$70.00 USD
This text teaches how to use Excel for fashion design, merchandising, marketing, and career development. It begins with Excel basics, including creating workbooks, entering and formatting data, using formulas, creating charts, and analyzing data with ChatGPT. It then applies these skills to fashion through production calendars, spec sheets, cost sheets, line sheets, fashion shows, sales reports, buying budgets, pricing, marketing calendars, and social media tracking. The final unit focuses on preparing a fashion résumé and finding entry-level jobs and internships.
About the Author
Introduction
UNIT 1: Creating and Using Excel Workbooks
Topic 1.1: Introduction to Excel Workbooks
Lesson 1: Starting Excel
Lesson 2: Exploring the Ribbon
Lesson 3: Creating a Worksheet
Topic 1.2: Excel Functions/Entering Data/Spreadsheet Formatting
Lesson 1: Entering Cell Content
Lesson 2: Inserting Images
Lesson 3: Formatting Data
Topic 1.3: Using Formulas/Charts and Graphs/Data Analysis
Lesson 1: Formatting Numbers
Lesson 2: Entering Formulas and Calculating Percentages
Lesson 3: Charts and Graphs
Lesson 4: Data Analysis/ChatGPT
Exercise 1: Fashion Spreadsheet
UNIT 2: Excel for Fashion Design
Topic 2.1: Fashion Design Production Spreadsheets
Lesson 1: Production Calendars
Lesson 2: Spec Sheets
Lesson 3: Cost Sheets
Lesson 4: Line Sheets
Topic 2.2: Styling/Fashion Show Spreadsheets
Lesson 1: Fashion Show Gantt Chart
Lesson 2: Fashion Week Guest List
Lesson 3: Backstage/Model Chart
Lesson 4: Merchandise Pull Sheet
Exercise 2: The Cost of Fashion
UNIT 3: Excel for Fashion Merchandising
Topic 3.1: Merchandising and Buying Spreadsheets
Lesson 1: Sales Reports
Lesson 2: Analyzing Sell-Through Reports/Markdowns
Lesson 3: Open-to-Buy (OTB) Budgeting/Purchase Orders (POs)
Lesson 4: Calculating Markups/Retail Pricing Spreadsheets
Exercise 3: Vegan Leather Purchase Order (PO)
Topic 3.2: Fashion Marketing Spreadsheets
Lesson 1: Creating a 4-5-4 Merchandising Calendar
Topic 3.3: Social Media/Brand Management Spreadsheets
Lesson 1: Tracking Influencer Sales
UNIT 4: Jobs in Fashion
Topic 4.1: Fashion Résumé
Topic 4.2: Entry-Level Jobs and Internships in Fashion
Dena’s expertise lies in instructing undergraduate students in the areas of retail merchandising and retail
math, with a specific focus on utilizing Microsoft Excel. Currently, she serves as an adjunct professor at
Montclair State University, Southern New Hampshire University, and Middlesex College. She has a
Master of Science in apparel and textiles, a Bachelor of Science in business management with an emphasis on e-commerce, and an associate of arts degree in fashion design. She has over a decade of industry experience after working in roles such as brand designer, assistant buyer, and merchandising associate.