Excel for HR
75 videos • 10,480 views • by Caripros HR Analytics
1
How to create a 4-Quadrant Matrix Chart in Excel
Caripros HR Analytics
Download
2
Why My Vlookup Function Does Not Work?
Caripros HR Analytics
Download
3
Create Chart with Broken Axis and Bars for Scale Difference - Simple Method
Caripros HR Analytics
Download
4
Excel Chart - Stacked Waterfall Chart for Annual Expenses Reporting
Caripros HR Analytics
Download
5
Create Chart with Broken Axis and Bars for Scale Difference - Complex Method
Caripros HR Analytics
Download
6
How to Create a Bell Curve chart for Performance Rating Distribution
Caripros HR Analytics
Download
7
Excel for HR: Salary Structure Floating Bar Chart with Employee Data
Caripros HR Analytics
Download
8
Excel for HR: Salary Structure Floating Bar Chart
Caripros HR Analytics
Download
9
How to Create a Merit Matrix for Salary Increase with Goal Seek Function
Caripros HR Analytics
Download
10
How to create a 3-Dimensional 4 Quadrant Matrix Chart in Excel
Caripros HR Analytics
Download
11
How to Create Double Clustered Column Chart with Scatter Points
Caripros HR Analytics
Download
12
Excel for HR - Prorate Employee Salary for Merit Increase or Bonus Calculation
Caripros HR Analytics
Download
13
How to Create Multiple Solvers with VBA Loop Function
Caripros HR Analytics
Download
14
How to Create Employee Annual Salary Increase Template - Excel for HR
Caripros HR Analytics
Download
15
How to create a Gantt Chart in 1 click and highlight Weekends and Holidays
Caripros HR Analytics
Download
16
Excel for HR - What is Compa-Ratio and How to Calculate it
Caripros HR Analytics
Download
17
Excel Troubleshooting - 5 Index and Match Errors and How to Check
Caripros HR Analytics
Download
18
How to evaluate and visualize an internal equity or pay compression issue?
Caripros HR Analytics
Download
19
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)
Caripros HR Analytics
Download
20
Excel for HR: Propose Merit Matrix using Formula Index and Match
Caripros HR Analytics
Download
21
How to Create Solver with VBA for Data Modelling
Caripros HR Analytics
Download
22
How to Group and Ungroup Rows with 1 Click – Macro/VBA
Caripros HR Analytics
Download
23
Design Salary Structure Using Exponential Regression
Caripros HR Analytics
Download
24
Excel for HR: Multiple Groups of Employee Data vs Salary Structure
Caripros HR Analytics
Download
25
Find Min, Max and Quartile Value Based on Multiple Criteria with Array Function
Caripros HR Analytics
Download
26
How to Create Line Charts with Shading Areas Above and Under
Caripros HR Analytics
Download
27
Critical HR Ratio Explained: What is Compa-ratio, Range Penetration and more
Caripros HR Analytics
Download
28
[New Case!] Split Sheet into Multiple Sheets with 1 click - VBA
Caripros HR Analytics
Download
29
Create Dependent Dropdown List and Use it for Vlookup (Part 1)
Caripros HR Analytics
Download
30
Excel for HR: Salary Structure Floating Bar Chart with Customized X axis
Caripros HR Analytics
Download
31
How to Filter by Comments, by Cell Border or Merged Cells
Caripros HR Analytics
Download
32
How to Split Cell Content with Line Break into Separate Cells / Columns
Caripros HR Analytics
Download
33
How to create a Stacked Bars within Bar/Bars Overlapping Chart in Excel
Caripros HR Analytics
Download
34
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 2)
Caripros HR Analytics
Download
35
How to Create a Merit Matrix with Solver Function
Caripros HR Analytics
Download
36
What is the Total Rewards Framework and Why it is Important?
Caripros HR Analytics
Download
37
Conditional Format Cells Automatically When You Change Cell Content
Caripros HR Analytics
Download
38
Auto-Refresh Pivot Table and Freeze Format in 1 Click - Macro for Beginner
Caripros HR Analytics
Download
39
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 3)
Caripros HR Analytics
Download
40
How to Create a Horizontal and Vertical Semi-circular Bar Chart
Caripros HR Analytics
Download
41
Create Dynamic Table with Complex Index and Match and Dropdown List
Caripros HR Analytics
Download
42
[Reply to Question!] Troubleshooting: Why my Split Macro does not work?
Caripros HR Analytics
Download
43
How to create a Funnel Chart in excel for Recruitment or Sales Process
Caripros HR Analytics
Download
44
How to Create a Radial Bar Chart and Re-use as Chart Template
Caripros HR Analytics
Download
45
Goal Seek vs Solver
Caripros HR Analytics
Download
46
How to Write a Winning Resume that Recruiters Pick (with Word Cloud)?
Caripros HR Analytics
Download
47
How to Create a Cool Gender Analysis Chart
Caripros HR Analytics
Download
48
[Community Q&A] Save Multiple Sheets as Multiple Email Attachments with 1 Click
Caripros HR Analytics
Download
49
Excel for HR: Custom Sort in Excel: Sort your Job Grade
Caripros HR Analytics
Download
50
Create Dependent Dropdown List and Use it for Vlookup (Part 2)
Caripros HR Analytics
Download
51
Excel for HR: Find and Replace Text in Employee Name
Caripros HR Analytics
Download
52
Reporting Dashboard: Advanced Pivot Table with Calculated Fields and Slicer
Caripros HR Analytics
Download
53
Data Validation: Auto-track cell content change instantly with conditional formatting
Caripros HR Analytics
Download
54
How to Clean the Format of Employee ID for Vlookup Analysis?
Caripros HR Analytics
Download
55
How Xlookup can replace Vlookup, Hlookup, Choose, Index and Match functions
Caripros HR Analytics
Download
56
Excel for HR: Create Performance Rating Distribution Bar Chart with Different Width
Caripros HR Analytics
Download
57
How to Create a Half Circle Radial Bar Chart and Save as Chart Template
Caripros HR Analytics
Download
58
Excel Trick: Paste Special - as Linked Picture or Paste Operations
Caripros HR Analytics
Download
59
How to Display Custom Number Format in Concatenated Texts
Caripros HR Analytics
Download
60
Split Spreadsheet to Multiple Sheets with Hidden Columns - VBA for Beginner
Caripros HR Analytics
Download
61
How to Input Dates into Excel Forms with 1 Click
Caripros HR Analytics
Download
62
How to Round New Salaries with Round, MRound, RoundUp and RoundDown
Caripros HR Analytics
Download
63
Excel for HR: Use Data Validation and Auto-correction to Control Text Input Format
Caripros HR Analytics
Download
64
Create Likert Chart for Performance Rating Distribution with ChartExpo
Caripros HR Analytics
Download
65
Excel for HR: Find and Substitute to split Employee First and Last Names from 1 single text
Caripros HR Analytics
Download
66
Excel for HR: Use Named Range to Build Formula Efficiently
Caripros HR Analytics
Download
67
How I replicated a combo chart from the Economist - the horizontal gridline only
Caripros HR Analytics
Download
68
How to Create Histogram Chart for Data Distribution with 1 Click
Caripros HR Analytics
Download
69
Data Validation: Auto-track formula-driven data change with conditional format
Caripros HR Analytics
Download
70
Data Validation: Auto-track formula-driven data change with conditional format [Excel 2010 & above]
Caripros HR Analytics
Download
71
How to Quickly Insert, Remove and Reformat Blank Rows in Data Table
Caripros HR Analytics
Download
72
[Private video]
Download
73
[Private video]
Download
74
[Private video]
Download
75
[Private video]
Download