Financial Analysis using MS Excel
Financial Analysis using MS Excel
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
Introduction
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