Data Cleaning

4 lessons in order

Learn how to remove numbers from a cell in Excel using Flash Fill, Find & Replace, SUBSTITUTE, formulas, Power Query, or VBA methods.

Learn how to remove outliers in Excel using TRIMMEAN, IQR logic, standard deviation, or manual methods to clean up your data analysis.

Learn how to automate data cleaning in Excel using Power Query, Flash Fill, Find & Replace, and formulas to fix messy data fast.

Learn how to remove drop-down arrows in Excel using filters, tables, data validation, Paste Values, VBA, and Go To Special methods.