Want to learn how to design a salary structure? Check: [ Ссылка ]
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: [ Ссылка ]
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: [ Ссылка ]
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:
[ Ссылка ] ***HR Analytics with Excel***
Topic: How to create a Merit Matrix with Goal Seek function
Business Scenario: When planning for salary increase, you need to create a merit matrix that allows you to spend your merit increase budget properly.
Formula: Goal Seek, Index() and Match()
Steps to create a Merit Matrix:
1. Set up Merit Matrix relationship around your anchor point 2:19
2. Use Index and Match to apply increase suggestion to all employees 13:50
3. Calculate merit increase spend for all employees and sum it 14:40
4. Use Goal Seek to find the ideal Merit Matrix % 16:00
5. Adjust Merit Matrix relationship and re-run goal seek if needed 17:57
For more successful stories, view at: [ Ссылка ]
******Follow-up Consulting Services******
If you have specific question regarding your issue, you can email me at the email here [ Ссылка ] 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: [ Ссылка ]
******More Videos in Playlists******
Power BI for Beginners: [ Ссылка ]
Power BI for Advanced Users: [ Ссылка ]
Excel for HR [ Ссылка ]
Excel for HR - Master Class [ Ссылка ]
Excel Macro - Beginner [ Ссылка ]
Excel Macro/VBA - Splitting a Master File [ Ссылка ]
Excel Macro/VBA - Auto-hide Rows or Columns [ Ссылка ]
Excel Charts Data Visualization [ Ссылка ]
Excel Vlookup Function [ Ссылка ]
Excel Pivot Table Function [ Ссылка ]
Excel Array Function [ Ссылка ]
Excel Index and Match Function [ Ссылка ]
Excel Solver/Goal Seek Functions [ Ссылка ]
Excel Cell Formatting Solutions [ Ссылка ]
HR Analytics - Merit Matrix [ Ссылка ]
HR Analytics - Salary Structure [ Ссылка ]
Excel Tricks [ Ссылка ]
Excel Troubleshooting [ Ссылка ]
Fun HR Topics [ Ссылка ]
For more successful stories, view at: [ Ссылка ]
#ExcelforHR#HRAnalytics#Excel#HR
