15. Working with Databases and Multiple Worksheets

This chapter shows you how to work with databases and multiple sheets in a workbook. It also covers 3D formulas.

In this chapter, you learn about sorting and filtering databases; adding, renaming, deleting, copying, moving, hiding, and unhiding worksheets; grouping worksheets; and entering 3D formulas in workbooks that have multiple worksheets.

Creating a Database

A database is really nothing more than a list, and studies have shown that making lists is one of the main things for which people use an Excel worksheet. A database can be a single column, but normally it has several columns, such as the one shown in Figure 15.1.

Figure 15.1 The database shown here has 10 fields and more records ...

Get Using Microsoft Office for Mac 2011 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.