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.

• ...

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

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