Chapter 22. Understanding Functions

In this chapter

Working with Functions 432

Getting Help with Excel Functions 436

Using AutoSum 438

Using the New General-Purpose Functions in Excel 2007 443

Using the New CUBE Functions in Excel 2007 447

Using the Former ATP Functions 448

The Function Reference Chapters 449

Excel is used on 400 million desktops around the world. People from all careers use Excel, as do many home users who use Excel’s powerful features to track their finances, investments, and more. Part of Excel’s versatility is its wide range of built-in functions.

Excel 2003 offered 255 built-in functions. Another 89 functions shipped with Excel but were available only to people who installed the Analysis Toolpack (ATP). Excel 2007 offers ...

Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.