Spreadsheet Skills for Planning, Forecasting & Budgeting
Date:
Length:
Type:
Fees:
City:
Available Dates
Dates in Other Venues
Course Details
- Introduction
- Objective
- Who should attend
- Course Location
Planning, Forecasting & Budgeting are the most important functions in business. Performed properly they can lead to exceptional success. Yet many people do not use the tools available to them to their best advantage. In this course, we will leverage the power of Excel to demonstrate how to improve your forecasting, planning, and budgeting. By developing better spreadsheets & models, planning is more accurate, forecasting is more precise & budgeting is more attainable. And the time to develop these is dramatically reduced.
Spreadsheet Skills for Planning, Forecasting & Budgeting training course will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilised to generate business plans and operating budgets with the use of Excel as it is used in practice. The applications will be focused on three crucial aspects of business and financial management - strategic planning, intelligent forecasting, and realistic budgeting
Delegates will learn how accessible the power of Excel is to provide realistic forecasts and prepare flexible budgets. The impact on efficiency in planning and control and therefore return on investment for companies and/or divisions will be startling.
Course Outline
Introduction to Spreadsheets using Excel
- The power of Excel for building financial models
- The Ribbons of Excel with their commands and functions
- Using formulae: Copying, anchoring, and special pasting
- Using functions: financial, statistical, and mathematical
- Review of the financial objectives of business: ROI, ROA, ROE
- Overview of Financial Statements