Formulate data in a spreadsheet to calculate month-by-month figures, by department
- or -
Post a project like this2745
$
- Posted:
- Proposals: 11
- Remote
- #1292332
- Completed
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
I am a computer science student having 2 years of work experience in data entry,data conversion etc
Hyderabad
39775920827027026935147096250599285810253271041947122805013295371379003
Description
Experience Level: Entry
Estimated project duration: 1 day or less
We have 3 years worth of payroll data in an Excel spreadsheet spreadsheet that needs to be formatted to calculate a month-by month breakdown by department.
The existing data is clean and currently split neatly year-by-year over multiple tabs.
We need the spreadsheet formatted so it can be used as a template moving forward. Historic data is likely to change. We need to spreadsheet to automatically caudate these changes.
This will require somebody with a solid knowledge of Excel formuals. You'll need no prior experience of running a payroll as all the figures are provided.
The most current year has been already formatted which will give you guidance of how the rest of the Doc could follow although methods used to enhance the existing format will result in a higher remuneration
We anticipate this taking between 2 - 4 hours dependant on proposals. Please get in touch for a chat.
The existing data is clean and currently split neatly year-by-year over multiple tabs.
We need the spreadsheet formatted so it can be used as a template moving forward. Historic data is likely to change. We need to spreadsheet to automatically caudate these changes.
This will require somebody with a solid knowledge of Excel formuals. You'll need no prior experience of running a payroll as all the figures are provided.
The most current year has been already formatted which will give you guidance of how the rest of the Doc could follow although methods used to enhance the existing format will result in a higher remuneration
We anticipate this taking between 2 - 4 hours dependant on proposals. Please get in touch for a chat.
finput Ltd
100% (7)Projects Completed
8
Freelancers worked with
6
Projects awarded
17%
Last project
26 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Luke,
Could you provide me with sample data in a spreadsheet showing how the data is currently stored & how it has been stored in the past.
How many departments does the company have?
Did you have any other expectations for the new spreadsheet?
Regards
Tony H
153910
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies