Chapter 17
Building and Maintaining Tables
IN THIS CHAPTER
Creating and editing tables
Sorting the records in a table
Subtotaling values in a table
Filtering out unwanted data in tables
Querying data in external database tables
Besides its considerable computational abilities, Excel is also very accomplished at maintaining vast collections of related data in what are commonly referred to as tables. This chapter gives you a chance to practice all the basic aspects of creating and maintaining tables in Excel, including building the table, adding and editing its data, filtering the table to temporarily remove unwanted data, subtotaling values in a table, and creating tables from data external to the worksheet.
Creating a Table
In Excel, a table is a range of worksheet data with a special structure. Unlike the other types of ranges that you might create in Excel, a table uses only column headings (technically known as field names) to identify the different kinds of items the table tracks. ...
Get Excel Workbook For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
