Excel Quick Data-Cleaning Tips

This four-page resource sheet from EvaluATE: Evaluation Resource Center for Advanced Technological Education provides strategies for cleaning data in Microsoft Excel. This resource gives an overview of five common scenarios encountered when working with data in Excel. For each scenario, this guide supplies solutions and step-by-step instructions to implement those solutions. Excel functions covered include conditional formatting, duplicate removal, data validation, flash fill, and formulas.