Training Courses
 Finance

Spreadsheet Skills for Forecasting, Planning & Budgeting

Planning and Budgeting

This course will show you how to develop spreadsheet models to produce a forecast, which can then be used to produce a business plan and operating budgets, dramatically reducing the time required to produce this information.

The course will concentrate on What-if analysis to find the key factors for management to monitor. Goal seeking, sensitivity analysis and risk models are advanced techniques which are also covered.

The course uses large screen demonstrations and spreadsheets are demonstrated in Microsoft Excel.

Who is this course suitable for?

For Managers, section heads and senior personnel responsible for departmental forecasts, plans and budgets; Accountants and Business Advisors who need to advise or comment on business forecast, plans or budgets and Financial Advisors.

Programme Topic Areas

N
Overview of the accounting function
N
Planning as part of the management accounting function within your business
N
Basic financial awareness overview – the use of basic financial statements within the business, covering profit and loss, balance sheets, cash flow, funds flow and capital investment appraisal
N
Business planning models
N
What if analysis
N
Risk analysis
N
Budgeting techniques – producing budgets, actuals, calculating variances, year to date figures, consolidating reports, lookup multiple sheets multiple files
N
Variance analysis
N

Summary & action plans agreed

Interested in this course?

Click on the link button below to submit an enquiry.

x Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security