Building Tables for Data Analysis
In Excel, a table is a rectangular range of cells used to store data; it includes special tools for entering, editing, and analyzing that data. A table is designed to store collections of related information. For example, one table might store business data such as customers, invoices, and inventory, whereas another might store personal data such as contacts, movies, and household items. You can use Excel tables to create, retrieve, and manage large or small collections of information. 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 ...