15 December 2017
Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it.
My top data cleansing techniques are:
- Unpivot data.
- Find & Replace.
- Find errors with Go to Special constants.
- Find blank cells in Excel with a color.
- Remove duplicates in an Excel table.
- Text to Columns: Dates.
- Using formulas to clean data.
- Excel add-Ins.
Full article: Top Excel data cleansing techniques
