Creating an Excel Spreadsheet for Volunteers' Leave Balances
Develop an Excel sheet for UN Volunteers' leave balances.
This opening expired 2 years ago.
Do not try to apply for this job.
Overview
Develop an Excel sheet for UN Volunteers' leave balances.
You have:
- Advanced knowledge in Microsoft Excel is required for creating the spreadsheet.
- Basic knowledge of Human Resources would be beneficial for understanding leave policies.
Contract
This is a UNV contract. More about UNV contracts.
While the number of serving UN Volunteers is growing, UNV aims to create an Excel sheet for monitoring and computing leave balances specifically for serving volunteers at UNICEF MENARO.
To achieve this, we are seeking support of an online volunteer to develop the Excel sheet, incorporating all necessary formulas.
We are looking for one Online Volunteer who under the guidance of Partnership Coordinator support with creating an excel sheet to calculate the leave balances for UN Volunteers at UNICEF MENARO. The Online Volunteer will be responsible for:
- Data Gathering and Entry: Collect all relevant information about the staff, including their names, employee IDs, leave types (e.g., vacation, sick leave), the number of days they are entitled to, the days they've taken, and any additional accrual or adjustment information.
-Designing the Excel Sheet: Create a well-organized and user-friendly Excel sheet. This might involve setting up different columns for employee details, leave types, entitlements, taken leaves, remaining balances, and any calculations needed for accruals or adjustments.
-Formulas and Calculations: Implement formulas to calculate leave balances accurately. This could involve using functions like SUM, IF statements for conditional calculations, and possibly more complex formulas to account for accrual rates or special cases.
-Testing and Validation: Test the Excel sheet thoroughly to ensure the calculations are accurate and error-free. Validate the formulas and ensure they adjust correctly when new leave data is entered or when staff use their leaves.
The Online Volunteer/s will have the opportunity to build connections with the HR unit at UNICEF MENARO
Candidates should have advanced Microsoft Excel professional knowledge Basic knowledge of the Human Resources would be an asset
Potential interview questions
| Can you describe a challenging Excel project you worked on and how you approached it? | The interviewer is assessing your problem-solving skills and technical proficiency in Excel. | Highlight a specific project, the challenge you faced, and the steps you took to overcome it. |
| How do you ensure the accuracy of formulas when working in Excel? | The interviewer wants to know your methods for validating data and ensuring accuracy in your calculations. | Pro members can see the explanation. |
Added 2 years ago
-
Updated 1 year ago
-
Source:
unv.org
Recent jobs at UNV Regional Office for Arab States
Deadline passed
Deadline passed
Deadline passed
Deadline passed
