Attendance & OT Report - Excel Project
This project makes organized and dynamic attendance report from unorganized data sources from HRIS software.
This report has been meticulously crafted with the incorporation of powerful data analysis tools, such as Power Query, along with fundamental VBA techniques. It serves as an indispensable resource for organizations equipped with HRIS software, enabling precise and efficient control of employee attendance and management.
View project details video:
Project Screenshots:
 |
| Main Report |
 |
| Mismatch Report |
 |
| Manual Input |
 |
| Manual Status |
 |
| Roster List |
 |
| Source Selection |
 |
| Power Query Window |
 |
| Source File 1 |
 |
| Source File 2 |