Chapter 1

Building Basic Formulas


check Summing data ranges with AutoSum

check Creating simple formulas with operators

check Understanding the operators and their priority in the formula

check Using the Insert Function button on the Formula bar

check Copying formulas and changing the type of cell references

check Building array formulas

check Using range names in formulas

check Creating linking formulas that bring values forward

check Controlling formula recalculation

check Dealing with circular references in formulas

Formulas, ...

Get Excel 2019 All-in-One For Dummies now with O’Reilly online learning.

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