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