Data-Cleaning-in-MS-Excel

  • In this project, a customer data set is cleaned using MS Excel.
  • Some important steps included in the data cleaning process are: spelling checking, removal of empty rows and duplicate rows, using find and replace to mention appropriate values, applying string functions, trimming white spaces
  • The workbook contains two worksheets, one with the original data and other post cleaning process, so that the changes can be seen and compared.