Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Financial Modeling with Advanced Excel Tools

By: IBFCAlliance Limited  

Lagos State, Nigeria

14 - 18 Nov, 2016  5 days

Follow Event


NGN 225,000

This highly practical course will equip participants with the requisite skills needed to develop financial models using excel tools. The course will also expose participants to the techniques needed to develop realistic assumptions required to develop practical financial projects for use in investment appraisal / DCF valuation and calculating cash flow.

Target Audience

Staff in units that prepare and analyze data using large spreadsheets as well as staff who need to build financial models for credit analysis and valuation

Kindly note that all participants are required to bring a laptop with Microsoft Excel installed

Course Overview

  • Creating workbooks with custom settings understanding
  • Data types and data entry working with text
  • Working with dates
  • Worksheets formatting techniques
  • Adjusting worksheet view
  • Conditional formatting
  • Range naming and use of range names
  • Methods of protecting worksheets objects
  • Linking worksheets
  • Excel functions
  • Operators and Operators’ Precedence
  • Understanding Arguments and Arguments
  • Separators
  • Financial Functions
  • Logical Functions
  • Lookup Functions

Data Organization, Manipulation and Presentation

  • Data Structuring
  • Data Filtering / Extracting
  • Data Validation
  • Data Consolidation
  • Data Sub-Totaling
  • Charting
  • Summarizing with Pivot Table

Process Automation

  • Recording and Editing Macros
  • Introducing Visual Basic for Applications (VBA)
  • Assigning Codes to Worksheet Objects

Time Value of Money

  • Present Value
  • Future Value
  • Annuities and Deferred Annuities
  • Uneven Cash Flow Streams

Investment Appraisals

  • Net Present Value
  • Internal Rate of Return
  • Sensitivity Analysis
  • Limiting Factor Analysis
  • Resources Optimization

CASES: Case Studies will be used to enhance participants’ understanding of the subject matter.

IBFCAlliance Limited, 3rd Floor, East Wing, City Hall, Catholic Mission Street, Lagos Island, Lagos Nov 14 - 18 Nov, 2016
NGN 225,000.00
(Convert Currency)


Discount will be offered for more than 3 participants