Practice First: Employee Turnover Analysis Excel Dashboard Dataset

The main purpose of this blog is to give you the dataset for hands-on practice with the Employee Turnover Analysis Excel Dashboard. Use this practice Spreadsheet Template to follow each step and build the same interactive HR analytics experience.

How this fits your Dashboard Templates workflow

You can apply the same structure across Dashboard Templates, adapt it into a Google sheets dashboard or a Power BI Dashboard, and present results as a PowerPoint Dashboard using your existing Power Point templates.


Dashboard Overview

The top section highlights total headcount (2018–2024: 100 employees) with slicers to filter departments such as Customer Support, Finance, HR, Marketing, and Sales. Key cards show Active employees, Exited employees, and Turnover rate (35%).

Department & Reasons Analysis

Read the bar chart for turnover by department, then review a reasons pie chart (Retirement, Health Issues, Termination, Personal Reasons, Better Opportunities, Relocation) to pinpoint where and why exits occur.

Trends & Tenure

Use quarterly trend lines (2020–2024) comparing new hires vs. exits, a tenure column chart (average 1.7 years), and a stacked view for active vs. exited by gender to identify patterns.


Customize & Calculate

Edit the data table

All fields are editable (Employee ID, Department, Join/Exit Dates, Exit Reason, Status, Gender, Age). The file starts with 100 records and scales to large datasets.

Headcount & Turnover steps

  1. Create a PivotTable from the data; place Employee ID in Values and change to Count.
  2. Link the result to a helper cell (e.g., B3), then to a dashboard text box (=B3).
  3. Build two PivotTables for counts of active and exited; compute Turnover Rate = Exited / Total Headcount.

Department slicer with icons

  1. Insert a Slicer for the Department field and arrange it horizontally.
  2. Style it, then add circular icons or photos beside each department for a modern, interactive look.

Watch the Tutorial

Watch the full Employee Turnover Analysis Excel Dashboard tutorial on our Other Levels YouTube Channel

 


Download the Dataset

Click below to get the practice data and follow the steps above to recreate the complete Excel Dashboard experience.

Download The Dataset

Latest Stories

View all

Use Microsoft Excel on Mobile Devices Efficiently

Take your spreadsheets on the go! With Excel Mobile, manage data, edit reports, collaborate in real time, and update dashboards, right from your phone or tablet. Perfect for remote work, travel productivity, and cloud-powered business tasks.

Read more

How to Add Comments and Notes in Microsoft Excel

Enhance your spreadsheet workflow using Excel's Comments and Notes, perfect for team collaboration, remote reviews, feedback loops, and self-documenting reports. Streamline communication and reduce errors with built-in annotation tools.

Read more

Create QR Codes in Microsoft Excel Using Web Add-ins

Learn how to generate QR codes directly in Excel using Web Add-ins for interactive dashboards, inventory logs, event invites, and mobile-friendly invoices. No design software needed, just dynamic, scannable power built into your spreadsheet.

Read more