Working with Pivot Tables in Excel 2013 – Part 1 – Learn Excel Training Tutorial

Get my free 3 hour Introduction to Excel 2013 course. Get 17 training videos to help you learn MS Excel 2013. Click here to get the free course:

In this video, get to know the basic principles of creating pivot table in Microsoft Excel 2013.

Get the full course on Excel 2013 course here:

Watch the Excel 2013 playlist:

Stay in touch:
The Simon Sez IT email newsletter:
YouTube Channel:

If you enjoyed the video, please give a “thumbs up” and subscribe to the channel 😉

Welcome back to our course on Excel 2013 Advanced. In this section we’re going to start to look at pivot tables. Now it’s a little bit tricky really when we start on pivot tables here because I’m sure that some of you will have used pivot tables before, at least in a basic form. On the other hand, understanding some of the basics of pivot tables if you haven’t used them before is absolutely essential even if what we’re going to do is go into some of the more advanced aspects of their use.

So what I’m going to do is to start with a relatively straightforward case study with some fairly straightforward data and develop a pivot table and a pivot chart based on this straightforward data before we move into some of the more advanced aspects and in particular some of the aspects that have been introduced in this and other recent versions of Excel.

There are a few features of Microsoft Excel that really are considered to be its greatest strengths and amongst these are pivot tables, pivot charts, and the associated tools and techniques. They’ve been in Excel for several versions now. By no means they are new and they’ve continually been improved particularly in recent versions, but the fundamental idea of pivot tables has been around for some time and has been one of its great strengths for some time.

The first thing to explain to you is not what a pivot table is. I’ll come back to that in a little while. I’m going to start by explaining situations in which you would use pivot tables because that will help to explain not only why you use them but what they are.
We use pivot tables for what we call transactional data. So that’s records of things that have happened normally in some kind of sequence. Now that doesn’t necessarily mean that there is some kind of dependency between these items, but it does mean that they are similar events or similar measurements that have a certain set of properties in common.

Now the case study we’re going to start with is a very straightforward one and it’s to do with sales in convenient stores. And in a number of convenient stores in the U.S.A. we’ve recorded individual sales over a long period of time. I’ve actually got a lot of data in the workbook that we’re using for this example, many thousands of transactions and each transaction is a row on this sheet.

So taking that row, for example, we’ve got a date for the transaction. We’ve got a branch. It’s the Denver, Colorado branch. We’ve got a value, $1. And the department in which the sale was made. It’s breads. Now if I go through all of this data and as I say there are many thousands of lines of data, you’ll see that I’m dealing with a few branches over a period of time, not a very long period of time. But there are hundreds of sales each day and they’re all categorized in exactly the same way.

So first of all, what we’re dealing with is rows in a worksheet or some worksheets which each represent some kind of transaction. It’s not necessarily a sale but just something that happens; some event, something that was measured.

Now one of the problems you always get with very large amounts of data is finding some meaningful ways of analyzing that data or presenting that data. So for example, given this straightforward convenient store sales data how might we want to analyze it? Supposing we wanted to show, for instance, how the sales in the stores that we’ve got varied over a period of time. Maybe we would plot the total sales for each store for each month in the time period where we’ve made the measurements or maybe for each week.

Sorry, we couldn’t fit the entire video transcription here since YouTube only allows 5000 characters.


How To Excel At Excel.Com says:

Thanks for the video and transcript good stuff

Sourav Shaw says:

Out of a 15 mins video , its already been 10 mins and still didnt learn anything yet . But anyways it was a good one

AlienC says:

Useful info only the last 5 min. For the first ten, too much useless talk. Is the three hour course the same ratio wise?

Satish Sutar says:

yes this is very usefull

May says:

Thank you for this tutorial.

Paul Liem says:

It is really great tutorial, thank you for sharing.

Aishwarya Sarda says:

9 n half minutes of sad bulls*it … skip to 9:33 guys

Anil Yadav says:

Worst presentation.

Scarce Meme Gaming says:

great! thanks

s sauce says:


user last says:

Can I request the database you are training in the video as a home exercise material? Thank you for the help.

Yallon Daka90 says:

Good Video. Explains nicely the “Pivot” in Pivot Tables

Ricky Land says:

This just took a long time to show me nothing. What the fuck.

Neal Jones says:

HAS VALUE, but too long winded.  Very repetitive, just get to it.

fazerville says:

Great Tutorial. This clip is from a training course at SimonSeziT so looks a little out of context here. The preamble is important as this video is the first in the Pivot Table section.

Mark Kolojejchick-Kotch says:

Great Tutorial!

Ryan Travers says:

Oh my god. A person could die of thirst before you share anything useful.

plan445B says:

Great tutorial, but it took way to long to get to the useful information…

Cecil D'Souza says:

9 minutes passed and nothing really demonstrated. Come on.

Eileen Lai says:

why does the screen keep rotating??? very distracting.

Lucia Kamizono says:

you speak too much not much practice!

Leon Hoang says:

too much talking, we aleady know what it is, we only want to know how to do it

Jay Smirh says:

7 minutes in, learned nothing yet.

rong raktam says:

you talk too much

Pious Hadebe says:

Thanks. for sharing everything i need to know regarding Pivot Tables. The first 9 minutes was worth it.

سامح مجيد says:

Great video and great info, Thank you

Apiet Nugroho says:


 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!