Excel Crash Course – Data Cleaning in Excel in 1 Hour
In this Excel crash course on data cleaning in Excel tutorial, MS Office expert Deb Ashby shows you:
– Why it’s so important to work with a clean dataset
– Some amazing tips and tricks to help you clean data in Excel including TRIM, PROPER and CLEAN
– Resizing and formatting data to make it visually attractive
– Paste Values in Paste Special
– How to remove blank rows or populate blank cells across an entire workbook
– How to make the most of the Find and Replace and SUBSTITUTE formulas.
– How to fix date problems and format dates properly
– How to import data from an external source and how to import using a delimiter.
To download the exercise file used and follow along in Excel CLICK HERE
To download the import data used CLICK HERE
Enjoy!
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
