Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

Learn how to create an Excel pivot table. During this Microsoft Excel 2016 advanced training tutorial video, we will discuss the basics of pivot tables and the situations that you would use it. We will cover working with pivot tables in detail. We will create pivot tables step by step and look at the more options that are available.

We will then focus on filtering pivot tables and the use of slicers. We will demonstrate how to change pivot table styles, how to use the grouping and filter options, and how to insert slicers and timelines. We will also you show some pivot table options like refreshing data, switching the field list on/off, expand/collapse buttons, and field headers.

Get the sample data used during this tutorial here ►https://simonsezit.lpages.co/pivottables-free-download

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hzyKexLt4YW-AaIUPeiCen

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Video transcripts:

In this section, we’re going to look at creating Pivot Tables in a little more detail than we did the preceding section. And I’m going to create another Pivot Table from the same starting point but I’m going to take it step-by-step and look at more of the options that are available.

Now the first thing I’ve done is to convert the table with the source data in it back to being a range again. So it’s no longer a table. I already mentioned that it’s a good idea to use a table as the basis for a Pivot Table. So I am going to turn it back into a table again but I’m only going to use part of it and in doing that I’ll show you how easy it is to change the table later on and how that pretty much automatically changes the Pivot Table as well.

So on this occasion, I’ve still got the same source data. I’m going to go up to the Insert tab. I’m going to click on Table. Now the Create Table dialog identifies the range from A1 to D34,109. What I’m going to do is just use say the first 15,000 rows in the table. So I’m going to click to the right of 34,109, change it to 15,000. So I’ve only got a little under half of that data as a table. And I’m going to change its name to Sales Table.

Now let me select the table. So I’m going to go up to the top left-hand corner, get the diagonal black arrow, click, and click again to get the table and the header. And then I’m going up to the Insert tab and I’m going to click on Pivot Table. And that gives me the Create Pivot Table dialog. Now, of course, taking this approach we’re seeing all the option that you didn’t see before. But let’s start at the top of the Create Pivot Table dialog.

Well, Excel is offering me the table that I had selected which was Sales Table. That’s fine. Note the alternative there, Use an external data source. I might choose one of my connections and get data from one of my connections. You can, in fact, turn any appropriate transactional data into a Pivot Table and use that as the source of a Pivot Table. You can also choose to use this workbooks data model. I mentioned the data model in a much earlier section. And if you are, for instance, combining various data sources building a data model you may, in fact, use that data model as the source of a Pivot Table. That’s outside the scope of what we’re doing here. It’s a very important option if you are combining data from a number of sources.

The second set of option buttons there let you choose whether to put the Pivot Table on a new worksheet which is what I normally do or you can add the Pivot Table to an existing worksheet. Note also the checkbox at the bottom that determines whether you want to add this data to the data model. And again we’re not really dealing with the data model on this course. So I’m going to stick with data from the table and it’s going to go onto a new worksheet. Click OK.

Now what you can see here is the sort of bare bones of a Pivot Table. There isn’t actually a Pivot Table there at the moment. There’s a space for one but until I select at least one field I won’t have a Pivot Table. I’m going to rename the sheet. And one other thing to point out here is that this panel on the right if you click on the header you can actually move it around.

YouTube limits the number of words we can put in the description box. To get the complete transcription for free, click here ► https://simonsezit.lpages.co/pivottables-free-download