Want to learn how to design a salary structure? Check: https://www.caripros.com/design-salary-structure-with-regression-analysis-upgraded-with-case-study
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: https://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: https://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:
https://caripros-hr-analytics.teachable.com/p/design-salary-structure-with-regression-analysis Sometimes we need to create charts with numbers with drastically different scale and the standard charts will not be able to present what exactly we want to show. This video shows a simple method to show the data with broken axis and data bars.

Business Scenario: Showing headcount by departments and there are huge difference in headcount by department.

******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$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: https://www.paypal.me/caripros

******More Videos in Playlists******
Power BI for Beginners: https://bit.ly/3ivKitD
Power BI for Advanced Users: http://bit.ly/3lE9zmO
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 Macro/VBA – Auto-hide Rows or Columns http://bit.ly/2Mzteb5
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/

#ExcelforHR#HRAnalytics#Excel#HR

Please take the opportunity to connect and share this video with your friends and family if you find it useful.