O'Reilly logo

Microsoft® Office Excel® 2007 VISUAL™ Quick Tips by Denise Etheridge

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

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