Clean data is essential to trustworthy analysis. No one wants to see errors in their analysis—or worse, have errors go undetected and incorrectly steer business decisions. 

The vast majority of business analysts have learned how to clean data in Excel. But given the huge number of Excel data cleaning techniques, this is usually an on-going process. To help analysts get their start (or refresh some old tricks), we’ve selected three of the most common ways for how to clean data in Excel below: