This course will cover techniques that address the four major phases of working with human resources and compensation information.
-
Data Clean-up/Scrubbing
-
Augmentation (Taking what you get and making it into what you need)
-
Analysis
-
Reporting
We begin with the tools you have at your fingertips to “break apart” combined data fields to enable proper analysis. And, since your data arrives in various formats, we’ll look at various ways to attack the problem, no matter how messy it is.Then, we look at formulas and functions which can interpret the data you get and turn it into useful information. We’ll go from the basics of IF and VLOOKUP to the various ways to round and computer date intervals without the nagging doubt of “close enough”.
Next, we’ll concentrate on leveraging tables, pivot tables and troubleshooting tips to set you up for success when it comes to delivering quality, comprehensive reports that lead decision-making in the right direction.
Best of all, this course meets you where you are with your Excel skills. Whether or not you’re an ace formula builder or pivot table pro, you’ll come away with the tools for which you’ve been looking all these years. For those with a bit more experience, we’ll take some familiar techniques and help you extend them to deal with data issues you previously thought were impossible to tackle efficiently.