Posts tagged "Pivot Table"

Pivot Table

Please find attach files which will help you about Pivot Table from A to Z.

Click Here To Download Pivot Mult

Click Here To Download Excel Pivot Tables Recipe Book

Be the first to comment - What do you think?
Posted by Hrformats - September 1, 2011 at 10:49 AM

Categories: HR Policies   Tags:

Pivot Table

Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example – if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table)

Steps –

1, Select new sheet or existing,
2, Go to Insert Option
3, Select Pivot Table
4, Then the dialog box open with some formula’s type just click on ok, then one pop open with our sheet field names, then you need to slect exact with column u need to sort out the date.

5, Click on check box for needed column, then ok..

Attached is the sample excel sheet for same.

Click Here To Download Sample Pivot Table -Timesheet

Be the first to comment - What do you think?
Posted by Hrformats - April 28, 2011 at 9:56 AM

Categories: HR   Tags: