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.