Please fill in the below form to receive our Latest Offers/Discounts for Individuals.
Why Attend This Training Course?
This training course practically applies Excel within a financial framework to explore how forecast financial models can be efficiently created and modified. The efficient use of Excel is key and so the course starts by ensuring the participants can quickly and accurately harness Excel’s tools and functionality. We then apply these skills to the best practice modeling guidelines to build, and then flex, the structure and modules of a forecast model.
What Is The Training Course Methodology?
ACAD Corp’s methodology depends on enabling participants to interact and exchange experiences, explore their competencies and achieve their career aspirations, using forward-thinking training arts, such as Theoretical Lectures, Workshops, Open discussion to exchange opinions and experiences, Scenarios, innovative thinking brainstorming and teamwork, Role-play and simulation, and Audiovisual tools and materials. Participants will receive an agenda including training material as a reference, in addition to some extra notes and booklets. Training material will be presented in English and Arabic.
Who Should Attend This Training Course?
This training course is designed for Professionals in corporates and financial institutions who need to create useful and robust financial models. Attendees should be able to use the basic facilities of Microsoft Excel and have basic accounting knowledge.
What Are The Training Course Objectives?
By the end of this training course, participants will be able to:
Fast, efficient and accurate Excel skills
Design and construct useful and robust financial modeling applications
Efficient financial forecasting techniques
Audit and debug models
Utilize switches and scenario analysis
Create and edit flexible charts
What Is The Training Course Curriculum?
Excel Skills for Modeling
Effective use of keyboard shortcuts
Formatting data professionally
Introduction to Modeling
Effective construction of a model
Objective and structure
The Fundamentals of Model Building
Model set up
Consistent sheet and print set-up
Input vs formulas
Inputting base data
Key Excel functions and tools
IF (and other logicals) with flags
Setting up date flexibility throughout the model using EDATE or EOMONTH
Adding the financial data
Data transfer and links
SUMIF and data validation to extract the relevant data
Breakdown and grouping of accounting elements
Determine drivers of the forecasts
Using Excel tools to identify trends
Effectively creating assumptions for projections
Model diagnostics and checks
Identifying what could go wrong and flagging up any errors
Flexible and user-friendly models
Quick build scenario manager with switch – base case vs downside vs upside
ACAD Training & Consulting uses the power of its network to bring about positive, tangible change. We champion the training courses profession and the interests of individuals, engaged in that profession, for the benefit of all. ACAD Professional Certificates are designed for those who are enthusiastic to challenge themselves to reach the extra mile. Participants who fully attend an APC course and successfully pass the exam on the last training day, will receive an ACAD Professional Certificate (APC). APC are regionally recognized and can be esteemed when applying for more senior roles in Egypt and MENA region.