Financial Modeling in Excel Training

This course is intended to equip the trainees with knowledge, skills and attitudes that will enable them to perform efficiently in this technological ,fast moving information age.

Module 1: Advanced Excel  
TOPICDURATION
Advanced formatting1 Hrs
Dynamic Named Ranges1 Hrs
SUMPRODUCT() calculations0.5 Hrs
Combo Box for interactive scenarios1 Hrs
Choose function as a lookup technique0.5 Hrs
Modeling Loans
Calculating instalments3 Hrs
Calculating loan balances
Converting flat rates to reducing balance rates
Converting reducing balance rates to flat rates
Module 2. Advanced Excel for Financial Modelers  
TOPICDURATION
Conditional Formatting1 Hrs
Data Analysis and Charting1 Hrs
Manipulating Pivot Charts0.5 Hrs
Data Validation0.5 Hrs
Advanced Formulas
Financial Formulas
PV and FV1 Hrs
NPV and IRR
Logical Formulas
IF Statements
Nested Ifs3 Hrs
Error handling using IFERROR
AND & OR Statements
Text Formulas
CONCATENATE
FIND v/s SEARCH1 Hrs
LEFT, RIGHT, MID
UPPER, PROPER, LOWER
Lookup Formulas
VLOOKUP & HLOOKUP2 Hrs
INDEX & MATCH
Module 3. Financial Modeling in Excel 
TopicDURATION
Dynamic & Integrated Financial Model design0.5 Hrs
Financial Modeling GAAPs0.5 Hrs
Determining defensible assumptions on business drivers0.5 Hrs
Circular references & iterative calculations1 Hrs
Preparing P&L, Balance Sheet & Cash flow statement from scratch3 Hrs
Equity & Enterprise valuation process1 Hrs
Discounted Cash Flows, Free Cash Flows to the Firm & Free Cash Flows to Equity1 Hrs
Relative valuation techniques1 Hrs
Terminal Value and Terminal Growth Rates0.5 Hrs
CAPM Model and The Discounting Rate1 Hrs
Financial Statement Analysis2 Hrs
Operating Leverage0.5 Hrs
Cash flow for C-Suite performance appraisals1 Hrs
DuPont Analysis1 Hrs
Sensitivity Analysis using Data Tables0.5 Hrs

Contact us  today or submit an inquiry online.

When it comes to training professionals related to Accounting, Finance, Business Management, ICT,…….. This is the Place…This is the college.

Kevin Nzioki
Pastor, Church of Jesus Christ
Registration & enrollment for JAN-APR 2024 Semester is ongoing for All Courses & Modes (FULL TIME/ EVENING / EARLY MORNING (WEEKEND ONLY) Read More