Thursday, June 2, 2011

Cleaning data in Excel

In class, I noted that Excel is a gigantic toolbox of tools - there are so many ways to perform a task. Some ways are old (Excel is a long lived program), some techniques are freshly designed, some are easy but limited in power, some are powerful but need more thinking. Here is the Excel 2010 help page discussing different data cleansing techniques.