Application of VBA & Advanced Excel to Financial Modeling & Analysis 2015

Application of VBA & Advanced Excel to Financial Modeling & Analysis 2015 is a course that provides knowledge on the use of Excel.

Key Topics

• In-depth knowledge of a wide range of advanced functions in Excel
• Effective, flexible and powerful models using VBA(macros) and advanced Excel
• Highly flexible, robust and transparent models that follow best practice principles
• Modeling situations where the use of VBA would be effective worthwhile
• CONSOLIDATE data from different workbooks
• Solid basis to write VBA code
• Exposure to a wider range of applications in financial modeling
• Alternative methods and best practises in model design
• Variety of options ways to design , structure, layout and build models Portfolio Managers

Who should Attend

Staff involved in Business & Strategic Planning, Planning, Development & Commercial, Budgeting & Forecasting:

• Planning, Development & Commercial Analysts
• Business & Strategic Planners
• Financial Analysts
• Budgeting & Forecasting Staffs
• Risk Managers
• Petroleum Economists
• Business Analysts