Advance Financial Modelling using Microsoft Excel & VBA

Projects and/or businesses cannot be successful without accurate and timely project cost estimating. Estimating is a practice that occurs throughout the project/ business management lifecycle, and so it must be done effectively and efficiently. In today's firms, cost analysis and budgeting are essential components of management. Companies nowadays are recommended to align their strategies with precise systems of resource allocation and performance evaluation if they desire to remain competitive. In keeping with this, planning, cost tracking, control, and reduction are crucial tasks that businesses must carry out and keep an eye on while they undertake their most crucial aspects.

Course Overview

The ability to create and understand financial models is one of the most valuable 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 a wide range of financial models and other applications. However, based on the so-called ’95/5′ rule, it can be concluded that 95% of Excel users probably only use 5% of the program’s power. Most users are aware that they could be getting more out of Excel, particularly by using VBA, which would allow them to create more flexible, dynamic, and professional models. Unfortunately, this feature of Excel and VBA appears to be difficult and intimidating. The course will emphasize some key financial concepts that will aid in the development of robust models. It is intended to provide you with the information you require without requiring you to wade through lengthy explanations and technical background. Delegates will need some basic Excel knowledge but no professional modelling or programming experience.

What you’ll learn
  • Develop a thorough mastery of Excel and VBA software(s) for financial modelling purposes.
  • Apply the needed tools to build models that are less time and effort-consuming.
  • Apply the best practices in modelling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement.
  • implement over 1 million rows of data in seconds with Power Pivot Data Mashup and Data Exploration.
  • Construct the way how to get from the basics of VBA to building a loan amortization table using a VBA macro.
Duration & Fees
  • Regular – 10 Weeks – ₦170,000
  • Fast-Track – 8 Weeks – ₦255,000
Program Dates
  • August – October, 2024
  • October – December, 2024
  • February – April, 2025
  • May – July, 2025