Lynda.com has a great new set of videos out that teach you how to clean up your Excel tables to look their best. In this course, you’ll explore the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis. This course helps get data from a business management system file, other database software, a text file, or a poorly designed Excel worksheet into optimal shape for working with in Excel. Exercise files are included. Just ask at the WIC desk or in the Vitale Digital Media Lab if you’d like us to log you into to Lynda so you can watch the videos. Watch a short intro to the course here.
Cleaning Up Your Excel Data | by Dennis Taylor