O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required