Completed
Cost of Training by Employee with Sumif
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for HR: Data Management and Analysis
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
- 19 Introduction to Module 2
- 20 Filtering a Converted Table
- 21 Table Slicer Tool
- 22 Total Row
- 23 Conditional Formatting
- 24 Subtotal Tool
- 25 Restrict Cell Input with Data Validation
- 26 Import Data From Other Source
- 27 Inserting a Recommended Pivot Table
- 28 Show Value as Percent of Grand Total
- 29 Drill Down Reports
- 30 Report Filter Pages
- 31 Inserting a Pivot Chart
- 32 Conclusion
