Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of 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 entire spreadsheet.
Creating a Formula
Organizing Formulas with Parenthese
Copying Formulas
Using Functions
Using the AutoSum Command
Using Recently Used Functions
Editing a Formula
Goal Seeking
Creating Multiple Scenarios
Viewing a Scenarios
Viewing Scenarios Summary
Auditing your Formulas
Finding Where Formula Gets Its Data
Data Validation
Organizing Formulas with Parenthese
Copying Formulas
Using Functions
Using the AutoSum Command
Using Recently Used Functions
Editing a Formula
Goal Seeking
Creating Multiple Scenarios
Viewing a Scenarios
Viewing Scenarios Summary
Auditing your Formulas
Finding Where Formula Gets Its Data
Data Validation
No comments:
Post a Comment