This video provides an overview of data cleaning in MS Excel. This is ideal for anyone who uses MS Excel (or Sheets) and works with datasets which require cleaning, or if you have questions about data structure and organization.
Data cleaning can be a time-consuming and frustrating task when working with quantitative data. This session will demonstrate working with unclean data and the best practices for how to prepare and transform messy data for analysis or visualization. We will demonstrate cleanup processes primarily in Microsoft Excel.
After viewing this training, you will be able to:
- Learn how to identify what data needs to be cleaned
- Set-up a TRIM function, modify text to number and remove duplicates to clean dataset
- Utilize CONCATENATE and PROPER to modify data to allow for easier analysis
