Recent research reveals that nearly 75% of North American companies use Excel as their primary budgeting and forecasting tool. This course is designed to provide participants with the Excel knowledge and skills necessary to prepare budgets and forecasts more efficiently and with greater accuracy. It provides real world examples developed by accountants for accountants in the following eight major topic areas: collaboration and workbook security, integrating and manipulating data from external sources, consolidating budgetary data, summarizing and analyzing data with PivotTables, pro forma financial statement preparation, forecasting revenues and expenses using linear regression and other techniques, understanding and applying capital budgeting principles, and conducting financial risk analysis. If you use Excel in budgeting and forecasting, you need this course. Participants will have access to sample data files.
Course Information:
CPE Credit: Recommended 8 Hours Business Management and Organization
Instructional delivery method: Group - live demo and discussion using color computer projection - NOT a hands-on course
Prerequisites: Basic Excel Understanding
Program Level: Intermediate
Advanced preparation: None
Designed for: Accountants who use Excel and want to save time and improve the quality of their budgets and forecasts
Who should attend: Users who prepare budgets and forecasts using Excel
Course Highlights:
- Protect documents using password encryption or Information Rights Management
- Track changes in shared workbooks, and merge data from multiple workbooks
- Import or work with data stored in external databases, such as the General Ledger, using ODBC
- Use advanced techniques, such as Text to Columns, Paste Special, and Go-To Special, to cleanup imported data
- Perform advanced data analysis with data tables, subtotals, filters, PivotTables, and PivotCharts
- Use array formulas to round-off in totals and other useful tasks
- Use advanced techniques, such as linear regression or moving averages, to forecast revenues and expenses
- Maximize the value of scarce production resources using Solver
- Make allocations and adjustments for business seasonality
- Manage multiple sets of budget assumptions using Scenario Manager
- Use Custom Views and the Report Manager to automate report printing, and use the Camera to create complex reports from multiple ranges
- Understand the capital budgeting process – calculating the cost of capital and evaluating projects using NPV and IRR
- Perform financial risk analysis using Monte Carlo simulations
- Briefly review some of the top third-party tools to improve the efficiency and effectiveness of the budgeting and forecasting process – Microsoft Forecaster, Budget Maestro, PROPHIX, OutlookSoft, and CCH Pro System fx Profit Driver
- And much more...
Dates & Locations:
| Event Date: |
Location: |
Sponsor Name: |
| 6/3/2008 |
Phoenix, AZ |
Arizona Society of CPAs |
| 6/13/2008 |
Troy, MI |
Michigan Association of CPAs |
| 6/24/2008 |
Natick, MA |
Massachusetts Society of CPAs |
| 7/15/2008 |
Denver, CO |
Colorado Society of CPAs |
| 7/30/2008 |
Hershey, PA |
Pennsylvania Institute of CPAs Foundation |
| 8/5/2008 |
Bellevue, WA |
Washington Society of CPAs |
| 8/26/2008 |
Morrisville, NC |
North Carolina Association of CPAs |
| 9/16/2008 |
Lafayette, LA |
Society of Louisiana CPAs |
| 9/18/2008 |
Oklahoma City, OK |
Oklahoma Society of CPAs |
| 9/22/2008 |
Bloomington, MN |
Minnesota Society of CPAs |
| 10/3/2008 |
Nashville, TN |
Tennessee Society of CPAs |
| 10/17/2008 |
Bethlehem, PA |
Pennsylvania Institute of CPAs Foundation |
| 11/5/2008 |
Malvern, PA |
Pennsylvania Institute of CPAs Foundation |
