Export Teachers Pay Teachers Sales Data Into a Pivot Table

I like data.  There I admit it.  I’m a nerd and can accept that 🙂

There are a couple of shortcomings when looking at data as a Teachers pay Teachers seller, but they do allow you to export your data to Excel and we can do some damage there.

This video is going to teach you how to export your sales data from TPT so that you can look analyze it a little more carefully.  I’m going to show you how to export an exact date range of sales data and then create a pivot table to that shows you exactly how many of each product you sold in that given time period.  It’s pretty awesome.

In the video I’m using Excel 2010, but most versions of Excel have pivot tables and the process should be very similar.

Spring break is over this week and the posts will inevitably slow down.  I’m hoping to post a minimum of twice a week going forward. I hope that you have enjoyed what I’ve put up so far. Have a great week at school (testing season..bleh!) and an even better week on TPT.

2 Responses

  1. Christina March 24, 2014 / 2:08 am

    Love all your awesome posts Chris! Off to check out my data!

  2. Mom2punkerdoo March 25, 2014 / 2:01 pm

    Really enjoying your new blog! Off to make some pivot tables….not something I’ve ever said before. 🙂

Comments are closed.