Data Cleaning and Formatting in Excel

Here is a recap of the lecture on Data Cleaning and Formatting in Excel. How to clean our data by conducting spell checking, correcting misspelt values, removing empty and duplicated rows of data were explicitly discussed.
Data formatting by sorting and trimming data, data parsing from text to column, changing case, text wrapping and merging cells were also explicitly discussed.
The lecture note is available here: bit.ly/DataCle...
Next Video will be on how to use conditional formatting in Excel. Stay Tuned !