How to Create Employee Annual Salary Increase Template - Excel for HR

Want to learn how to design a salary structure? Check: caripros.com/design-salary-structure-with-regre…
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.teachable.com/p/design-sa… How to Create Employee Annual Salary Increase Template: For Year end at salary planning cycle, there is always need to plan and calculate employee salary increase or adjustments. This video offers you step-by-step instruction on how to build a salary increase template and use it for your organization.

2:51 Step 1: Customize the tabs to fit your organization's need (leverage Excel templates if applicable)
6:00 Step 2: Input employee information on the "planning sheet" - employee section
8:25 Step 3: Input budget information on "planning sheet" - budget section
13:29 Step 4: Create formula on the "planning sheet" and test with data
For advanced edition, you can add:
- Analytical dynamic charts
- Merit Matrix
- Macro/VBA to solve for more complex issues
24:33 Step 5: Make workbook as user-friendly as possible, such as:
- Highlight cells where input is needed for user(s)
- Add toggle buttons for easy navigation across sheets
26:39 Step 6: Lock up all areas where users cannot change and hide information they do not need to see (eg. This tab)
31:54 Step 7: Password-protect the workbook and send off to user(s)

I am sharing a template this time 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 Hope it saves your time!

Related Video:
HR Analytics - Merit Matrix goo.gl/Koy7co
Excel for HR goo.gl/JdeVnd

******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: 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-stories/

#ExcelforHR#HRAnalytics#Excel#HR