O'Reilly logo

Working with Excel by Priscilla Chaffe-Stengel

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

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.

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