Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Analyze Your Sales Data with Excel Pivot Tables (for Creative Small Business)

Rekha Krishnamurthi, Business Savvy Creative Designer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Videos (39m)
    • Introduction

    • Lesson 1: What is a Pivot Table?

    • Lesson 2: Deciding on the Information You Want

    • Lesson 3: Downloading Raw Data

    • Lesson 4: Manually Collecting Raw Data

    • Lesson 5: Create a Pivot Table in Excel for Mac

    • Lesson 6: Create a Pivot Table in Excel Excel for PC

    • Lesson 7: Class Project - Create Pivot Table Views & Analyze Results

    • Conclusion


About This Class

Coming soon!


In this class, you’ll learn how to analyze your sales data with Excel pivot tables.  

Though this class is targeted towards creative business owners who sell on Etsy, Amazon or other online marketplaces, it is open to anyone who wants to better understand data in general and learn how to use pivot tables to create different views that will help you answer key strategic questions about your business.

Big data is not limited to large enterprises or Fortune 500 companies.  As a small business owner, it is important to develop a practice and strategic approach to understanding your sales data.  

Here’s what you’ll learn:

  • Lesson 1:  What is a Pivot Table
  • Lesson 2:  Deciding What Information You Want
  • Lesson 3:  Downloading Raw Data
  • Lesson 4:  Manually Collecting Raw Data
  • Lesson 5:  Create a Pivot Table - Excel for Mac
  • Lesson 6:  Create a Pivot Table - Excel for PC
  • Lesson 7:  Class Project - Create Pivot Table  Views & Analyze Results
  • Conclusion


  • This is a beginner level class on pivot tables, however, to get the most benefit from this class, you should know basic Excel - such as how to enter data/text, format data, number formatting, insert/delete rows and columns, adjusting column widths, copy/paste, etc.

If you have any questions along the way, please drop your questions in the community discussion board.





Rekha Krishnamurthi

Business Savvy Creative Designer

I’m a business savvy creative designer who loves to teach, inspire & empower others to acquire new skills, gain knowledge and engage in creative activity.

I design and handcraft product that I sell on Etsy and Amazon Handmade.  My product line includes marbled trinket bowls, hand dyed kitchen & table linens, block print wall art, silk painting kits and DIY craft kits.  I am involved in every aspect of my business - from product design, to product launch, marketing onlin...

See full profile