Course Modules:

Institute Support [25 hours]

Part I: Learn Basics [5 hours] – Video Recorded

  • Data navigation
  • Formatting
  • Arithmetic
  • Shortcut Keys
  • Basic math functions
  • Rounding
  • Counting
  • Text functions
  • Sort, Filter, Split, Freeze etc.

Part II: Learn Advanced Concepts [10 hours] – Online Live

  • Financial & Statistical function
  • Date, time and Logical functions
  • Using important ribbon Interface features
  • Vlookup, Hlookup, Index Match
  • Pivot tables
  • Power Query
  • Power Piovt
  • Power BI Desktop

Part III: Application of Concepts [10 hours] – Online Live

  • Valuation of Securities - I
  • Valuation of Securities-II
  • Loan amortization Tables & FD Calculator
  • Option Valuation
  • Operation Research Decisions
  • Create Models for Problems contributed by the participants
            Software requirement for Candidates: MS Excel 2013, 2016, 2019 or Office 365