Excel Tips No 31 : Pivot Table, Create Table Resume

This free microsoft excel tips no 31 is telling how to create table resume. When we get raw data in a table form, sometimes we does't get a meaning of the table directly. It's need to be resummed to help "reading" the data meaning. To create table resumme, excel provide pivot table function. Pivot table is one of the most powerful tools in excel.

For example, we want to know the group of employee base on date of join.



Finding one by one data will consume a lot of time, and it maybe make frustration if we say about 100.000 raws of data or more.
Here the simple step to do it.

1. Click Insert Menu (Ms Office 2007)
2. Click Pivot Table
3. Pivot table window will be appear



4. In Table/range field, Click red arrow and block the table area, or you can click cell in the left - up corner of the table
5. Choose pivot table will be placed, you can select new sheet, or cell in the existiing worksheet



6. Click column will be resummed.
7. Click OK

Now, you have finished in creating table resume.