MS Excel for HR

Register Now →

Course Details

Is your HR Department wasting time manipulating canned reports from HCM and payroll systems? Do you need help accessing and analyzing data quickly? Are data errors causing you concerns? Whether auditing, calculating bonuses and PTO, or analyzing departmental data, Excel offers tools to help. Based on guidance from HR experts and our interaction with supporting members, we identified the most common and helpful Excel tips that can benefit new and experienced HR individuals.  

The course explores using lookups to pull information out of multiple workbooks, formatting delimited information from other sources, filtering information, using date calculations to figure out things like tenure and turnover, visually representing data to make it simple to review, and many tips and tricks that can help most every Excel user increase their productivity and decrease errors.

Prerequisites: This course requires that you are familiar with Excel. You should have successfully completed Excel I and II or used the software for over six months

Note: This course will be taught using the windows operating system environment

Ready to Advance Your Career?

Join professionals across the Carolinas who trust Catapult for professional development.

Register Now →