Master essential Excel skills specifically designed for HR professionals in this 80-minute tutorial. Learn to efficiently manage employee data through text functions like text-to-columns and Flash Fill, calculate service lengths using the TODAY function, and handle payroll calculations with absolute references. Explore advanced functionalities including XLOOKUP for employee record searches, COUNTIF for tracking program completion, and SUMIF/AVERAGEIF for analyzing departmental training costs. Practice data consolidation techniques across multiple sheets and create impactful visualizations using charts and sparklines to better interpret workforce data. Gain hands-on experience with form-based record management, range naming for efficient formula reuse, and trend analysis tools that streamline HR data processing and reporting tasks.
Excel for HR Professionals - Data Management and Analysis Fundamentals
Overview
Syllabus
Start
Introduction
Text to Columns Tool
Flash Fill
Calculate Length of Service with Today Function
Calculate Gross Pay and Days Remaining
Using a Form to Manage Records
Overview of the IF Function
Programs Completed by Employee with Countif
Cost of Training by Employee with Sumif
Naming Ranges for Reuse
Average Cost per Program with Averageif
Overview of Xlookup
Return Employee Details Based on Employee Number
Consolidate Sheets into a Single Report
Inserting a Chart
Managing an Inserted Chart
Capture Trend Analysis with Sparklines
Taught by
Learnit Training
