Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Fashion
Welcome!
Welcome!
Quick useful info about this course (3:41)
NEW! Join our brand new community platform (6:56)
BONUS: Fashion KPIs and abbreviations
PART 1: Basics
Excel fun tour plus basics (10:30)
How to print (nice and professionally) all of your sheets (14:20)
Don't forget to save! (2:40)
Call me by your name: is this a data? Currency? All about formatting! (3:17)
Wrap Text, add column/row, copy/paste, borders, shortcuts (7:49)
Paste-Special (3:06)
PART 2: Functions
How do I get rid of these??? Removing blanks in 3,2,1... (1:37)
Can you show me this quickly?? Welcome to Conditional Formatting (24:05)
We use images to communicate in fashion. How to add images into your sheets (4:47)
Anna Wintour. Anna. Wintour. This function will save you! Text to Columns and Flash fill (8:39)
Show me Chanel: all about filters! (9:32)
Drop Down menus (3:33)
Transpose: AKA exchange raws and columns (2:09)
Block a row/column (4:40)
PART 3: FORMULAS
Intro to formulas (9:50)
Concatenate (Merge Names, Create Product Code, Season and Description) (10:25)
Find and Replace (7:18)
DIOR, dior, Dior...3 Text Formulas for you! (4:57)
What's the sell through and how to calculate it? (5:11)
Sum Formula (4:04)
SUM IF (9:56)
Count and Count if (Who seats on the first row? British Fashion Awards) (9:10)
Percentage %%% (13:01)
% Difference : compare two years (14:01)
IF (Restock, Markdowns, Bonus) (23:20)
PART 4: Advanced
VLookup formula (11:52)
Vlookup error! IMPORTANT BEFORE USING VLOOKUP (5:16)
Vlookup Advanced Absolute Reference (8:59)
Building a pivot table (8:55)
Rename Fields + Refresh (1:24)
Analyse with Pivot Tables (7:05)
PART 5: Organizing with Excel
Samples Management (5:10)
Range/ Collection Plan (7:11)
Purchase Order Form (15:18)
You made it! Can you do me a favour?
You made it! 🎉🎉🎉🎉 (1:10)
NEW! Join our brand new community platform
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock