Creating a PivotTable

PivotTables are powerful and flexible Excel analysis tools.…A PivotTable lets you arrange, sort, and filter a data set on the fly, so you can…analyze it from several different perspectives with a minimum of effort.…In this movie, I'll show you how to create a PivotTable from a data list that's…stored in the same workbook.…To begin you need to have a data list such as the Excel table I have here.…We have five columns Year, Quarter, Month, Company and Revenue and each of the rows…inside of this Excel table contains a value for each one of those columns.…

To create the PivotTable, click the Insert tab on the ribbon and then click…the PivotTable button.…When you do, Excel displays the Create PivotTable dialog box.…First you should verify that Excel has identified your data correctly and in…this case it's Table1 and you can see the marquee outline around that selection…inside of the workbook.…So we know everything is right, and then you need to decide where you want the…PivotTable report to be placed.…