Completed
Return Employee Details Based on Employee Number
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for HR Professionals - Data Management and Analysis Fundamentals
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Text to Columns Tool
- 4 Flash Fill
- 5 Calculate Length of Service with Today Function
- 6 Calculate Gross Pay and Days Remaining
- 7 Using a Form to Manage Records
- 8 Overview of the IF Function
- 9 Programs Completed by Employee with Countif
- 10 Cost of Training by Employee with Sumif
- 11 Naming Ranges for Reuse
- 12 Average Cost per Program with Averageif
- 13 Overview of Xlookup
- 14 Return Employee Details Based on Employee Number
- 15 Consolidate Sheets into a Single Report
- 16 Inserting a Chart
- 17 Managing an Inserted Chart
- 18 Capture Trend Analysis with Sparklines
