MODULE 1: THIS IS EXCEL IN FASHION - BASICS

• The beginning of a love relationship: a first-date tour plus the basics
• Don't forget to save!
• Printing your sheets (but make it nice, fashion is all about visuals after all;) )
• Call me by my name: it this date 🗓? 💰$? Bags? Shoes? All about formatting
• This is not a simple paste. It's a paste special. We are in fashion

BONUS: SHORTCUTS PDF

BONUS: WORKSHEETS TO PRACTICE

MODULE 2: FUNCTIONS

• How do I get rid of these??? Removing blanks in 3,2,1...
• Show me the best (and the worst). Conditional Formatting
• We use images to communicate in fashion. How to add images into your sheets so they go all over the place?
• Anna Wintour. Anna. Wintour. This function will save you!
• Are there still fashion copycats? Removing duplicates.
• Absolute reference

BONUS: WORKSHEETS TO PRACTICE

MODULE 3: FORMULAS

• The most used formulas in fashion
• Learn how to calculate % and % difference
• Retail Math, Metrics and KPIs: Sell-through, stock, inventory
• Fashion Business Margin, profit, ROI
• IF formula (Markdowns, employee bonuses, it's time to restock??)
• YOY comparing two periods (this week vs this week last year)
• Concatenate (Marge names, create the product code, Season and Description...)
• DIOR, Dior, dior... 3 text formulas!
• COUNT IF (how many are seated on the first row of the fashion show?? Who is seating at tables 1 and 3 at the British Fashion Awards??)
• SUM IF

BONUS: WORKSHEETS TO PRACTICE

MODULE 4: CALL ME THE QUEEN OF EXCEL

• Pivot Tables
• VLOOKUP
• Graphics

BONUS: WORKSHEETS TO PRACTICE

MODULE 5: BUILDING FASHION DOCUMENTS

• Managing Samples (Fashion PR, stylist..)
• Building your range/collection plan
• Build your order sheets(used in buying, showrooms)

BONUS: TEMPLATES AND WORKSHEETS

MODULE 1. BUSINESS MODELS: COUTURE VS READY-TO-WEAR VS FAST FASHION

The words "couture," "haute couture," "ready-to-wear," and "fast fashion" get thrown around a lot. But what do these terms actually mean? In this section we will breakdown the differences between these sectors of the industry and consider their histories.

MODULE 2. MANUFACTURING

In this section, we will look at the history of fashion production from key inventions of the industrial revolution to the globalization of the industry and fast fashion production. As part of this overview, we will consider standardized sizing and pattern-making, as well as the rise of factory labor and 3D-printing.)

MODULE 3. FASHION FIBRES

Textiles are the building-blocks of fashion. This section will explore the vast array of materials that have been used to make fashion from the 18th century to the present. We will consider the history of natural fibers like cotton, silk, wool, and linen, but also the implications of new fibres and synthetics. We will also look as weave structures and explore the hierarchy of fabrics and how this has shifted over time, including a discussion of color and dye.

MODULE 4. THE RISE OF THE CELEBRITY DESIGNER

Today's fashion industry is organized around designer names and personalities, but when did this start? This section will look at the history of the fashion designer and see how the status of designers shifted from dress-makers to celebrities over the last 200 years. 

MODULE 5. BRANDING

Branding is so ingrained in consumer culture today that it can be difficult to recognize. This section will explore the history of branding as a business strategy and unpack the profound effect it has had on the industry since the 1980s. 

MODULE 6. RETAIL

This section will explore the history of fashion retail from the rise of the department store in the 19th century to the global domination of e-commerce. As part of this history, we will consider the role of buyers, merchandisers, and other retail insiders in the evolution of the industry.  

MODULE 7. GLOBALIZED FASHION MEDIA

In this section, we will look at the rise of the global fashion media machine. We will explore the history of fashion media from 18th century fashion plates to the launch of key titles like Vogue and Harper's Bazaar. This section will also look at the profound impact of social media on the dissemination of fashion. 

MODULE 8. THE FASHION SHOW AND FASHION WEEKS

Fashion Weeks have become a global phenomenon. This section will look at the history of Fashion Week and explore how fashion shows grew from small industry presentations to massive staged events attended by throngs of hundreds and live-streamed around the world. 

MODULE 9. ACCESSORIES AND BEAUTY

Accessories and Beauty are key sectors of the industry and are often the primary source of revenue for fashion brands. This section will look at the history of these products and consider how they came to dominate the fashion economy. 

MODULE 10. SUSTAINABLE FASHION FUTURES

Sustainability is a central focus of the contemporary fashion industry. This section will explore different sustainability strategies from new fibres, upcycling, and resale, to labor issues and local production. In this section we will consider the carbon footprint of fashion and how we can address this in the future.

MODULE 11. INCLUSIVITY AND DIVERSITY

This section will explore diversity and inclusion in fashion, and consider the ways activists, industry leaders, and brands have been working to disrupt the lack representation in the industry in recent years. We will discuss issues related to race, size, gender identity, and disability.