Microsoft Office Tutorials and References
In Depth Information
Understanding Tables
Understanding
Tables
In Excel, a table is a rectangular range of cells used
to store data. The table is a collection of related
information with an organizational structure that
makes it easy to find or extract data from its
contents.
To get the most out of Excel tables, you need to
understand a few basic concepts, such as how a table
is like a database, the advantages of tables, and how
tables help with data analysis.
A Table Is a Database
A table is a type of database where the data is organized into
rows and columns: Each column represents a database field,
which is a single type of information, such as a name, address,
or phone number; each row represents a database record,
which is a collection of associated field values, such as the
information for a specific contact.
Advantages of a Table
A table differs from a regular Excel range in that Excel offers a
set of tools that makes it easier for you to work with the data
within a table. As you see in this chapter, these tools make it
easy to convert existing worksheet data into a table, add new
records and fields to a table, delete existing records and fields,
insert rows to show totals, and apply styles.
Data Analysis
Tables are also useful tools for analyzing your data. For example, in Chapter 11
you learn how to sort table records and how to filter table data to show only
specific records.
Search JabSto ::




Custom Search