ADVANCED EXCEL & FINANCIAL MODELLING TRAINING

Nasimoire Technologies
Offline study mode
Block A, 1st Floor, 334 Ikorodu Road, Idiroko busstop, Anthony Lagos State.
2 days
Feb 22 - Feb 29 2020

Course Description

No matter what professional field you are in these days, excel is considered as the holy grail of everything. To feed the inputs, to analyze any data, to forecast any trend or to build up any technical models, you need a thorough understanding of excel without which you won’t be able to make your mark even if you have other required skills for the domain. 

Microsoft Excel is one of the most popular tools to integrate financial models in an effective and secure manner. It is a primary financial management tool that has the ability to identify and track all the connecting points that help to manage enormous volumes of calculations involved in building a durable financial model. 

Financial Modeling skills are essential for finance and commerce professionals, particularly for seasoned executives. It helps users gain a firm understanding of financial modeling techniques to succeed in today’s competitive environment. 

Learn, apply and analyse financial models with Excel with competency and expertise after our three day course in FME. Get practical, hands-on training in powerful Excel tools that will help create financial models facilitating greater analytical accuracy. Build a solid foundation in Excel techniques that can be used to manipulate large datasets of financial information. 

Delivered using a combination of lectures and practice problems and online training, our course will enable you to apply your learning to build useful, accurate, and robust financial models with ease. 


Training Date
Saturday 22nd and 29th February 2020

Who will benefit the most from this course? 
Following professionals will benefit the most from this course 
• Software Analysts 
• Finance Managers 
• Risk Managers 
• Chief Financial Officer 
• Credit Managers 
• Buyout Specialists 
• Financial Analysts 
• Financial Controllers 
Note: You are requested to carry a laptop for this training. 




N.B: NO REFUND (Terms and Conditions Apply) 

Course Outline

Module 1

  • Introduction to Excel Spreadsheet
  • Understanding Cell Referencing
  • Data Extraction: Advanced Sorting & Filtering, Creating Data Extraction
  • Using Vlookup, HLookup, Index and Match Functions
  • Data Validation
  • Conditional logical statements for business analysis
  • Consolidating Multiple Sheets: Methods for automatically consolidating data from different sheet
  • Building Financial Functions into Ms-Excel (PMT, FV, PV, PPMT, IPMT etc) 


Module 2

  • Importing & Exporting Data in Ms-Excel
  • Loan Amortization Schedule
  • Sensitivity Analysis Testing Using Data Table
  • Pivot Table: Introduction to Pivot Tables and Pivot Charts
  • What-If Analysis (Goal Seek, Scenario Manager, Data Table) 


Module 3

  • Preparation of Balance Sheet, Income and Cash Flow statements
  • Ratio Analysis
  • Du Point Analysis
  • Financial Statement Analysis
  • Valuation of Companies 
  • Valuation of IPOs
  • Valuation of Merger & Acquisitions
  • Valuation of Bonds
  • Valuation of Equity
  • Leverage Buyout Analysis (LBOs) 

Career Outcomes

Become proficient in the use of Microsoft Excel

How To Enroll

Fill in your details on the enquiry form, proceed to pay online by clicking on the purchase button. If you wish to make an online transfer or cash deposit to the bank, please send a mail to [email protected] requesting for account details.

Price: NGN 50,000 30,000

Similar Courses

Clarionttech Services
Offline study mode
3 days
Lagos
SCILS Management Centre
Offline study mode
1 day
Lagos

Request a Call

Request a consultant to call you