Excel for HR - What is Compa-Ratio and How to Calculate it

  Рет қаралды 27,252

Caripros HR Analytics

Caripros HR Analytics

Күн бұрын

Want to learn how to design a salary structure? Check: www.caripros.c...
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
caripros-hr-an... Topic: What is Compa-Ratio and How to calculate Compa-ratio for employees
Related Topics: Merit Matrix, Salary Structure
For more successful stories, view at: caripros.com/in...
*****Follow-up Consulting Services*****
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: www.paypal.me/...
*****More Videos in Playlists*****
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/in...
#ExcelforHR#HRAnalytics#Excel#HR

Пікірлер: 15
@wesharela6373
@wesharela6373 6 жыл бұрын
Omg your video is seriously informative and great and has really helped me understand compa-ratio well ! This is so great for my exams !! Awesome! THANK YOU! Keep up the great work!!!! :D
@satadrusinha7097
@satadrusinha7097 3 жыл бұрын
In d11 coloum you have mentioned heading compa ratio tell me from where you are determining that value and what is the purpose of mentioning that coloum
@omaralkarnos4488
@omaralkarnos4488 6 жыл бұрын
Thanks a lot, i will complete watching the other vids, this really helpful as i'm working on presenting a Merit Increase proposal to the management.
@virginaregan9777
@virginaregan9777 5 жыл бұрын
Good job, 👌the presentation is well expressed.
@CariprosHRAnalytics
@CariprosHRAnalytics 5 жыл бұрын
Thank you Virgina!
@surajkumar-zb3ey
@surajkumar-zb3ey 4 жыл бұрын
You are a blessing 👍
@mariajauslin1107
@mariajauslin1107 5 жыл бұрын
Could you please show exactly how are those min, mid and max salaried calculated?
@jgonzalez1984mx
@jgonzalez1984mx 4 жыл бұрын
You need a compensation course
@kurniafitra
@kurniafitra 2 жыл бұрын
Thank you so much!
@rajeshvasudevan3900
@rajeshvasudevan3900 6 жыл бұрын
Thanks for your videos, very informative. I started to implement this, thanks a lot. I have one doubt regarding Market Median Salary. how do we derive this info, is this based on salary survey ? suppose we say HR manger salary say between 35,000 to 40,000/-. So how do we consider Market Median Salary, please help me to solve my enquiry, thanks
@CariprosHRAnalytics
@CariprosHRAnalytics 6 жыл бұрын
Hi Rajesh - yes the market median salary are provided by market survey vendors like Mercer, Hay Group, etc. They are not free but quite accurate. If you want free information, websites like Payscale would be of a reference (but not as accurate). eg www.payscale.com/research/CA/School=Concordia_University%2c_Montreal/Salary if you check this out, it would provide some salary info by job and by location, etc.
@rajeshvasudevan3900
@rajeshvasudevan3900 6 жыл бұрын
thanks a lot for the reply in deatil, much appreciated
@jasondong9293
@jasondong9293 3 жыл бұрын
It is very useful
@mennanafel1906
@mennanafel1906 5 жыл бұрын
Thank you
Critical HR Ratio Explained: What is Compa-ratio, Range Penetration and more
14:15
How to evaluate and visualize an internal equity or pay compression issue?
15:18
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
What is COMPA RATIO and how do you use it for pay decisions?
10:43
How to Create a Merit Matrix for Salary Increase with Goal Seek Function
20:06
Caripros HR Analytics
Рет қаралды 48 М.
Excel for HR - Prorate Employee Salary for Merit Increase or Bonus Calculation
12:20
How to create a 4-Quadrant Matrix Chart in Excel
10:49
Caripros HR Analytics
Рет қаралды 319 М.
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)
15:12
Compa-Ratios and Salary Grades
7:43
Performance Solutions
Рет қаралды 18 М.
Math Olympiad l A Beautiful Exponential Problem l VIJAY Maths
10:30
Excel for HR: Multiple Groups of Employee Data vs Salary Structure
11:20
Caripros HR Analytics
Рет қаралды 13 М.