When setting up a pivot table, it's always best to start with the end goal in mind.

Is there a specific question you are trying to answer?

Are you just wanting to slice and dice the data to explore any relationships?

Are you wanting to create a summary report for a presentation?

If you have the end goal in mind, it will save you time and

guide your strategy on how you set up your pivot table.

All right, let's go back to our example spreadsheet to start building our

pivot table.

Here, we have our example spreadsheet, and

we've confirmed the data are in their appropriate format.

And again, if you would like to follow along,

you can find the link to this spreadsheet in the project files.

After we have confirmed the appropriate format, the next thing we need

to do is create a table, by clicking somewhere in the data range.

And then going to the Insert tab and selecting Table.

If you've already clicked somewhere inside the range,

then the range should set itself for the table.

So just make sure that My Table's headers are selected, then hit OK.

Creating a table like this is not absolutely necessary, but

it is a best practice.

And if you later add a row to your data, do refresh, which I'll show you later,

will add the new row to your pivot table automatically.

That way, you don't have to respecify your range each time a row or

a column gets added.

Now you can go up under Table Name and name your table.

Let's name this one store sales.

The name has to start with a letter or underscore and it can't include any spaces

or be the same as an existing name already in the workbook.

Now on the Insert tab, select Pivot Table, and for the table range,

it automatically populates with our table name, StoreSales.

If for some reason it doesn't, you can just type it in here.

Now, choose where you want the pivot table to be placed,

in your worksheet or existing worksheet.

If you choose existing worksheet, you'll need to choose which worksheet or

tab you want to place the pivot table in.

I usually choose new worksheet as this keeps the work book a little cleaner in

my opinion.

So that's what we will do here.

Now you can see, the blank pivot table on our new worksheet.

And if you go to the right,

you'll notice there are four areas in which you can drag fields.

The first is Filters, which accesses dropdown so

you can filter to wherever you want including in the pivot table below.

The second is Columns, so I'll add column headers here.

The next one is Rows, and we'll add row headers here, subcategories will nest.

And the fourth one is sum Values, we'll add any fields that should be summed here.

In the next video, we'll start adding our fields and see it all come together.