Chapter 1
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
Copying formulas and changing the type of cell references
Building array formulas
Using names and variables in formulas
Creating linking formulas that bring values forward
Controlling formula recalculation
Dealing with circular references in formulas
You can, if you want, use Excel only to store data. Using the tables that you find out about in Book 6, you can turn Excel into a competent database management ...
Get Excel 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.
