Looking for an experienced Excel expert to help establish pivot tables and formulas to calculate payroll totals. The Pivot Tables and sheets must record the employee name, regular hours worked, split shifts, overtime, double time, holiday, and sick leave. The total columns must display in hours earned. The Pivot Tables must note the hours worked per day to include split shifts if any, per week, and per location. The Pivot Tables must give grand totals for all columns in each sheet. A sheet must also be created to display the grand totals each week, per site, and to include employee work information. Other pages needed to display in Pivot Tables the employees' grand totals to include hours worked per week and earned reimbursements. The reimbursement columns will be discussed at the time of hire.
Please forward your resume by email by responding to this post. Make sure to include examples of your work.