Application of VBA & Advanced Excel to Financial Modeling & Analysis 2015 is a course that provides knowledge on the use of Excel.
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
