Chapter 9
Playing with Formulas
In This Chapter
Creating formulas
Using functions
Editing formulas
Conditional formatting
Manipulating data with Goal Seeking
Creating multiple scenarios
Auditing formulas
Validating data
What makes Excel useful is its ability to manipulate data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as calculating a second-order differential equation.
Formulas use data, stored in other cells, to calculate a new result that appears in another cell. To create even more complicated spreadsheets, you can even make a formula use data from other formulas so that changes in a single cell can ripple throughout an ...
Get Office 2016 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.