Students will explore financial modeling and scenario analysis techniques using spreadsheet software.
What students will learn
- Define financial modeling in the context of spreadsheet applications.
- Explain the purpose of What-If Analysis tools including Scenario Manager and Goal Seek.
- Perform simple financial projections using cell referencing and mathematical formulas.
- Apply Scenario Manager to compare different budget or investment outcomes.
- Demonstrate how to use Goal Seek to solve for a target value in a financial model.
Already available for this topic
Lesson note
Sign up free to generate these and download them as PDF, Word or PowerPoint.
Start your free 14-day trialLooking for a different topic? Browse all Digital Technologies topics or the full library.