IN THIS CHAPTER
Creating, using, and editing formulas
Manipulating data with Goal Seeking
Creating multiple scenarios
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.
Formulas consist of three crucial bits of information: