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)

#### Rekha Krishnamurthi, Business Savvy Creative Designer

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

2:24
• Lesson 1: What is a Pivot Table?

3:14
• Lesson 2: Deciding on the Information You Want

2:11

7:25
• Lesson 4: Manually Collecting Raw Data

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

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

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

1:01
• Conclusion

0:58

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

10

Students

--

Projects

• --
• Beginner
• Intermediate
• 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.