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

11. Using Everyday Functions: Math, Date and Time, and Text Functions

Excel offers many functions for dealing with basic math, dates and times, and text. This chapter describes the functions found under the Date & Time icon and the Math & Trig icon on the Formulas tab.

A few of the new functions in Excel 2010 fall into this chapter:

AGGREGATEProvides a way to ignore error values, other subtotals, and/or filtered rows in 17 other functions. Whereas SUBTOTAL provided a way to ignore rows hidden in a filter for 11 functions, the AGGREGATE function adds median, mode, percentile, large, small, and quartile functions. Also, the ability to use an array gives you the possibility of extending the SUMIFS concept to min, max, median, and so on.

• ...

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