O'Reilly logo

Office 2019 For Dummies by Wallace Wang

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 9

Playing with Formulas

IN THIS CHAPTER

check Creating, using, and editing formulas

check Conditional formatting

check Manipulating data with Goal Seeking

check Creating multiple scenarios

check Auditing formulas

check Validating data

What makes Excel useful is its capability to manipulate data by using formulas. Formulas can be as simple as adding two or more numbers or as complicated as calculating data from other formulas so that changes in a single cell can ripple throughout an entire spreadsheet.

Creating a Formula

Formulas consist of three crucial bits of information:

  • An equal sign (=)
  • One or more cell references
  • The type of calculation to do on the data (addition, subtraction, and so on)

technicalstuff The equal sign (=) simply tells Excel not to treat the formula as text but as instructions for calculating something. ...

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