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.)