Spreadsheet Skills for Forecasting, Planning and Budgeting

Reed Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Forecasting, planning and budgeting as part of the management accounting function

Business forecasting

A review of some of the modern quantitative methods available including:

smoothing techniques
regression analysis
time series analysis
expected value calculations

Business planning models

A look at available techniques including deterministic, stochastic, and optimising models
Examples used to illustrate techniques will cover Profit and Loss, Balance Sheets, Funds Flow, Cash Flow, Capital Investment Appraisal, etc

Business planning techniques

What-if analysis
Backward iteration
Risk analysis

Budgeting techniques

Producing budgets, actuals, calculating variances, producing year-to-date figures and consolidating reports
When to use multiple sheets and multiple files
Consolidation options

The course uses large screen demonstrations to illustrate the spreadsheet techniques discussed. Spreadsheets are demonstrated using Microsoft Excel, but the course is relevant for Lotus 1-2-3 users and a disk in Lotus 1-2-3 format is available for anyone who requires it.

6 CPD hours (for non-CIMA members)

THIS COURSE IS RUN BY CIMA MASTERCOURSES

What do I get out of it?
Knowledge of a variety of approaches to forecasting, planning and budgeting

- The ability to develop these management tools using a spreadsheet on a personal computer
- Tips on how to combine these techniques to obtain the most effective management information
- An introduction to the use of advanced spreadsheet techniques.
...''

Phone:0800 132 448

School Address:

9 Kingsway, London, WC2B 6XF UK

Jobs & Resumes: London
Houses & Roommates: London

Acquiring and Divesting Unquoted Companies
From Activity-based Costing (ABC) to Activity-based Management
Better Management Reporting, Planning and Control
Corporate Performance Management and Business Intelligence
Corporation tax update
Cost Reduction with Improved Service and Performance: CRISP
Flexible Planning and Rolling Forecasts
Investment Appraisal
Key Management Accounting Techniques
Management Accountancy in Publicly Funded Organisations
Strategic Management Accounting
The Hidden Profit and Loss Account
Transforming the Finance Operation
Conflict Resolution
Customer Service for Credit Control
Managing in a Call Centre
Face To Face Selling
Telesales
Advanced Budgeting

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.