This course is designed for the busy HR professional to learn Excel skills that will help them save time and make them more productive. Attendees will have a chance to practice using these skills during the workshop.
Learning Objectives:
Learn how to use CONCAT (pull names together), LOOKUP (pull information from other sources), IF statements and various DATE functions
Understand how to use conditional formatting to “flag” items so they stand out
Use filters in creative ways to “find” what you are looking for quickly
Create drop-downs and slicers to drive dynamic data
Create charts to visually represent information professionally