How To Calculate Employee Turnover Rate - Employee Turnover Report Template

Learn to track, calculate, and report Employee Turnover accurately and consistently each year. See what to include in your turnover rate formula for number of separations and for average number of employees. We review employee types and how to handle employees on a leave of absence. The Excel Turnover Workbook used in this video is available to purchase here:
creatoriq.cc/3CZkoug
This convenient workbook contains all the information you need to know to accurately calculate Employee Turnover at your organization. Includes an Instructions tab, a Turnover Calculation Tab that you can enter data into, a Turnover Report tab that populates as you go, and an Example Turnover Report so you can see ways to visually report on monthly employee headcount by department, termination type, and capture departmental transfers. Sample charts are also included.
This workbook eliminates assumptions you may have and clarifies the right way to calculate employee turnover rates.
#shopwithyoutube #etsycreatorco
📺 Watch Next - • Calculate Employee Yea... - Calculate Employee's Years of Service
__________
TIMESTAMPS ⏰
00:00 How To Calculate Employee Turnover Rate
00:47 Turnover Rate Formula Overview
03:06 Calculate Turnover Excel Tabs
__________
CONNECT WITH ME 📎
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
GEAR
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: techsmith.z6rjha.net/NZG5b
📗 Green Screen: amzn.to/2DnHsY2
📸 Camera: amzn.to/39KvpQA
🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: www.jotform.com/pricing/?utm_...
📑 Wondershare PDFelement (PDF Editor): bit.ly/31QEkA8
💻 PresenterMedia: shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
KEYWORDS: #msexcel, #turnover, #hr, how to calculate employee turnover rate, employee turnover calculation, employee turnover report template, employee turnover spreadsheet, turnover analysis report example, year-to-date turnover, annual turnover, quarterly turnover, employee headcount, employee headcount analysis, headcount report, human resources tutorial, excel tutorial, hr video, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤ Jotform Tutorials: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

[@InsightfulJourney123]

Amazing and simply explained! Thank you tons!! 🙏

[@SharonSmith]

So glad you found it helpful, Zarni! Thanks for watching and for subscribing to my channel!

[@eleanorronis38]

Hi Sharon, I'm new. Can this report work for various branches?

[@jennyfrancois2102]

How can we use this workbook to get the involuntary vs voluntary turnover rates?

[@johnyealland4772]

Really helpful information Sharon, though you might want to fix the typo in the title box - calculate

[@SharonSmith]

Thanks, John! Yes, I caught that today so anyone who uses the template will have it correct. Thanks for watching!