O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6

Building Tables for Data Analysis

Understanding Tables

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required