Business Finance – Management this is a discussion not an assignment.. i must have original work ONLY with at least one up to date reference and 150 words at least

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.

The basics of cleaning your data

Spell checking

Removing duplicate rows

Finding and replacing text

Changing the case of text

Removing spaces and nonprinting characters from text

Fixing numbers and number signs

Fixing dates and times

Merging and splitting columns

Transforming and rearranging columns and rows

Reconciling table data by joining or matching

Third-party providers