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 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.