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

Inserting Functions

Inserting Functions

The easiest way to locate and insert built-in functions is by clicking the Insert Function button. When you do, the dialog box shown in Figure 13-5 appears.

If you're not sure what function you need, enter a description of what you are trying to do into the Search box. For example, if you enter "I want to know how many cells contain values" and then press Go, the Insert Function dialog box returns a list of recommended functions, similar to the list shown in Figure 13-6. As it turns out, the first function in the list of suggestions fills the bill. If you don't find the function you're looking for, try rewording your query.

Figure 13-6. Ask ...

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