Attendance Tracker with Comprehensive Analytics

I need an Excel sheet designed to track attendance for our workers. The sheet should be capable of handling and analyzing various data points, generating graphs, and reporting on duty hours.

Key Requirements:
- Track daily attendance and leave records
- Allow for manual entry of attendance data
- Provide monthly summaries and yearly trends in the analytics

Ideal Skills:
- Proficiency in Excel, particularly in creating complex spreadsheets
- Experience in data analytics and visualization
- Knowledge in generating comprehensive reports

This project requires someone with attention to detail, able to design a user-friendly spreadsheet that can handle our reporting needs.