I have created a Youtube Channel of Caripros HR Analytics to help you master the skills more efficiently. Please visit and subscribe if you find it helpful!
Excel for HR: Propose Merit Matrix using Formula Index and Match
Excel for HR: Salary Structure Floating Bar Chart
Excel Macro/VBA – Splitting a Master File (Watch on Youtube to see the full Playlist)
Excel Solver/Goal Seek Functions (Watch on Youtube to see the full Playlist)
Excel Pivot Table Function (Watch on Youtube to see the full Playlist)
Excel Cell Formatting Solutions (Watch on Youtube to see the full Playlist)
Excel Index and Match Function (Watch on Youtube to see the full Playlist)
Excel Array Function (Watch on Youtube to see the full Playlist)
Excel Vlookup Function (Watch on Youtube to see the full Playlist)
Excel Charts Data Visualization (Watch on Youtube to see the full Playlist)