Excel 2016: Cleaning Up Your Data (LinkedIn Learning)
An online course on LinkedIn Learning with transcripts, exercise files, and self-assessment quizzes. 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.)