Unit 14: E8 - Financial Functions and What-If Analysis
Duration of Days: 5
Students will learn about some of the financial functions frequently used in Excel. You will use these functions to analyze potentially changing circumstances with the What-If Analysis tools. What-if analyses allow you to see how the results of formulas change by altering the input values, such as the interest rate used in financial functions.
-Create financial functions
-Create one-variable and two-variable data tables
-Use the What-If Analysis tools to create scenarios
-Adjust input values using Goal Seek
Students will demonstrate learning by completing the following projects:
- R1-R2-Forecast
- A1-A2-Advert
- R3-HQOptions
- A3-RenoCosts
| Lesson # | Lesson Title | Duration of Days |
|---|