15BFT: Budgeting and Forecasting Tools and Techniques
If you have questions about this event, please call us at 952-831-2707.
Thursday, April 23, 2015
8:30am - 4:30pm Central Time
8 CPE (8 technical)
Minnesota Society of CPAs, Bloomington
If your budgeting and forecasting processes consume too much of your time and provide minimal benefit, it's time to turn things around. Get the practical guidance you need to achieve a better return on your budgeting and forecasting activities with time-saving tools and techniques. Learn how to use Excel more effectively for budgeting and forecasting activities and see demonstrations of helpful how-to techniques. Explore other tools such as Budget Maestro, PROPHIX and Host Analytics, and discover how you can get better results when you reduce your dependency on Excel. Find out if this class is right for you. Take the online assessment.
Major subjects
-
How to obtain budget data and collaborate with others using shared workbooks, audit trail, merged workbooks, web-based activities and more
-
Excel techniques for interacting with your accounting system -- Office data connections, importing text files, manipulating imported data, open database connectivity and more
-
Excel how-to's -- use data tables for sensitivity analysis, work with the goal seek function, use solver to maximize scarce resources, work with scenario manager, forecast with regression analysis, analyze risk with Monte Carlo simulations, and more
-
How to use Excel in capital budgeting situations, including methods to compute depreciation and rate of return
-
Shortcomings of Excel-based budgeting and forecasting tools
-
Guidance for working with dedicated budgeting and forecasting software applications to achieve better results in less time
-
Methods for handling budgeting and forecasting risk and uncertainty
Learning objective(s)
-
Understand tools and techniques in Excel and other software applications to improve your budgeting and forecasting processes
Who should take this program?
CPAs, accountants and financial professionals involved with budgeting and forecasting
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$349.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$299.00
|
Standard Nonmember Fee |
$349.00
|