It is well known that many users of Excel working with financial data do not make optimal use of what the Excel package offers.
The emphasis of this course is to transfer key knowledge areas in developing workable Excel models and the use of the advanced Excel 2010 functionality to enable delegates to develop financial models for decision making. The entire course focus is towards orientating the delegate towards making professional decisions using the rich Excel 2010 capability
The program is structured around the advanced features of Microsoft™ Excel 2010.
COURSE SKILL LEVEL
Participants must have been exposed to Microsoft Office 2007 and earlier versions. This is an advanced class which requires intermediate skills in Excel 2007 or 2010
The course utilizes the advanced functions of Excel 2010. Excel has developed substantial functionality without the need to code in VBA. The following advanced Excel skills will be emphasized:
§ The use of all the key Formulae Groups and the construction of nested functions
§ Financial modeling best practices
§ Extensive use of the LOGIC and LOOKUP, INDIRECT and MATCH functions
§ Utilizing the rich functionality in graphing and conditional formatting
§ Pivot Tables and Data Analysis
§ Extensive use of the WHAT IF capability
Charges: Kes 15,500.00
Email: firstname.lastname@example.org for complete course brochure
Call: +254 717 691 006