How To Build A Salary Structure Using Excel: A Beginners Guide

Learn how to build a salary structure using excel. A Salary Structure (or Pay Structure) is a hierarchal group of jobs and salary ranges within an organization. #SalaryStructure #PayStructure

⏰Timestamps
0:00​ - Intro
0:20​ - What is A Pay Structure?
1:23​ - Practical Case Study in Excel
7:37 - Recap & Questions

📌Remember to subscribe to my channel for more videos: @segunakiode

🎀You may be interested in the following Human Resources Insights Episodes:

★☆★ CONNECT WITH ME ON SOCIAL MEDIA ★☆★

[segunakiode]

📌Remember to drop your comment and to subscribe to my channel for more videos. 😀

[md.a.kaiumkhandaker]

Hello this is Abdul kaium from Bangladesh. I am a HR professional.
Looking at all your videos, I like it very much.
Thank you so much for your nice video.

[kehindeolugbemi]

Segsman, you nailed it. Enlightening. you broke it down to a lay man's understanding. You a da best.

[godstimeehikioya]

Thank you so much for all the wonderful resources you share with your viewers here.
May God bless your efforts richly.
Kind regards.

[beingZeeky]

Thank you for making this video.
I would build on this as I go.

[ximinia]

Thank you for this detailed explanation and for the template! You are the best!!!

[susieko]

This is a very useful reference material. Though progression is varied by company, is there any market norm for the best / popular progression %?

[marienowiepereja]

This is reallyyy helpful 🥰 Thank you so much for the input as I'm about to make the same report tomorrow 🙏

[MsEMK]

Sir, thank you for the video. It has been very helpful. What are some of the factors to consider when setting the midpoint progression and the pay range spread?

[gabrielolusesi]

Thanks Mr Segun Akiode for the explanations. Sir My question is are your videos available for sale?

[chidinmahelen]

Thanks a lot sir for the insight.
My question: is it compulsory to use the same mid point progression for the grade

[ma.jardishamarcellana]

Is there a prescribed midpoint progression percentage and per range spread percentage? How do we know that the percentage is too much or too less?

[shealinglim]

Hi, thanks for this great video! Btw, how did you get the Salary Structure Design Chart? What chart type is this?

[rachelrodrigues]

Hi Segun, can you explain what Pay Range Spread means ?

[shwetakhisty]

Hi

I had a question. I already have a salary ranges for higher level. How do you calculate salary below the salary range

For eg min 40000 mid 50000 max 60000
How to create a salary range below this salary range

[julianabentil]

Hello Segun, what happens to employees who are above the Maximum of the salary structure?

[chidiky]

Hi Segun, can I reduce the spread across the banding or 75% best practise?

[LisaWest-cbmc]

how did you get the 75% pay range spread

[siddeshkute]

Can midpoint progression be different for each grade?

[ruthfrancis]

Pls this salary structure is it for one person or a group