- Tutor is available to students
Financial Modelling Master
Advanced Diploma in Financial Modelling using Excel and VBA accredited by ANSI and CPD
LEORON Professional Development Institute
Summary
Overview
The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications. However, as a result of the so called ‘95/5’ rule it can be concluded that 95% of Excel users probably only use a mere 5% of the program’s power. Most users know that they could be getting more out of Excel especially by using VBA which would result in them being able to build more flexible, dynamic and professional models. Unfortunately, this aspect of Excel and VBA often appears to be complex and intimidating.
CPD
Description
This intensive 5 day workshop starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customize applications that would be impossible to achieve with suboptimal models. Every section is followed by a direct application related to the financial markets and financial issues.
The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background. Delegates will need some basic knowledge of Excel but not of professional modelling or programming.
Course Outline includes:
Day 1 - Design principles, exploring excel functions, helpful starting hints, 40 functions of a financial modeller
Day 2 - Financial functions, modelling financial statements and KPI's
Day 3 - Optimisation solutions, pivot tables and power pivot extensions
Day 4 - Monte Carlo simulation using Crystal Ball, introduction to VBA and loops
Day 5 - Building custom new functions using VBA
Who is this course for?
Financial Analysts, accountants, risk managers, investment bankers, auditors, Directors and anyone involved in planning, forecasting or using Excel
Requirements
Basic knowledge of Excel
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.