Data: Data Cleaning

The Quartz Guide to Bad Data

An exhaustive reference to problems seen in real-world data along with suggestions on how to resolve them.

Excel 2016: Cleaning Up Your Data (LinkedIn Learning)

The course explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert dates into the desired format, and prepare data for efficient analysis. Also covers adjusting column and row placement, transposing data with the REPLACE and SUBSTITUTE functions, the Text to Columns command, the Flash Fill feature, and more. 

Length: 2 hours, 20 minutes. (Free access with Bucknell login.)