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, ...
Get Office 2016 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
