Pivot Table - Xls Download - CiteHR
M.Sayeed
Procurements
Dnyan2001
Ms Excel
Meghana N
Admin Executive
+1 Other

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Dear All,
Could anybody help out to know what is meant by Pivot table and how it has to be created. I know that this table helps to fetch employee's data, but if you have any samples of the same, please post it or send it to
Community Prime Sponsors
FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS.
Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
Good Day,
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.
thanks,

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample Pivot Table -Timesheet.xls (1.08 MB, 3864 views)

Hi Sayeed, Thanks for your post... i have one more clarification, is this table is used for entering employee data’s like DOB, GENDER, Designation etc??
Dear all, Attached pl. find a pdf file containing good information on pivot tables. Regds. Ranjit J. Pandya

Attached Files
Membership is required for download. Create An Account First
File Type: pdf Excel Pivot Tables Recipe Book - A Problem-Solution Approach (2006) - allbooksfree.tk.pdf (2.84 MB, 1520 views)

Hi, Please check attached excel Pivot file which is more helpful to you

Attached Files
Membership is required for download. Create An Account First
File Type: xls Pivot Mult.xls (48.0 KB, 1321 views)

Dear Sir I have uploaded a bit editer version for Pivot Multi by DNYAN2001. I hope it will help. Happy Learning! Regards

Attached Files
Membership is required for download. Create An Account First
File Type: xls Pivot Mult (Edited).xls (136.5 KB, 238 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™