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 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.
