<img src="https://static.skillshare.com/uploads/parentClasses/094cc626b519420fe0c3521b6d0bef13/67f0a29e" class="zoomable rounded-image-wrapper" alt="67f0a29e">
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:
<ul><li>Lesson 1:  What is a Pivot Table</li>
<li>Lesson 2:  Deciding What Information You Want</li>
<li>Lesson 3:  Downloading Raw Data</li>
<li>Lesson 4:  Manually Collecting Raw Data</li>
<li>Lesson 5:  Create a Pivot Table - Excel for Mac</li>
<li>Lesson 6:  Create a Pivot Table - Excel for PC</li>
<li>Lesson 7:  Class Project - Create Pivot Table  Views &amp; Analyze Results</li>
<li>Conclusion</li>
</ul>Prerequisite:
<ul><li>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.</li>
</ul>If you have any questions along the way, please drop your questions in the community discussion board.

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

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

Conclusion

Pivot_Table_Instructions_Download.pdf

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

Rekha Krishnamurthi gave you 1 free month of Skillshare

Get 1 free month of Skillshare

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

Creative Learning Made Easy

Company

Work With Us

Teach with Us

Shop

Mobile

English

English