Analyze Your Sales Data with Excel Pivot Tables (for Creative Small Business) | Rekha Krishnamurthi | Skillshare

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

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

2:24

3:14

2:11

7:25

3:43

9:09

9:22

1:01
• ### 9. Conclusion

0:58
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

103

Students

--

Projects

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 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

Prerequisite:

• 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

Textile Artist & Creative Entrepreneur

Teacher

I’m a fabric artist, print and pattern designer and creative entrepreneur 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 my website, DivineNY.com, Etsy and Amazon Handmade.  My product line includes marbled ring dish sets, hand dyed kitchen & table linens, block print wall art, silk painting kits and DIY craft kits.  I'm involved in every aspect of my business - from product design, to product packaging, digital marketing, shipping strategy, writing SEO friendly product titles/descriptions/tags and much more.   There is a lot to do when running a small business and at times it can be overwhelming! But this is what has pushed me ... See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

# Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshare’s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects