This 1 day workshop covers the more complex theory commonly used within Retail Fashion Buying and Merchandising departments.
Best Part time Course Studies in Statistics 2017. This 1 day workshop covers the more complex theory commonly used within Retail Fashion Buying and Merchandising departments. Through a combination of theory, discussion and practical examples, the workshop demonstrates that excel is vital to fashion retail. The course is structured around real-life business scenarios to put the theory into context.
The course will include:
Creating excel formulas
Working with tables
Printing and saving
The course is delivered by experienced tutors who are industry experts in the field of buying.
The following aspects are covered:
The Basics - Getting started, terminology, typing in a cell, selecting an area, inserting/deleting rows and columns
Creating Excel Formulas - Creating excel formulas, the basics =+-/*, drag/fill, BODMAS, the use of brackets, fixing cells
Functions - Auto sum/fill, if statements, Vlookup
Formatting - Bold, shading, font, borders, number formatting £, % decimal places, wrapping text, conditional formatting
Working with Tables - Freeze panes, split screens, pivot tables
Workbooks - Editing sheets, grouping sheets, calculations between worksheets
Printing & Saving - Print area, fit per page, gridlines, headers and footers, saving
Over 18 years of age, beginner.
In preparation for the course arrange to visit and compare some of the different retail areas in London including, Bond Street, Oxford Street and Westfield (White City or Stratford).
Pen and notebook
1 Day: 10.00am - 4.30pm (including lunch break)