Week 6 Discussion – Data Cleaning
Please respond to the following:
What did you know about data cleaning before you began working on the team project?
Is it important to clean data meant for analysis? Why or why not?
What, if any, problems might result for a business that relies on data if the data being analyzed is not cleaned properly?
Top ten ways to clean your data
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016
Misspelled words, stubborn trailing spaces, unwanted prefixes, improper cases, and nonprinting characters make a bad first impression. And that is not even a complete list of ways your data can get dirty. Roll up your sleeves. It is time for some major spring-cleaning of your worksheets with Microsoft Excel.
