Excel is the de facto budgeting and forecasting tool for most professionals, yet many who use Excel for these tasks do not take advantage of the numerous built-in tools available.

Among other topics in this session, you will learn how to work with Excel features such as FORECAST, FORECAST.ETS, TREND, Forecast Sheets, XNPV, and XIRR. Additionally, you will learn better ways to manage what-if analysis using Scenario Manager, Solver, and the value of performing Monte Carlo simulations. In short, if you use Excel for budgeting and forecasting, you can't afford to miss this session!

Agenda / Covered Topics

• List key budgeting and forecasting-centric features in Excel
• Differentiate between Excel's capital budgeting functions
• Utilize Scenario Manager to manage different sets of budget assumptions
• Solve complex, multi-variable equations with Excel's Solver add-in
• Create Monte Carlo simulations to model risk in budgets and forecasts
• Computer Software & Applications

Included Materials

All ACPEN courses include handouts that are available to download. Handouts typically include a version of the slides used by the presenter, as well as a full course manual or other materials.

How To Access Your Course And The Accompanying Materials

You will receive an email directly from ACPEN with instructions for accessing your course and any accompanying materials.

How To Get Your CPE Credits

In order to obtain CPE credit for viewing ACPEN webcasts, you must view the course during the scheduled date and time. Throughout the program, you will be prompted to save three attendance codes per hour. At the conclusion of the program, your CPE Certificate will be issued assuming all attendance codes have been saved and submitted. Detailed instructions for this process are included in the course introduction and in written form as part of course materials.