Viewers: in countries Watching now:
Need to get data from a business-management system file, database software, text file, or poorly designed Excel worksheet into optimal shape for Excel 2013? This course can help. Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert data into the desired format, and prepare data for efficient analysis. He'll cover adjusting row and column placement; transposing data with Replace and Substitute functions, the Text to Columns command, and the new Flash Fill; and formatting and converting text, numbers, and other values.
(bright music) Hi, I'm Dennis Taylor, and welcome to Cleaning Up Your Excel 2013 Data. This course is designed to confront the myriad of problems associated with stream-lining your data by providing you with quick, easy-to-use solutions. First, we'll look at how to readjust column and row placement, the simple dragging techniques for easy viewing of all your data. Then we'll examine how to transpose and adjust data using tools like the Replace and Substitute functions, the Text to Columns command, and the new Flash Fill feature.
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 and Value to Text conversions. So let's get started with cleaning up your Excel 2013 data.
There are currently no FAQs about Cleaning Up Your Excel 2013 Data .
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.