Forecasting with Excel's Powerful Sensitivity Tools
Author: Miles Hutchinson
CPE Credit: |
2 hours for CPAs |
Attend this briefing and demonstration on Excel to unleash its powerful sensitivity tools. Get the full power out of your financial models. Improve the design of your models to take advantage of these tools in just 2 hours.
Publication Date: May 2025
Designed For
Financial Analysts, Business Analysts, Information Reporting Officers, Tax Managers, Compliance Officers, Compliance Managers, CFOs, Controllers, Accounting Managers, Auditors, Risk Managers
Topics Covered
- Historical reporting to future vision - enter forecasting and modeling
- Roll of Excel in Forecasting
- Goal Seek
- Scroll Bars
- Data Tables
- Scenario Manager
- Conditional Formatting
Learning Objectives
- Recognize the 20 rules of effective model design
- Identify best practices for designing efficient forecasting models
- Identify how to apply scroll bars, goal seek, data tables, and scenario manager to your models
- Identify data tables with one or two-inputs to deliver an array of outcomes from your model
- Identify the first stage on the journey to budgeting and forecasting
- Identify the maximum integer value that can be used in an Excel Scroll Bar
Level
Intermediate
Instructional Method
Self-Study
NASBA Field of Study
Computer Software & Applications (2 hours)
Program Prerequisites
Basic Understanding of Excel Tools
Advance Preparation
None