10. Understanding Functions

Excel is used on 500 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 ToolPak (ATP). Excel 2010 now offers 400 built-in functions. Although this sounds like a tremendous increase, only about seven functions will be of interest to most people:

• Excel 2010 adds the new AGGREGATE function, which is similar to SUBTOTALS but with 19 calculations instead of 11.

• Excel 2007 added the

Get Microsoft Excel 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.