Chapter 4

Excel workbooks are designed to store lots of information. Organizing this information so that they display meaningful data can be challenging! Excel has many features that can help you organize your data and find what you need efficiently. Setting up your data as a table from the onset will allow you to sort, filter, total, and subtotal your data. In Excel, a table is a collection of data about a subject stored in adjacent rows and columns. Tables can improve the look and feel of your workbook. The chapter begins with the construction of formulas for basic and complex mathematical computations. The ability to produce complex mathematical outputs using the data in a workbook is where Excel shines. The second section of the chapter explores how to best set up Excel tables, how to edit them, and then how to work with them effectively. This chapter concludes by showing how you can use data from multiple worksheets to construct 3-D formulas and functions in mathematical formulas and functions.