O'Reilly logo

Excel 2019 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1

Building Basic Formulas

IN THIS CHAPTER

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required