Two functions in Excel can help you save time when performing analyses on big compensation files : conditional formatting and sorting.
Imagine you have big file with salary information and you want to find out who are the lowest paid of managers in the organisation.
Conditional formatting
Filtering
Enjoyed this post ? Why don’t you subscribe by email to receive my posts direct to your inbox 3 times per week ? Simply enter your email in the box at the top of the column on the right !
Related posts :
[…] Two Excel functions to save time in compensation files Copyright protected by Digiprove © 2012 Sandrine BardotSome Rights ReservedOriginal content here is published under these license terms: X License Type:Non-commercial, AttributionLicense Summary:You may copy this content, create derivative work from it, and re-publish it for non-commercial purposes, provided you include an overt attribution to the author(s).License URL:http://creativecommons.org/licenses/by-nc/3.0/ Filed Under: Sunday Skills Tagged With: Compensation Surveys, Excel tips […]