O'Reilly logo

Using Microsoft Office for Mac 2011 by Yvonne Johnson

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

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

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