Start learning with our library of video tutorials taught by experts. Get started
In this course, Dennis Taylor explores 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.
Hi! I am Dennis Taylor, and I'm pleased to present Cleaning Up Your Excel Data. This course designed to confront the myriad of problems associated with streamlining your data by providing quick, easy-to-use solutions. First we'll look at how to re-adjust column row placement with simple dragging techniques for easy viewing all of your data. Then we'll examine how to transpose and adjust data using tools like Find and Replace, and Text to Columns, and we'll also look at how to take full advantage of powerful text functions to deal with unwanted spacing and formatting issues, as well as text-to-value or value-to-text Conversions.
So let's get started with Cleaning Up Your Excel Data.
Find answers to the most frequently asked questions about Cleaning Up Your Excel Data.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.