Clean data is vital to generate accurate results for evaluations. Most organizations use excel for all data processing and don’t have the skillsets to use complex programming languages or pricey proprietary software to clean datasets. These manual processes can take hours and can miss vital data.
The University of Houston has a free ebook on Excel for Decision Making with a chapter on cleaning and restructuring data . The chapter features easy to use formulas and practical examples of their execution. These formulas are not only useful for data cleaning but can be used to format spreadsheets.
Read book: Excel for Decision Making by Emese Felvegi, Noreen Brown, Barbara Lave, Julie Romey, Mary Schatz, Diane Shingledecker, and Robert McCarn