Chapter 14: Everyday Functions

Overview

This chapter describes some of the more useful functions Microsoft Office Excel 2007 has to offer. To keep this book from threatening the structural integrity of your bookshelf, we've had to make some hard choices about which functions to highlight. Therefore, this chapter (along with Chapters 15, 16, and 17) by no means represents a comprehensive reference. For complete information about all the built-in functions that Office Excel 2007 has to offer, you can use a number of on-screen tools, covered in "Using the Built-in Function Reference in Excel" on page 487. And Appendix C, "Function Reference," lists every function available in Excel, along with the basic information you need to put each one to use, and includes cross-references to any information available in this and other chapters.

For more information, see Chapter 15, "Formatting and Calculating Date and Time"; Chapter 16, "Functions for Financial Analysis"; and Chapter 17, "Functions for Analyzing Statistics."