K2's Excel Tips & Tools for Better Budgets
01.26.23 12:00PM –
01.26.23 1:53PM
Details
Credits
2.00
Level
Intermediate
Fees
Member Fee
$79.00
Nonmember Fee
$109.00
Want to register?
General Info
DescriptionExcel is the de facto budgeting and forecasting tool for most professionals, yet many don't leverage its numerous built-in tools. Learn Excel features such as FORECAST, FORECAST.ETS, TREND, Forecast Sheets, XNPV, and XIRR. Additionally, techniques to manage what-if analysis using Scenario Manager, Solver, and the value of performing Monte Carlo simulations. If you use Excel for budgeting and forecasting, you can't afford to miss this session.
Highlights
- Budgeting and forecasting-centric features in Excel
- Excel’s capital budgeting functions
- Using tools such as Scenario Manager, Solver, and Forecast Sheets to solve common budgeting problems
Objectives
Designed For
- 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
Accounting, financial, and other business professionals who want to learn how to use many of the budgeting and forecasting-centric features found in Excel 2016 and newer
Vendor
ACPEN
You must be logged in to add items to your cart.
If you don't have a login you may create one for free, or save a bundle by becoming a member.