Lynda - Excel 2016: Cleaning Up Your Data

Lynda - Excel 2016: Cleaning Up Your Data

Imported data isn't always pretty. In this course, Dennis Taylor explains how to take data from a system file, database, text file, or poorly designed Excel worksheet, and whip it into optimal shape. Dennis 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. He covers adjusting column and row placement, transposing data with the REPLACE and SUBSTITUTE functions, the Text to Columns command, the new Flash Fill feature, and more.

https://www.lynda.com/Excel-tutorials/Excel-2016-Cleaning-Up-Your-Data/551486-2.html

Introduction

1. Readjusting Data Layouts

2. Replacing Data at the Character Level

3. Adjusting Date-Based Data

4. Working with Number to Text Conversion Issues

5. Combining, Splitting, and Adjusting Columnar Data

6. Using Specialized Techniques to Adjust Data

Conclusion

Table of Contents

Would you like to be a Author?