Excel for HR: Data Management and Analysis

Excel for HR: Data Management and Analysis

Learnit Training via YouTube Direct link

Conditional Formatting

23 of 32

23 of 32

Conditional Formatting

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. 1 Start
  2. 2 Introduction
  3. 3 Text to Columns Tool
  4. 4 Flash Fill
  5. 5 Calculate Length of Service with Today Function
  6. 6 Calculate Gross Pay and Days Remaining
  7. 7 Using a Form to Manage Records
  8. 8 Overview of the IF Function
  9. 9 Programs Completed by Employee with Countif
  10. 10 Cost of Training by Employee with Sumif
  11. 11 Naming Ranges for Reuse
  12. 12 Average Cost per Program with Averageif
  13. 13 Overview of Xlookup
  14. 14 Return Employee Details Based on Employee Number
  15. 15 Consolidate Sheets into a Single Report
  16. 16 Inserting a Chart
  17. 17 Managing an Inserted Chart
  18. 18 Capture Trend Analysis with Sparklines
  19. 19 Introduction to Module 2
  20. 20 Filtering a Converted Table
  21. 21 Table Slicer Tool
  22. 22 Total Row
  23. 23 Conditional Formatting
  24. 24 Subtotal Tool
  25. 25 Restrict Cell Input with Data Validation
  26. 26 Import Data From Other Source
  27. 27 Inserting a Recommended Pivot Table
  28. 28 Show Value as Percent of Grand Total
  29. 29 Drill Down Reports
  30. 30 Report Filter Pages
  31. 31 Inserting a Pivot Chart
  32. 32 Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.