Chapter 3: Formulas and Functions for Crunching Numbers

In This Chapter

arrow.png Constructing a formula

arrow.png Using cell ranges in formulas

arrow.png Naming cell ranges

arrow.png Referring to cells in other worksheets

arrow.png Copying formulas to other columns and rows

arrow.png Preventing errors in formulas

arrow.png Using functions in formulas

Formulas are where it’s at as far as Excel is concerned. After you know how to construct formulas, and constructing them is pretty easy, you can put Excel to work. You can make the numbers speak to you. You can turn a bunch of unruly numbers into meaningful figures and statistics.

This chapter explains what a formula is, how to enter a formula, and how to enter a formula quickly. You also discover how to copy formulas from cell to cell and how to keep formula errors from creeping into your workbooks. Finally, ...

Get Office 2013 All-In-One For Dummies 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.

Start your free trial