O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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 16. Functions for Financial Analysis

The financial functions that are provided with Microsoft Excel allow you to perform common business calculations, such as net present value and future value, without building long and complex formulas. These functions are the heart of spreadsheets—the word "spreadsheet" itself refers to the seemingly antiquated system of using special grid paper to track financial information. Functions have taken the place of the old 10-key calculator sequences ("algorithms") used by accounting professionals before computers revolutionized the discipline.

Note

Many of the financial functions discussed in this chapter are included in the Analysis ToolPak ...

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