Excel Magic Trick #48 Part 1: Bad Data To Good Data
See how to take data that is not set up properly and set it up properly so that you can use Excel's Data Analysis features such as Sort, Filter, Subtotals and Pivot Tables.
See how to take data that is not set up properly and convert it to Excel Table (Excel List or Database) format to that you can use Excel's Data Analysis features such as Sort, Filter, Subtotals and Pivot Tables.
See how to use Text To Columns and Go To Special Blanks to help speed up the process to fixing bad data.
Channel: Science & Technology
Uploaded: April 10, 2008 at 4:06 pm
Author: ExcelIsFun
Length: 07:16
Rating: 5.00
Views: 595
Tags: and Blanks College Columns Community Excel format Gel Girvin Go Highline List Mike Sort Special Table Text To
Video Comments
|
