Absenteeism Report
Templates

Absenteeism Report in Excel

Absenteeism is very useful for any process. In this absenteeism report template there are 6 worksheets available

Index:

Index worksheet is used to navigate the other worksheet-like summary, month wise, date wise and supervisor wise.

Index Worksheet
Index Worksheet

Summary:

In this worksheet a chart of month on month comparison for planned% Vs Unplanned% is available. Overall NCNS (No call No show) count , Planned % and Unplanned% have been displayed in the circles above.

For filtering the data Month, Date, Supervisor Name, Quarter, and Week slicers have been displayed.

Summary sheet tab
Summary sheet tab

Month Wise:

In this worksheet a month wise pivot table has been displayed for P (Present count), NCNS (No Call No Show) count, A (Absent Count), L (Leave count), Scheduled count, Unplanned% and Planned %.

Traffic lights conditional formatting has been used for unplanned% and planned %. Target for unplanned is 12% and for planned is 15%.

Month wise sheet tab
Month wise sheet tab

Week Wise:

 

This is the same worksheet as month wise, only difference is in place of month here Week has been taken.

Week wise sheet tab
Week wise sheet tab

Supervisor Wise:

This is the same worksheet as month wise, only difference is in place of month here Supervisor Name has been taken.

Supervisor wise sheet tab
Supervisor wise sheet tab

Raw Data:

In this worksheet raw data of this report is available. Fields with the gray header to entered manually and for the green header it is formulated.

 

Raw Data
Raw Data

Click to download the Absenteeism Report

Watch the step by step tutorial for how to create Absenteeism report in Excel.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *