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.
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.
Explore Other Courses
OpenCastLabs Consulting | OCL Learning
P.O Box 56404 00200 Nairobi, Kenya
1st Floor, Plessey House – Uhuru Highway
Tel: 020 234 7622/0722831259
Explore our Online Learning and Certification Website