Chapter 4. Manipulating Records
A table is a set of columns and rows. Each column represents a single type of data. For example, a table might have three columns representing name, gender, and age. Each row in the table is a record. For each record in the table, the name column contains a name, the gender column a gender, and the age column an age. When you structure a worksheet as a table, you can use Excel's database-like capabilities to go beyond what is possible with a simple worksheet.
This chapter shows you how to work with data that you have structured as a table. Much of the chapter focuses on sorting and filtering. To sort means to arrange a list in order, either alphabetically or numerically. You can sort and re-sort lists as necessary, ...
Get Microsoft® Office Excel® 2007 VISUAL™ Quick Tips 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.
