10 Simple Rules for Data Cleaning with Excel

Join us for a 90-minute crash course in data cleaning basics with Excel.

Through this workshop, participants will learn*:

• Simple and advanced filtering
• Creating histograms through the Data Analysis Toolpak
• Splitting multi-valued cells and trimming whitespace
• Data validation and custom lists

*Disclaimer: This class is not a general Excel class, but rather a specialized application of Excel. Galter Health Sciences Library & Learning Center does not provide technical support for any Microsoft Products.

Guides

• Data Cleaning with Excel (guide)
• 10 Simple Rules for Data Cleaning with Excel (slide deck)