How to Clean Data in Excel
Sending out a report that contains errors is embarrassing. I know, I've done it! You present a report to management, and they come back with questions around errors you should have found. In this post I'll share 11 essential steps for pristine data to ensure it doesn't contain duplicates, extra spaces, misspelt words, and other …