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
