O'Reilly logo

Office 2013 In Depth by Joe Habraken

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

Choosing the Right Function

Excel functions provide you with ready-made formulas for just about any type of calculation you want to undertake. Statistical, Financial, and Math & Trig are all examples of function categories that supply functions that do calculations. Statistical functions, such as COUNT and AVERAGE, are designed for doing statistical analysis. Financial functions, such as PMT and FV, compute the monthly payment on a car or house or the return on an investment, respectively. Math & Trig functions, such as SINE and COS, return the sine or cosine of an angle, respectively (sorry for dredging up any potential trigonometry nightmares).

There are also functions that do not actually do what we typically think of as calculations, meaning ...

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