Skip navigation

On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

Structure data for optimum usage

Structure data for optimum usage: Excel 2016: Managing and Analyzing Data
Structure data for optimum usage: Excel 2016: Managing and Analyzing Data

To get the most from Excel's Data Management tools, make sure list-type data has no empty rows or columns and that column headers are in a single row on to. Avoid putting too much data in a single column; people's name should be in reverse order or in separate columns. City, State, Zip should be in separate columns.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
270,775
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now