Coding / Programming Videos

Post your favorite coding videos and share them with others!

Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Download Video link >



Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Topic: Benchmark with Market Pay for Multiple Jobs (Part 1)
Chart Type: Clustered Column Chart
Business Scenario: You need to decide whether to increase pay level for a job (Business is complaining!).

You have the market data for 2 jobs and you want to visualize them for yourself and your clients.

In the next video, I will show you how to compare the market pay to internal employee pay and visualize them.

******Follow-up Consulting Services******
If you have specific question regarding your issue, you can email me at the email here https://goo.gl/WejijZ Note that there will be a fee of US$50 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: https://www.paypal.me/caripros

******More Videos in Playlists******
Excel for HR https://goo.gl/JdeVnd
Excel for HR – Master Class https://goo.gl/LYfq2f
Excel Macro – Beginner https://goo.gl/Yae5nc
Excel Macro/VBA – Splitting a Master File https://goo.gl/m8CHya
Excel Charts Data Visualization https://goo.gl/2ao6BP
Excel Vlookup Function https://goo.gl/kP2Wpz
Excel Pivot Table Function https://goo.gl/rukkPs
Excel Array Function https://goo.gl/i4sQH8
Excel Index and Match Function https://goo.gl/i7VGU4
Excel Solver/Goal Seek Functions https://goo.gl/FTkTnj
Excel Cell Formatting Solutions https://goo.gl/gpa6MY
HR Analytics – Merit Matrix https://goo.gl/Koy7co
HR Analytics – Salary Structure https://goo.gl/uZBnFa
Excel Tricks https://goo.gl/TeqGDw
Excel Troubleshooting https://goo.gl/bdY5by
Fun HR Topics https://goo.gl/7zVg8h

For more successful stories, view at: http://caripros.com/index.php/success-stories/

******Tools I use for this channel******
Channel management: https://www.tubebuddy.com/HRAnalytics
“I Love Spreadsheets” Mug: https://amzn.to/2D0bYmL

source

Bookmark(0)
 

 

View Comments source >

Transcript view all >

00:01 hello everyone today I want to show you

00:04 how to benchmark with market pay for

00:07 multiple jobs so the business scenario

00:10 is like this which is actually a typical

00:12 one so you are a HR manager and then a

Leave a Reply

Please Login to comment
  Subscribe  
Notify of
Translate »