Welcome to Lesson 4 of the Advanced Microsoft Excel Tutorial. In this lesson we will cover the second part of Advanced charting showing how to do Pivot Tables. I hope you enjoy the lesson.

Pivot Tables

Step 1: Start Pivot Table

Select the workbook where you want the pivot table to be located. Then click on the Data menu and then click PivotTable and PivotChart Report.

Step 2: Analyze Data

Select the data that you want to analyze. This data can come from a Excel list that has already been created or a database. You can also choose to use an external data source or multiple consolidation ranges. If you want to use an existing list or database, you will want to select a cell within that data range prior to launching the Wizard

Step 3: Select Report Type

Choose whether to create a PivotTable or a PivotChart report. A PivotTable report is an interactive table that can quickly summarize large amounts of data. From this table you can rotate on row and columns to view summaries of the data. A PivotChart report is similar to a PivotTable except the data is displayed graphically.

Step 4: Select Data

Select the data range that you want to generate the report for. If you chose to use an external data source you will be prompted to get the data that you want to run the report for.

Step 5: Finishing Up

Select where you want the report to be displayed. When you are done click Finish to have your report created.