Financial Modelling for Planning, Forecasting & Financial Analysis
8,000EGP

Course Features
- Lectures 0
- Quizzes 0
- Duration 24 hours
- Language ENG-AR
- Students 0
- Assessments Yes
Financial modelling is extremely useful for planning and forecasting to make business decisions as well as performing financial analysis. In this practical program, participants will learn practical skills to construct robust financial models that are properly structured.
Excel is the de facto modelling language today, so in order to get the best out of a model a modeler would be wise to have a good understanding of the functions in Excel, what they do, and where they can be used in a financial model Delegates will be taken through various features & functions of Excel
INTRODUCTION
MODELLING TIPS, TOOLS & ROUTINES
MAINTAINING THE INTEGRITY OF THE MODEL
USEFUL MODELLING FUNCTIONS
DATABASE TECHNIQUES
CONSOLIDATIONS
TABLES OF RESULTS
SETTING UP “CONTROLS”
Practical Exercise:
At the program completion participants will be able to:
Business owners, directors, managers, commercial managers, and professionals (financial accountants, business analysts, finance managers, financial analysts, management accountants, financial controllers and budget managers) who uses financial models for business decisions, financial planning and analysis.
Message modal