Excel Data Analysis for Human Resources Professionals
This course is designed to give you a comprehensive grip on Excel with a strong focus on HR related tasks. Learn Excel as a savvy tool for enabling quantitative and research skills. Get perceptiveness and insight into data for effective decision making.
Often, HR data is either hand-generated or downloaded from an HRIS system. Gleaning action-ready information from a large dataset could be overwhelming for many users. This course focuses on several Excel tools, including PivotTables, to analyze HR Data and create complex, well formatted reports in an effortless manner. You will be able to perform many analytical tasks with ease, speed and a great level of confidence.
(Pre-approved by CPHR-BC & Yukon, CPHR-Alberta and CPHR-Manitoba for 6.5 CPD hours)
Prerequisites: Successful completion of our Formulas and Functions for HR course OR must have some experience of working with Excel formulas and functions. Proficiency in Windows environment with excellent mouse skills.
Software Version: Microsoft Excel 2013/2016/2019/O365
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person training is currently not available due to COVID-19 pandemic)
Course Outline: Excel Data Analysis for HR
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements
Course Pre-approved for 6.5 CPD hours by CPHR-BC & Yukon.
Course Pre-approved for 6.5 CPD hours by CPHR-Alberta.
Course Pre-approved for 6.5 CPD hours by CPHR-Manitoba.