MODULE 1: MS EXCEL EXPERT

 Excel Essentials & keyboard accelerators

 Basic & advanced Excel functions

 Conditional Formatting, Paste Special

 Using VLOOKUP/HLOOKUP/ Match Index

 Using SUMIF, COUNTIF, AND AVERAGEIF

 DATEDIF, YEAR, YEARFRACE & MONTH

 Index, Search, Choose, offset

 Sensitivity analysis with Data tables

 Pivot table, Charting commonly used

 Dashboards, templates, Macros

MODULE 2: DATA COLLECTION AND MODELING

 Sources for authentic financial data for US, India, China, Germany, and Singapore companies

 Tricks to collect data in the shortest time

 Data collection & Data structuring for model

 Understanding of Financial Reports & their types

 Types of filing 10-K, 10-Q, 8-K, 20-F etc

 Create a Model template for 5 years of historical data for

             Revenue Drivers

             Cost Drivers

             Income statement

             Balance sheet

             Cash flow statement

             Dividend schedule

             Asset Schedule

             Debt Schedule

             Equity Schedule

MODULE 3: FINANCE & ACCOUNTS CONCEPTS UNDERSTANDING

 Finance principles and processes (e.g. financial management concepts, corporate finance activities, etc.)

 General financial concepts and common financial formulas (e.g. time value, opportunity costs, debt structures and covenants, earnings per share, cost of capital, etc.)

 Financial accounting concepts, principles, and practices

 Interactions/ interrelationships of common financial statements

 Basic microeconomics (e.g. marginal costs, pricing, price elasticity of supply and demand, etc.)

 Managerial accounting/reporting and cost accounting concept