Excel provides numerous built-in features and add-ins to streamline the development of sophisticated financial models that incorporate What-If Analysis using Scenarios, Solver, or Data Tables. Additionally, you can easily generate and customize forecasts and trend projections using Excel's Forecast functions. The course also covers the Excel Data Model, an advanced feature that enables you to work with massive datasets within Excel's familiar interface.
Target Student:
This course serves individuals who are responsible for developing financial forecasts and conducting what-if analysis in Excel.
Prerequisites:
Introduction to Excel course or equivalent skills, plus a working understanding of forecasting and what-if analysis concepts.
Course Outline:
Forecasting
- Using the Forecast Sheet
- Modifying Options
- Using Forecast Functions
Using the Quick Analysis Tool
- Formatting Options
- Creating Charts
- Applying Totals
- Creating Tables
- Adding Sparklines
Using What-If Analysis
- Working with Scenarios
- Creating Data Tables
- Using Goal Seek
Using Solver
- Adding the Solver Add-in
- Define a Problem Using Solver
- Solving a Problem
- Solver for Capital Budgeting
- Solver for Financial Planning
- Solver to Determine Optimal Product Mix
- Perform What-If Analysis with the Solver Tool
Gathering Data
- Using the Power Query Editor
- Appending Data
- Merging Data
- Transforming Data
Using the Excel Data Model
- Viewing a Data Model
- Getting Data
- Linking Tables
- Using the Model
- Creating Calculated Columns
- Creating Measures
- Creating KPIs
This course is offered as an instructor-led, remote training program. Participants must be able and willing to attend from home or office with access to a qualified remote instructor. If remote participation is not possible, please do not enroll at this time.
