LISTEN, WE GET IT, EXCEL IS NOT THE MOST GLAMOROUS TOPIC


But every single Retailer relies on Excel to operate their business.


Departments stores - Fashion speciality stores - Big Box stores - Off-price stores


The list goes on, but what they all have in common is that their Merchants use Excel every single day to do their job.

 

If you are not strong in Excel and want a career in Merchandising, Buying or Planning, then you need to develop your Excel skills.


Don't worry, this is where Retail Simplified, Excel for Retail course can help prepare you!

if you are INTERESTED IN A career in a RETAIL BUYING OFFICE & are not confident with excel then EXCEL FOR RETAIL course was made FOR YOU

This course walks you through everything you need to know about Excel for your day to day life as a Retail Merchant.

Whether you are interested in becoming a Merchandise Coordinator, Assistant Buyer, Assistant Planner, Assistant Product Manager, Replenishment Analyst or Allocation Analyst; Retail Simplified's Excel for Retail course is made for you.

If you are currently in a Merchant role and are looking to improve your Excel skills, please review the course curriculum to see if the course content is a good fit for you.

Course Curriculum

  • 1

    Welcome

  • 2

    Navigating Excel

    • Window Elements

    • Navigating Excel Training Video
  • 3

    The Home Tab

    • Section Introduction

    • Home Tab

    • Font & Paste Special Training Video

    • Format Painter Training Video

    • Borders Training Video

    • Merge & Wrap Text Training Video

    • Number Formatting Training Video

    • Conditional Formatting Training Video

    • Sort & Filter Training Video

    • Practice Your Learning
  • 4

    The Other Tabs

    • Section Introduction

    • Insert Tab

    • Page Layout Tab

    • Page Layout Training Video

    • Formula Tab

    • Data Tab

    • Data Tab Practice Your Learning

    • Review Tab

    • Review Tab Training Video

    • View Tab

    • View Tab Practice Your Learning
  • 5

    Cell Referencing

    • Section Introduction

    • Referencing In Formulas

    • Cell Referencing Training Video

    • Practice Your Learning
  • 6

    Introduction To Functions

    • Functions For Review

    • Functions Learning How To Guide
  • 7

    Text Functions

  • 8

    Lookup Function

    • Section Introduction

    • VLOOKUP

    • VLOOKUP Training Video

    • Practice Your Learning

    • XLOOKUP Training Video
  • 9

    Logical Functions

    • Section Introduction

    • IF IFERROR

    • IF Training Video

    • IFERROR Training Video

    • Practice Your Learning
  • 10

    Math Functions

    • Section Introduction

    • SUBTOTAL

    • SUBTOTAL Training Video

    • SUBTOTAL Practice Your Learning

    • ROUND MROUND

    • ROUND (+ UP & DOWN) Training Video

    • MROUND Training Video

    • ROUND & MROUND Practice Your Learning

    • Bonus: 99 Cent Endings

    • SUM AVERAGE COUNT

    • SUM AVERAGE COUNT Training Video

    • SUM AVERAGE COUNT Practice Your Learning

    • SUMIF AVERAGEIF COUNTIF

    • SUMIF AVERAGEIF COUNTIF Training Video

    • SUMIF AVERAGEIF COUNTIF Practice Your Learning

    • SUMIFS AVERAGEIFS COUNTIFS

    • SUMIFS COUNTIFS AVERAGEIFS Training Video

    • SUMIFS AVERAGEIFS COUNTIFS Practice Your Learning
  • 11

    PivotTables

    • Section Introduction

    • PivotTables

    • PivotTables Training Video

    • Practice Your Learning
  • 12

    Final Assignments

    • Section Introduction

    • Assignment #1

    • Assignment #2

    • Assignment #3
  • 13

    Closing

    • Congratulations You Are Done!

What makes Excel for Retail different from other Excel courses?

  • Excel for Retail has simplified Excel to what you need to know as Retail Merchant, making your Excel learning experience less overwhelming

  • Excel for Retail relates Excel to retail, so your learning experience is practical

  • Excel for Retail has created assignments using synthetic data, to mimic what you would encounter while working in retail

  • Excel for Retail has been created and tested by Retail Buyers

Testimonials

the best example of developing the basic fundamentals of excel for retail

Tiffany C., Buyer

I highly recommend Retail Simplified and the Excel for Retail course. It is the best example of developing the basic fundamentals of excel for retail. The course content was thorough, easy to follow and will teach anyone the knowledge and clear set of practical skills needed.

real-world application of functions and best practices in Excel

Keenan L., Associate

Retail Simplified is an excellent resource for first-time retailers or those with experience like myself who need to brush up on the basics to make their workload easier. Samantha presents the material in a clear and concise way that reinforces the real-world application of functions and best practices in Excel. The overall design, flow, and workload for this course will leave you feeling motivated and wanting to explore the countless ways you can make your life easier in the retail space using Excel.

I would recommend Retail Simplified for anyone entering the Retail industry

Samantha R., Operations Coordinator

Retail Simplified has truly given me the confidence at work to complete tasks using excel, and be the go-to person for excel-related questions. Samantha is very skilled in excel, and having worked directly with her in previous companies, I can confidently say she has the knowledge and capabilities to help others. I would recommend Retail Simplified for anyone entering the Retail industry, or looking to refine their excel skills!

Samantha has curated based on her extensive experience working in the industry

Azraa K., Assistant Category Leader

Retail Simplified and the Excel for Retail course takes you through all of the fundamental excel functions that will ensure you're setup for success throughout your retail career. The course is easy to navigate, gives you the opportunity to learn at your own pace, and provides practical application exercises geared towards retail that Samantha has curated based on her extensive experience working in the industry. I would highly recommend Retail Simplified because it's an excellent resource that will allow you to be more efficient and productive in your day-to-day practices as a retail professional.

the course was exactly what I needed to get back on my feet in my role

Amanda D., Associate Planner

It goes without saying that I would highly recommend the Retail Simplified “Excel for Retail” course. I recently returned to work after 2 years off following a health scare and the course was exactly what I needed to get back on my feet in my role. As an associate planner, I have to use vlookup formulas and pivot tables in my daily work. Going through the training videos at my own pace was the perfect way to reinforce the key excel skills I need to succeed in my job.

FAQ

  • What currency do you charge in?

    The course is $119 USD. Approx. $140 Canadian.

  • Is this course just for the fashion industry?

    No! The Excel skills taught in this course are transferable no matter the sector of retail. Samantha the course creator has been on buying teams that purchased fashion accessories, leather jackets, shoes, home decor, confection, baby food, diapers and souvenirs.

  • Can I use a mobile device or tablet for this course?

    While the course is compatible with mobile devices and tablets. We would highly recommend using a computer to complete the practice assignments and final assignments in Excel.

  • What operating system was this course created on?

    This course was created on a Mac. If you are using a a Microsoft OS then the formula builder will be a pop up window and the ribbon/tabs will look a little different. The differences are only visual and should not effect your ability to work through the lessons.

  • Can I use Google Sheets?

    Can I use Google Sheets? No, you must use Microsoft Excel. If you do not have Microsoft Excel you can download a 1 month free trial. See below for link.

  • Do I need Excel?

    Do I need Excel? YES! This is an Excel course. To get the most out of the content you are going to want to practice in Excel. We recommend using the application not the web-based version, because Retailers use the application. You can download a Microsoft 365, 1 month free trial to complete the course content. See below for link.

  • How long does the course content take to complete?

    The course can take anywhere from approximately 5-12 hours.

  • How long do I have to complete the course?

    120 days (4 months) from date of purchase/enrollment

  • Is the course final sale?

    Yes, due to the digital nature of the course it is final sale. If you are not satisfied with the course you have 15 days from date of purchase to send an email to [email protected] to discuss the matter.

is the excel for retail course for me?


This is for you if…

This in not for you if…
  • You’re an aspiring Retail Merchant
  • You’re already a Retail Merchant but do not feel confident with your Excel skills
  • You’re a fashion school student or recent grad looking at careers in fashion buying
  • You graduated with a diploma or degree that was not business related
  • You’re not confident with Excel or know nothing about Excel
  • You’re tired of all the boring and hard to follow Excel courses out in the market
  • You are already a Retail Merchant with intermediate to advanced Excel skills
  • You have intermediate to advanced Excel skills
  • You aren’t willing to invest the time and effort into learning Excel
  • You have zero interest in Retail or Excel
  • You’re expecting to be an Excel expert overnight
  • You’re expecting to be an advanced Excel user by the end of the course

Still unsure or have questions? No worries send an email at [email protected]

Meet Your Instructor

Owner, Founder

Samantha Simons

Hi! I’m Samantha. I’m your Instructor and the Course Creator of Excel for Retail and the Founder of Retail Simplified. I have 10+ years of retail experience in fashion and consumer goods, working in buying, planning, replenishment, product development and store management. I have a Bachelor of Commerce Degree in Retail Management along with University level teaching experience. I also totally get that Excel is not the most glamorous of subjects and let’s be real Excel courses can be really boring. I am also thrilled that you’re here because you understand just how important it is for you to learn how to use Excel for your retail career. My goal with Excel for Retail is to make Excel fun, easy to follow and practical for the retail industry so you are better prepared for the real retail world. If you have any questions about the course send me an email! See you in class!

Ready to level up your Excel skills?

Sign up now to get access to Retail Simplified's exclusive Excel for Retail Course

Get started now