Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to calculate attrition in excel
Are you ready to master how to calculate attrition in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet.
· What is attrition?
Attrition refers to the voluntary and involuntary reduction of a company's workforce during a period of time. Attrition rate is also known as employee turnover, which can reflect the percentage of outgoing employees.
Attrition Rate = No. of employees left/Closing Balance
Closing balance: Opening balance+Employees joined-Employee left.
Closing Balance means the number of employees at the end of each month.
Similarly, Opening Balance means the number of employees at the start of a month.
· Example to calculate attrition in WPS Presentation
Without further ado, let’s look at today's example.
Suppose we want to get the attrition rate of January, February and March in company A.
1. Click cell B7 where we want to calculate January’s attrition rate. Enter =B5/B6.
2. Hover over cell B7 and pull it to the right to cell D7. By doing so, we have copied the formulas in cell B7 to other cells, and the formula will change according to the position of the referenced cell.
The system will automatically help us calculate C5/C6, D5/D6 in cells C7 and D7 respectively.
3. To make the value in cell range B7:D7 displayed in percentage, select B7:D7, then go to the Home tab, and click Percent Style to achieve this.
In today's free WPS Office tutorial, we learned a simple yet useful way to calculate attrition rate in excel. WPS Spreadsheet, similar to Microsoft Excel,is avaliable for Windows, PC, Mac, Linux, Android, and iOS devices.
Did you get it?
· To explore more about WPS Office:
Click here to know more about relative reference, absolute reference, and mixed reference.
WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich in functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.
Also Read:
- 1. 10 Excel Sales Templates to Help Your Business: How to Sell Excel Templates Online
- 2. Malaysian excel payslip template: Find the user story template for Excel this year
- 3. How to make excel cells expand to fit text automatically in excel
- 4. Best 10 excel dashboard examples in free excel 2022
- 5. How to Use Excel Formula IF Cell Contains Text in Excel
- 6. How to make an excel file shared with multiple users in excel 2016