O'Reilly logo

Microsoft® Office Excel® 2007 VISUAL™ Quick Tips by Denise Etheridge

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 Formulas and Functions

Excel provides you with tools for storing numbers and other kinds of information. However, the real power of Excel comes from manipulating all of this information. There are more than 300 functions built into Excel. They enable you to perform tasks of every kind, from adding numbers to calculating the internal rate of return for an investment.

You can think of a function as a black box. You put your information into the box, and out come the results. Each bit of information you provide is called an argument. Excel's Function Wizard provides guidance for every function and for every argument. A formula consists of an equal sign, one or more functions, their arguments, operators such as the division ...

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