Financial Analysis using MS Excel

Financial Analysis using MS Excel

Home Courses Course Detail


Course Details

Course Instructor :

Faculty Members and Industry Experts from Amrita Vishwa Vidyapeetham and MaxEd

Hours :

24 Hours

Pre-requisites :

This course on "Financial Analysis using MS Excel" only requires a PC with Excel installed on it

Fee : ₹ 15000



This course will help you to gain a solid understanding of financial analysis using MS Excel to organize and analyze volumes of data, use excel formulas and functions for financial analysis, and create charts and dashboards for visualization.

What will you learn ?

  • Basic formulas and functions
  • Calculation of financial ratios using MS Excel
  • Visualization in Excel and financial dashboarding
  • Data summarization using pivot tables

Learning Objectives

  • Gain a solid understanding of Financial Analysis using MS Excel
  • Use MS Excel to create and automate the calculation of Financial ratios
  • Knowledge of all the essential Excel formulas required for Financial Analysis
  • Learn the commonly used financial formulas available in excel to calculate depreciation, NPV, IRR, etc., required for Financial Analysis