Using Microsoft Office for Mac 2011

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