Excel Pivot Table - Formatting

Pivot Table! A very powerful tool in Excel! In job interviews when I first started my job hunting some time ago, I have always been asked whether I know how to create pivot table. That means its one of the most frequently used and practical tool in the business world.

A Pivot Table report is an interactive table allows you to combine and compare large amount of data. It offers the flexibility to modify the rows and columns of a table to come out with relevant information.

For example, if you have multiple columns of data, a pivot table allows you to play around with columns of data by putting one column as row, and compare against the other columns of information.

Creating Pivot Table:

1. Data>PivotTable and PivotChart Report…>

2. Follow the three steps in wizard

3. Step 1 of wizard defaults to analyze data in excel and to create a PivotTable

4. Step 2 prompt user to highlight the source data

5. Step 3 prompt user to choose where will the created PivotTable report to be placed

6. When report is created, users will be prompted a window to drag and drop data field into PivotTable

The above is just a simple guide to pivot table, if you like to know more, you could refer to this link. It comes with some pictures, from "Daily Dose of Excel".

Keywords: Formatting