I will build an excel employee attendance and training tracker dashboard


About this gig
Still checking staff attendance and training records by hand every month? I will build a one-screen Excel dashboard that shows attendance by department and who is due or overdue for training, and updates when you paste in new data.
WHAT YOU GET
Clear KPIs at the top: attendance rate, staff trained, training overdue
Clean charts that tell one story each
Filters for month, department, course or person
Works in Excel 2016 and later, Windows and Mac
No macros, so no security warnings
A short guide on how to update it yourself
GOOD FOR
Employee attendance by department and month
Training records: who is trained, what is due, what is overdue
Leave, overtime or headcount summaries
HOW IT WORKS
Step 1: Message me with your data (dummy data is fine) and what you need to see
Step 2: I confirm the KPIs and the right package
Step 3: I build, you review, I revise
Need it in Power BI instead? Ask me first.
Get to know Siti R.
Excel Tracker and Dashboard Builder
- FromMalaysia
- Member sinceNov 2026
Languages
Malay, English
My Portfolio
FAQ
How do I update the dashboard each month?
You paste or type new data into one data sheet, then click Refresh All if PivotTables are used. KPIs and charts update by themselves. A short guide is included.
Can you build it in Power BI instead?
Yes, I am Microsoft certified in Power BI. Please message me first so we can agree on the data source and scope, then I will send a custom offer.
My data is messy. Is that a problem?
No. The Business and Automated packages include data clean-up: fixing dates, removing duplicates and making categories consistent before the dashboard is built.

