Building Basic Formulas
IN THIS CHAPTER
Summing data ranges with AutoSum
Creating simple formulas with operators
Understanding the operators and their priority in the formula
Using the Insert Function button on the Formula bar
Copying formulas and changing the type of cell references
Building array formulas
Using range names in formulas
Creating linking formulas that bring values forward
Controlling formula recalculation
Dealing with circular references in 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.