Skip to content

An Excel-based HR dashboard designed to monitor employee absences and leave, featuring dynamic reports and visualizations.

Notifications You must be signed in to change notification settings

Daniele1388/Excel-HR-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

💾 HR Absence & Leave Tracker (Excel Edition)

Welcome to this small but powerful tool for managing employee absences!

This Excel file is designed to provide a clear and immediate overview of vacation, leave, and absence data across your organization. It’s ideal for HR professionals who aren’t afraid to use a bit of pivot magic and stacked charts to make sense of what’s going on.


📂 What's included

  • Employees: full employee registry with department, job title, FTE, and key dates.
  • Absence and leave records: all events logged day by day.
  • Reports: aggregated summaries by type of absence.
  • Dashboard: a visual area to keep everything under control at a glance.
  • Averages, Balances, Company Closures

🎯 What it's for

  • 📊 Track sick leave, maternity, training, bereavement, blood donation, and more.
  • 🔍 Understand who’s absent, why, and for how long.
  • 🧠 Gather valuable insights to support smarter HR decisions.

🛠️ Tools used

  • Microsoft Excel (tables, formulas, dynamic charts)
  • ✨ No macros, just pivot power!

⚠️ Fake data only

All names and information are either fictional or publicly recognizable. No real employees were harmed in the making of this file.

About

An Excel-based HR dashboard designed to monitor employee absences and leave, featuring dynamic reports and visualizations.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published