In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals.
The course is aimed in building on your existing modelling skills and applying new techniques to better analyse financial data, predict revenues and cost and assess risks to justify business decisions in the most time-efficient and effective way.
WHO SHOULD ATTEND
Business and finance professionals who need to set out business case, analyse the performance of a business or unit, or perform complex manipulations of financial information or data.
By the end of the course, participants will be able to:
Understand the practical usage of most useful functions for Financial Modelling;
Understand the meanings and practical applicability of most Financial functions in Excel;
Understand and fix the most common mistakes in financial formulas;
Use the best techniques of ordering the complicated data;
Use pivot tables to analyse large financial data sets;
Use Macros and Control Forms for data sets;
Calculate NPV and IRR of a project;
Use sensitivity analysis and scenario manager for financial statements;
Write time-efficient codes and user-defined functions;
Understand different methods for automation of reports and time efficiency;
Understand best practises for visualising the outputs;
Build managerial dashboards.
ABOUT THE TRAINER:
Emin Asadov (CQF) – He graduated full higher education program, equivalence of master's degree on Mathematical Methods in Economics of Plekhanov Russian Economic University.
Also he got CQF (Certificate in Quantitative Finance) at Fitch 7 city learning in London.
He had experience as an Analyst of Games Demand Model working on large, multi-sport event - BEGOC (Baku European Games Organizing Committee). Additional, has over 5 year experience of financial risk management, project management and business analytic, mainly involved automation of reports, modeling and analytics. His background is a mix of Finance, Programming and Mathematics.
Training Course Details
Language: Azerbaijani (with English support)
Duration: 20 hours
Start date: 19 September 2015
Course fee: 240 AZN
Included: Spreadsheets, free consultation and coffee break
Venue: Headstart International, World Business Center (14th floor)
For Registration and additional information:
Phone: (+994 12) 597 48 06
Contact person: Shabnam Malikova
Venue: World Business Center, 14th floor, Samad Vurghun Street, Baku, AZ1014