PIVOT TABLE TIPS WITH EMPLOYEE BENEFIT DATA (EXCEL PIVOT TABLE TUTORIAL FOR HR) // Learn to use pivot tables to: 1) create a self-billing statement for your benefit plans; and 2) analyze benefit and dependent enrollment data in preparation for your annual renewal. See trends and statistics from your benefit enrollment reports so you can report on metrics, provide current demographic data to your broker, and even help you make decisions based on knowing your counts and percentages of enrollment in different tiers, plans, etc.
__________
RELATED VIDEO:
✴ Checkout my other video on how to modify Pivot Tables: https://youtu.be/Ec8f3FgrNtE. Be sure to leave a comment on this video if you have a specific question about Pivot Tables that I can help with!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
RESOURCES & GEAR
✴ Get Free Demo of Top Employee Benefits Software. Click below:
https://accomplishep.com/benefits-administration-software
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ Live Stream Tool: https://amzn.to/2VFJyID
✦ PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
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!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. 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 https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload 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.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
KEYWORDS: #ExcelPivotTables, #MSExcel, pivot table tips and tricks, pivot tables for HR, analyze benefit data using pivot tables, create a self-billing statement, analyze benefit enrollment data, Sharon Smith HR
__________
PLAYLISTS:
➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR
