Chapter 2

Working with Automated Functions in Excel

Microsoft Excel has some powerful quantitative tools built into its capabilities. This chapter will continue the introduction of those that are captured in the Insert Function, mentioned informally in the examples captured in the latter half of Chapter 1. Located near the formula bar in Microsoft Excel is an Insert Function toolbar button: fx . It may appear in different locations on different computer displays, but it works in the same way across different versions of Excel. The button activates a list of categories and, within each category, a sublist of functions. In this chapter, we investigate some of the functions listed under the Statistical, Math & Trig, and Financial categories.

Get Working with Excel 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.