10. Working with Tables
Microsoft Excel’s table feature (formerly known as its list or database feature) and related functions help make it a flexible tool for organizing, maintaining, and reporting data. With Excel, you can easily filter data, sort records, and generate subtotals for a table, all without affecting other information in the same worksheet file. You can use Excel’s calculating, formatting, charting, and printing features on your table, too.
In Excel, a table is a range of worksheet cells with unique labels in the first row that has been identified as a table. Figure 1 shows an example of a very small, basic table with header and total rows.
Figure 1. Here’s a tiny table with just a few records and fields. Note the ...