Excel Tips and Tools for Better Budgets

Excel Tips and Tools for Better Budgets
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.



NOTE: Course login details are normally sent to registrants within one week from date of registration.

KE22230211

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!

LEARNING OBJECTIVES
Upon completing this course, you should be able to:

  • 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

PREREQUISITE
Fundamental knowledge of budgeting and Microsoft Office Excel
Program Level: Intermediate 
Advance Preparation: None 

WHO WILL BENEFIT
Business professionals who are seeking to become more efficient and effective in budgeting processes. The program focuses on Excel for Windows, but many of the features can be found in Excel for Mac.

CPD: 2 Hours
When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand