HR Analytics with Conditional Formatting in Excel Color Coding, Progress Bar in Excel Cell
In this video, I share how to add a visual to your percentage columns in any excel spreadsheet.
This simple hack can make your spreadsheets more appealing and easier to understand.
In this example, I’m using data bars (or progress bars), to visualize where an individual’s salary falls within a salary range. The previous video goes over this common HR/Compensation metric, called Range Penetration, or Position in Range: • HR Compensation 101: Position in Range Met...
You can find the template covered in the video right here – https://timesavingtemplates.com/produ...
It’s also part of the Base Pay Bundle, for HR professionals - https://timesavingtemplates.com/sp/co...
For free resources and spreadsheet tips, visit - https://timesavingtemplates.com/freer...