OpenCastLabs Consulting

Financial Modeling

This Financial Modeling with Microsoft Excel is taught to finance professional, project managers and mid to senior level managers looking at learning how to build financial models from scratch in Excel. We will teach you all the advanced tools in Excel to help you develop and efficient and unique to your need.
Financial Statement Masters

Advanced Microsoft Excel

The course shows how to analyze and review data extracted from accounting systems and databases in order to prepare management reports and build efficient financial models.

The course studies Excel’s functions and how to use these effectively. The program also shows how to access the Visual Basic Editor and use macros and user defined functions in order to enhance Excel’s functionality. Half a day will also be spent showing attendees how to use Excel’s pivot table functionality. Pivot tables are often poorly understood and yet are the most powerful feature in Excel. A basic pivot table will allow you to summarize 50,000 rows of data in 30 seconds

The course is highly practical: delegates will be exposed to examples (in Microsoft Excel) throughout the 2 days. Note that this course aims to cover a very wide field in a relatively short time and will thus provide more of an overview (with examples) than an in-depth, highly technical course.