Categories: Tutorials

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.
Related Posts
Information
Members of Guests cannot leave comments.
Top Rated News
- Sean Archer
- AwTeaches
- Learn Squared
- PhotoWhoa
- Houdini-Course
- Photigy
- August Dering Photography
- StudioGuti
- Creatoom
- Creature Art Teacher
- Creator Foundry
- Patreon Collections
- Udemy - Turkce
- BigFilms
- Jerry Ghionis
- ACIDBITE
- BigMediumSmall
- Boom Library
- Globe Plants
- Unleashed Education
- The School of Photography
- Visual Education
- LeartesStudios - Cosmos
- All Veer Fancy Collection!
- All OJO Images
- All ZZVe Vectors