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, reconciling bills, calculating bonuses and PTO, or analyzing turnover 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, bringing in 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.