MS Excel Automation for attendance management using Macros
- or -
Post a project like this$50
- Posted:
- Proposals: 16
- Remote
- #3415251
- Expired
Full Stack Developer with Expertise in Web Applications, Desktop Application, Database Management
New Delhi
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Planning and cost engineer (Primavera P6) /Autodesk render/Quantity takeoff/Excel Macros
Cairo
59221336492721264463206294638734915595970562314856829826138309614090763045566315394
Description
Experience Level: Entry
This job involves managing a master training excel file for scheduling training, monitoring attendance and related reporting.
Refer to the excel sheet - 'For attendance automation'
1. Worksheet - 0.Invitees List - [Attached]
• This is to be filled up manually in this worksheet after sending the meeting invite. This sheet is not relevant for automation
2. Worksheet - 1.Invitees_Summary
• This is to be filled up manually by Training Supervisor after sending the meeting invite. This sheet is also not relevant for automation
3. Worksheet - 2.Attendees_Details
• Admin to upload the Meeting Attendees Report File (in .CSV) in a specific location and rename file with date suffix like '_Sep-30'.
• Refer to sample of Meeting Attendees Report File (in .CSV) - Attached
• Fill in details from file 'Attendance Report' (IN .CSV) and compare with the 'Invitees_Summary' worksheet.
○ Fill details of Col A to Col J
○ Fill up Col K [Invited?] and Col L [Attended?] of this worksheet.
○ For Col K [Invited?], employees to be marked 'Invited', 'Not Invited'
○ Col L [Attended?], employees to be marked 'Attended', 'Not Attended'
○ Update role to 'Absentee' if status of Col L and Col K is 'Invited' and 'Not Attended' respectively
○ Update role to 'Additional' if status of Col L and Col K is 'Not Invited' and 'Attended' respectively
4. Worksheet - 3.Attendees_Summary
• To be filled as per instruction in this worksheet
5. Worksheet - 4.Training Summary
• To be filled as per instruction in this worksheet
6. Dashboard - To display min of 5 graphs with related data
7. This workbook shall be archived every quarter with only keeping summary data in worksheet 3.Attendees_Summary and 4.Training Summary
8. Version to be used : Microsoft Office professional 2019 OR Microsoft Office 365
Refer to the excel sheet - 'For attendance automation'
1. Worksheet - 0.Invitees List - [Attached]
• This is to be filled up manually in this worksheet after sending the meeting invite. This sheet is not relevant for automation
2. Worksheet - 1.Invitees_Summary
• This is to be filled up manually by Training Supervisor after sending the meeting invite. This sheet is also not relevant for automation
3. Worksheet - 2.Attendees_Details
• Admin to upload the Meeting Attendees Report File (in .CSV) in a specific location and rename file with date suffix like '_Sep-30'.
• Refer to sample of Meeting Attendees Report File (in .CSV) - Attached
• Fill in details from file 'Attendance Report' (IN .CSV) and compare with the 'Invitees_Summary' worksheet.
○ Fill details of Col A to Col J
○ Fill up Col K [Invited?] and Col L [Attended?] of this worksheet.
○ For Col K [Invited?], employees to be marked 'Invited', 'Not Invited'
○ Col L [Attended?], employees to be marked 'Attended', 'Not Attended'
○ Update role to 'Absentee' if status of Col L and Col K is 'Invited' and 'Not Attended' respectively
○ Update role to 'Additional' if status of Col L and Col K is 'Not Invited' and 'Attended' respectively
4. Worksheet - 3.Attendees_Summary
• To be filled as per instruction in this worksheet
5. Worksheet - 4.Training Summary
• To be filled as per instruction in this worksheet
6. Dashboard - To display min of 5 graphs with related data
7. This workbook shall be archived every quarter with only keeping summary data in worksheet 3.Attendees_Summary and 4.Training Summary
8. Version to be used : Microsoft Office professional 2019 OR Microsoft Office 365
S P.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
12 Nov 2021
Saudi Arabia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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