About ICICIdirect Centre for Financial Learning (ICFL)


ICICIdirect Centre for Financial Learning (ICFL) is an initiative of ICICI Securities Ltd. set up with an objective of simplifying financial knowledge and increasing financial literacy amongst prospective or experienced investors and knowledge seekers. ICFL training programmes are categorised under Investment Education Programmes and Professional Certification & Development Programmes. The repository of domain knowledge includes host of in-house developed seminars, workshops, certifications and training programmes leading to reputed certifications. These programmes are in the area of Stock Investing, Derivatives, Mutual Funds, Financial Planning, Wealth Management, Corporate Finance, etc. 
ICICIdirect Centre for Financial Learning has been conferred with the Award for Innovation in Learning and Best Online Learning Solution at the World Education Congress. It also won the Emerging Brand Award at CMO Asia in Singapore.
About Xavier School of Management Jamshedpur (XLRI)
Founded in 1949, XLRI, managed by Jesuit Fathers has always strove to be a management school with a difference. Pursuit of academic excellence and fostering whole-person integral growth – intellectual, emotional, spiritual and social persona of students has been the hallmark of XLRI for over six decades.

About the Faculty

Prof. Pitabas Mohanty was a Senior Visiting Scholar at Stern School of Business, New York University in 2009-10. He is a Fellow of the Indian Institute of Management Bangalore. A Gold Medalist in MA (Applied Economics), he is also a Chartered Financial Analyst and a Cost Accountant. He has got more than fifteen years of teaching experience in Investments and Corporate Finance. He has conducted numerous training programmes for companies in India and abroad including companies from Dubai, Quatar, and Kuwait in Company Valuation and Financial Modeling. He is the co-author of books on ‘Investments’ and ‘Principles of Corporate Finance’ published by the McGraw Hill Education. He is actively into research in corporate finance and investments with many publications in books and refereed journals. He has consulted a few companies in valuation of companies. He has won numerous research awards at various research conferences.


Course Curriculum

Data Analysis using Excel
Mastering formulas and functions in Excel 00:00:00
Formatting, Conditional and Advanced Formatting of Data 00:00:00
Data Analysis using Excel 00:00:00
Preparing Charts in Excel 00:00:00
Preparing Dynamic Charts in Excel 00:00:00
Understanding Basic Macros 00:00:00
Financial Modeling using Excel
Building Integrated Financial Statements Model 00:00:00
Building Corporate Valuation Model (for a Manufacturing Company) 00:00:00
Building Project Finance Models 00:00:00
Using Macros to make the Models Dynamic and Professional 00:00:00


Certification will be offered by XLRI Jamshedpur


Course Reviews


  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.


    Key Features

    Need more help on a course. Drop us a Query

    Join Our Email-Newsletter

    Training in Cities

    Mumbai,Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston, Sydney, Singapore
    WordPress Image Lightbox Plugin



    FACEBOOKGOOGLE Create an Account
    Create an Account Back to login/register