Nonprofit.Courses Select by Lorman

Tabular Data and Lists in Microsoft® Excel®, by Lorman

Tabular Data and Lists in Microsoft® Excel® is brought to you by Lorman

Learn how to transform data into meaningful, organized tables in Microsoft Excel.

Managing and analyzing data can be overwhelming. However, an Excel table allows for consistent and uniform data. Your data’s additional rows and columns will update with refresh and features, such as sorting and filtering. It is a simple way to professionally format your work and is especially helpful in organizing your data with PivotTables. Along with Excel tables, you can manage data via a list or sequence of rows of related data. The difference is that tables have additional functionality. For example, tables display rows in alternating colors, while lists do not. Lists allow for more layout options than a table and are a helpful feature in data validation. A drop-down list can be created to allow users to select even a dependent value.

See more content from Lorman by clicking here.

0 0 votes
Give it a rating!
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments