O'Reilly logo

Office 2016 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

13. Getting the Most from Formulas and Functions

Excel’s real power lies in its ability to do calculations. We enter values into Excel to have those values acted upon by formulas or functions; Excel is all about answers, and the answers are provided by the results of the various formulas and functions in a sheet. Whether you are a biologist using statistical functions to enumerate a population study of snowy egrets in the Hudson River valley or a financial maven tracking investments, Excel provides all the tools you need to do the math.

In this chapter, we look at the basics of building simple formulas and taking advantage of Excel’s huge library of built-in formulas—functions—to do calculations. We explore a number of different function categories, ...

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