Spreadsheet Skills for Planning, Forecasting & Budgeting
15-01-2024 - 19-01-2024 | 3300 USD | Abu Dhabi |
---|
This workshop will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilized to generate business plans and operating budgets with the use 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.
This course will feature:
By the end of this course, participants will be able to:
This course is aimed at professionals who contribute to financial decision making. Participants with qualifications and or experience in accounting and finance will benefit from the new focus on building models and applying scenario's in financial planning.
This course is suitable to a wide range of professionals but will greatly benefit:
Case Study: Building a Quick Access Toolbar in Excel® and applying it to the analysis of financial statements of a division.
Case Study: Preparing a planning model and subjecting it to a range of sensitivity analysis in a manufacturing environment.
Case Study: Applying the forecasting functions in Excel® to past data and building a model offering various scenario's
Case Study: Building budget based on assumptions - Operating Budget, Cash Budget & Capital Budget
Case Study: Building an integrated planning, forecasting & budgeting model
A variety of methodologies will be used during the course that includes:
· (30%) Based on Case Studies
· (30%) Techniques
· (30%) Role Play
· (10%) Concepts
· Pre-test and Post-test
· Variety of Learning Methods
· Lectures
· Case Studies and Self Questionaires
· Group Work
· Discussion
· Presentation
This rate includes participant’s manual, Hand-Outs, buffet lunch, coffee/tea on arrival, morning & afternoon of each day.
Daily Course Timings:
08:00 - 08:20 Morning Coffee / Tea
08:20 - 10:00 First Session
10:00 - 10:20 Coffee / Tea / Snacks
10:20 - 12:20 Second Session
12:20 - 13:30 Lunch Break & Prayer Break
13:30 - 15:00 Last Session