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.

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.

Request for Proposal

Explore Other Courses

Business Intelligence Training 

Market Analytics

Data Analysis with SPSS – Module I

Data Analysis with SPSS – Module II

Data Analysis with SPSS Module III

Foundation SQL Training

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