In this my second blog post relating to the frustrations I come across in Excel, I am going to continue on my initial theme of using the filter function. More often than not, the data you are looking at needs to be cleansed before it can be used in any meaningful way. For example, you might have a set of data that looks like this where you need to correct the “Area” to be Head Office:
If you use the drop down list for “Area” you will see the following:
Notice that the drop down list picks up the misspelled word but does not differentiate the word that is typed in CAPITALS. If you have a significant amount of data alterations to make because the underlying source data is of a poor quality (in my experience this happens all too often), it can take some time to go through the spreadsheet to eliminate the poor quality and often it is only after you have done some analysis that you realise you have a problem. A further challenge is that you can’t “see” what data you have changed and sometimes you might introduce an error into the data set that you don’t realise until a subsequent point in time.
OrgVue helps to overcome these issues with a combination of the filter function where you can select both the capitalised words and the incorrectly spelt words in one go.
OrgVue has a “splash command” equivalent to a copy paste function in Excel that you can use to update records quickly and easily although more of this in a future blog post on this very powerful feature. Colouring means the changes that you have made can be easily seen. You can see from the OrgVue screen that the corrected words have been coloured green and OrgVue allows you to “undo” these changes if you are unhappy with them. This type of cleansing functionality is a powerful feature and can save considerable time and frustration.
Find out more about how OrgVue can improve your productivity and enhance the quality of your data and much much more at our website.
Latest posts by Patrick Gracey (see all)
- What can be done to improve your chances of acquisition success - September 27, 2017
- “Just a little faster this time”: How HR thinking needs to evolve to help organisations survive - October 1, 2013
- Fortune Global 500 – Adding insight - August 8, 2013