Chapter 1: Building Basic Formulas

In This Chapter

arrow.png Summing data ranges with AutoSum

arrow.png Creating simple formulas with operators

arrow.png Understanding the operators and their priority in the formula

arrow.png Using the Insert Function button on the Formula bar

arrow.png Copying formulas and changing the type of cell references

arrow.png Building array formulas

arrow.png Using range names in formulas

arrow.png Creating linking formulas that bring values forward

arrow.png Controlling formula recalculation

arrow.png Dealing with circular references in formulas

Formulas, ...

Get Excel 2013 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.