Excel for HR - Prorate Employee Salary for Merit Increase or Bonus Calculation

Want to learn how to design a salary structure? Check: www.caripros.com/design-salar...
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-analytics.teachab... Topic: Excel for HR - Prorate Employee Salary for Merit Increase or Bonus Calculation
Scenario: You want to calculate Merit Increase or Bonus for an Employee who are not active for the full year
Function: Days()
For more successful stories, view at: caripros.com/index.php/success...
*****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/caripros
*****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/index.php/success...
#ExcelforHR#HRAnalytics#Excel#HR

[@user-ug3zq3pz7w]

very helpful

[@controlyournumbers100]

Is there a way to automate this process? Instead of doing it one by one?
I only need to do this for active terminated employees
Active will get bonus and merit terminated will not

[@sully199]

Great video

[@nhungbui1832]

Hi Rachel, I think we also should add "+1" in each formula days() for the best result of proration %, pls advise if I am incorrect? Thank you for your videos.

[@geetuahuja6367]

Hi thank you for great video's . I am your new fan. I wanted to learn how to show project for next 2 -3 year for cost optimization graphs in Salary . Could you please help . With this we can to work how many years we wanted to keep almost same salary as per market max

[@violetweiss8784]

I used the days function and it gave me a -2.19%

[@mariabarreto7152]

Hi I need help in prorating a monthly inv at $5K max hours per month 20 prorated from 10/22 - 10/31- My numbers don't add up to my manager's totals

[@emilywong4890]

Thats not working if there are over 1000 staff in the company. Excel formular is suppose to simplify all the procedures, but not revising every formula manually.

[@charlesgist7592]

True, but hopefully you would not have a scenario where all 1,000 people started during the year or were unpaid for a portion of the year.

[@enigmatic1984]

Better to create another column for unpaid days and add a condition in the days calculating formula by using the if function with the reference check for unpaid days. This way you don't have to manually enter the formula for all such cases. You can also add a column to determine rehires during a year and then use the IF function to calculate the days.

[@nhungbui1832]

@@enigmatic1984 could you please share me how to do this. Much thanks!