HR Monthly Report & Headcount Summary (Advanced Excel Analytics)

Project Summary

A high-impact HR Analytics Dashboard built in Excel to monitor real-time workforce stability, department-wise headcount distribution, and monthly turnover trends. This project automates the transition from raw employee data to executive-level visual summaries using dynamic Pivot Tables and automated data cleansing logic. It provides leadership with a clear view of hiring velocity, gender diversity ratios, and attrition risks, enabling faster, data-driven HR decision-making.