This program is organized to raise qualified Data analyst with theability to analyse Financial, Economic, Banking, Business and Accounting data for Management decisions taking. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. This program will walk you through the entire data analysis process, which includes: Posing a question; Wrangling your data into a format you can use and fixing any problems with it; Exploring the data, finding patterns in it, and building your intuition about it; Drawing conclusions and/or making predictions and Communicating your findings.


This Program is Organized for Accountants, Financial controllers, Financial Managers, Business analysts, financial analysts, Business Owners and Entrepreneurs, Individuals for personal finance, Business development managers, SMEs Advisers, Master’s Degree and PHD Students.




Course Outline

Section 1 Advanced worksheet Functions

  • Introduction
  • Understanding excel interface;
  • Work with ribbons;
  • Most powerful excel dialogue boxes;
  • 20 hottest excel shortcuts.


Section 2 Data Separation and Data Joining

2.1.      Flash Fill and Auto

2.2.      Delimiters

2.3.      Ampersand

2.4.      Concatenate


Section 3 Cell Reference

3.1.      Relative Cell Reference

3.2.      Absolute Cell Reference

3.3.      Mixed Cell Reference


Section 4 Conditional & Logical Functions

4.1.      Using logical functions

4.2.      Using If and Nested IF Function


Section 5 What-if Analysis 

5.1.      Scenario Manager

5.2.      Goal Seek

5.3.      Solver for Goal Seek


Section 6 Pivot Tables and Pivot Charts

6.1.      Using the PivotTable Wizard

6.2.      Using Pivotable and Subtotal

7.3.      Using Calculated Field

6.4.      Using Timeline for Filtering Report

6.5.      Creating Pivot Charts

6.6.      Using Slicers to manipulate PivotTables


Section 7 working with Large Data

7.1.      3D Formular (sum)

7.2.      Data Consolidation


Section 8 Lookups functions

8.1.      The VLOOKUP functions

8.2.      The HLOOKUP function

8.3.      INDEX and MATCH function


Section 9 Loan Repayment Schedule

9.1.      Calculating Monthly Payment with PMT function

9.2.      Calculating Payment on Principal with PPMT function

9.3.      Calculating payment on Loan Interest with IPMT function


Section 10 Sorting and Filtering

10.1     Using of advanced sorting and filtering

10.2.    Using Text and Number Filter


Section 11 Advanced list management

11.1.    Using data validation

11.2.    Setting criteria for entry of text, values and dates

11.3.    Creating a dropdown list


Section 12 Auditing Formular

12.1          Auditing Features




In today’s scenario of economic unpredictability and random upheavals in trade and commerce, Financial Modelling has become an important skill to have.It is the most widely sought-after skills by Accountants, Bankers and finance Managers in the World today. It is the art of building a model to depict financial statements and investment analysis using Microsoft Excel. This helps to arrive at optimal business solutions by analysing various parameters. Financial models can be used to represent the performance of a business, a project or any other investment. In today’s world, all decisions made are based on quantitative analysis and information. This is why Accountants,Bankers, Investment Business Analyst, Equity Research Analysts, and FundManagers find Financial Modelling indispensable.


This Program is Organized for Financial Modellers, Consultants, Accountants, Financial controllers, Financial Managers, Business analysts, financial analysts, Business Owners and Entrepreneurs, Individuals for personal finance, Business development managers, SMEs Advisers, Master’s Degree and PHD Students.


Course Outline

  1. Fundamentals of Financial Modelling
  • Financial Statements Basics
  • Fundamentals of Financial Modelling


    2. Mastering Financial Analysis 

  • Building a Financial Ratio Database in Excel
  • Practical Modelling: The Cost-Volume-Profit Relationship
  • Measuring and Improving Return on Investment
  • Measuring and Improving Asset Management Efficiency
  • Measuring and Managing Capital Structure and Risk
  • Practical Modelling: The Effect of Gearing on Shareholders’ Earnings


     3. Financial Projection:

  • Introduction of Spin button and combo box for projection


     4.  Financial Planning:

  • Modelling Income Statement,
  • Balance Sheet, cash flow,
  • Financial ratios,
  • financial statement forecasting


     5. Improving Financial Forecasting 

  • Practical Modelling: Using Excel Statistical Analysis Tools
  • Avoiding Common Forecasting Problems
  • Using Moving Averages to Analyze Time Series Data
  • Using Linear Regression for Sales Trend Analysis
  • Using Excel Solver to Minimize Forecasting Error
  • Using Regression and Correlation to Forecast Costs
  • Practical Modelling: Cash Flow Forecasting


    6. Financial Models to Improve Investment Decision-making 

Principles of Capital Investment Decision-making

  • Sources and Cost of Business Finance
  • Investment Appraisal techniques e.g (NPV, IRR, PBP)
  • Practical Modelling: Using Excel Discounted Cash Flow Tools (DCF)
  • Practical Modelling: Capital Investment Analysis
  • Essentials of Business Valuation
  • Practical Modelling: Business Valuation Based on Shareholder Value Added


      7. Time Value of Money:

  • PV and FV of Annuity; (Single and Multiple Cash flow),
  • Amortization;(Constant and general Discount rate),
  • Sensitivity analysis.


     8. Managing Risk and Uncertainty 

  • Identifying and Analyzing Business Risk
  • Probability Based Approach to Decision-making
  • Monte Carlo Simulation
  • Sensitivity Analysis and “what-if”Forecasting
  • Identifying the Key Drivers of Financial Performance
  • Practical Modelling: Key Driver “what-if”Forecast


     9. Valuation: Stock and Bond valuation with sensitivity analysis using spin button.

× How can I help you?