Create a Pivot Table in Excel

The “Pivot Table” is one of the most powerful features in Excel.

In particular, it is very useful to use it to present information in a report format.

Assuming you have an Excel data file about the sales in different regions, with the Pivot Table created, you can click the “drop down” lists and change the data that is being displayed based on Month, Sales person, Product or geographic location.

Create a Pivot Table
In the Excel worksheet, go to toolbar and click “data”, and then “pivot table and pivot chart report” to follow the instructions given. Essentially, you just need to select the whole data set and create the pivot table in the new worksheet. All the column headers from your dataset should appear in a control box on the right of the screen. You can drag-and-drop the field buttons on your table.

For step-by-step procedures on how to create a Pivot Table, you may refer to the URL link www.homeandlearn.co.uk/ME/mes9p5.html for details.

I bet you… it is easier than you might think.