I require an expert user of excel to create an excel spreadsheet that tracks " study leave" taken by staff members.
I have supplied a partially working template of which I need altered.
What needs to be done.
I would like names placed under first and last name to populate the 1st, 2nd, 3,rd, 4th quarter tabs.
I would like Columns "Study Leave Taken" to add to the total number of " Conference Leave Taken" and Subtract from the number of "Allocated no. of study days column" and calculate "study days remaining"
Under the EFT column I would like it to adjust the of allocated study days.
EFT = 1*5 =5 Days
.8*5 =4 Days
.6*5 =3 Days
.4*5 =2 Days
Under the Study Days remaining
I would like the colours to change to what the remaining days that staff member has remaining.
More details once project is awarded
You must be able to work immediately as this project is urgent
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.
7 freelancers are bidding on average $70 for this job
Hi, I am a financial analyst and work on Excel extensively. Relevant Skills and Experience Financial models on Excel Stay tuned, I'm is still working on this proposal.