OpenCastLabs Consulting
Financial Modeling with Excel Training
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
Business Intelligence Training
Data Analysis with SPSS – Module I
Data Analysis with SPSS – Module II
Data Analysis with SPSS Module III
SQL SERVER REPORTING SERVICES 2012 FOR REPORT WRITERS
Contact us:
OpenCastLabs Consulting | OCL Learning
P.O Box 56404 00200 Nairobi, Kenya
1st Floor, Plessey House – Uhuru Highway
Websites: www.ocl.co.ke | www.opencastlabs.co.ke
Email: info@ocl.co.ke
Tel: 020 234 7622/0722831259
Explore our Online Learning and Certification Website