Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

In this video, discover new features available in Microsoft Excel 2013 to create a and present a pivot table.

Get the full course on Excel 2013 course here: http://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2013-advanced-training-tutorials/

Watch the Excel 2013 playlist: https://www.youtube.comhttp://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

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

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

Hello again and welcome back to our course on Excel 2013 Advanced. In the previous section we created our first pivot table and in this section we’re going to expand on the options when you’re creating pivot tables and we’ll be looking at some of the new features in Excel 2013 that can let you get to really good pivot tables very quickly.

So in the previous section we very quickly created a pivot table. Generally speaking, when you’re creating pivot tables it’s usually best to create a pivot table from a table rather than a range of data. The main reason for this is that if you subsequently update the data and as the data you’re dealing with is probably transactional it’s entirely possible that you will want to add to that data later on. You’re actually better off defining a table containing the current data, building the pivot table on the basis of that, and then when you do subsequently add data the amount of work, you need to do to update the pivot table is greatly reduced. So let’s start by creating a table from the data that we’ve got here.

So let me just click within the table of data and then insert table and as you should know by now we come up with the Create Table dialog. Excel 2013 suggests the range for the table. There are in fact 34,109 rows of data in this data set and as you can tell there it’s detected that the table has headers. What I’m going to do is I’m not going to include all 34,109 rows of data. What I’m going to do is just include the first 20,000 rows and then what we’re going to do is to extend the table later on just to show how easy it is to update the pivot table when we get new, additional data. So let’s go on that basis now. Click on OK. The table is selected and I’m going to call that table Store Sales. So there we are.

Now I’m inside my table of data and I’m going to go to the Insert tab and I’m going to insert a pivot table pretty much from scratch. So click on insert pivot table and what I get is a Create Pivot Table dialog. Now first of all, I’m required to select a table or range. If I’ve got an existing table, which of course I have, Store Sales, that’s the one that it defaults to. I’ve already got the cursor inside there. That’s why Store Sales comes up. If I wanted to select a different range, of course I could. And as you can see from the Option buttons there, there is an alternative option which is Use an external data source and an external data source could include a connection. We setup connections earlier in the course and of course you can create a pivot table from one of those connections you’ve setup earlier on. For example, it’s very straightforward to create a pivot table using a connection to an Access data source. For the moment, let’s stick with this Store Sales table.

Then I have options of either put it on a new worksheet or use an existing worksheet. Now I’m going to put this on a new worksheet. Sometimes there are advantages in putting pivot tables, charts, etc on the same worksheet but once you’ve got the pivot table itself, I find that having the raw data right in front of you can be a little bit distracting and you actually get more space to work with if you put it on a new worksheet anyway. So I’m going to stick with the new worksheet option, click on OK, and we have basically the bare bones of a pivot table.

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