Financial Analysis and Financial Modeling using MS Excel
Perform financial analysis & financial modeling using Microsoft excel. For people who want to become a Financial Analyst
What you’ll learn
- Use MS Excel to create and automate the calculation of Financial ratios
- Become proficient in Excel data tools like Sorting, Filtering, Data validations, and Data importing
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real world Finance problems
- Knowledge of all the essential Excel formulas required for Financial Analysis
Requirements
- This course on “Financial Analysis and Financial Modeling using MS Excel” only requires a PC with any version of Excel installed in it
Description
You’re looking for a complete course on understanding Financial Analysis and Financial Modeling using MS Excel to drive business decisions, right?
You’ve found the right Financial Analysis using MS Excel course! Financial Analysis and Financial analytics provides scientific support to decision-making concerning a firm’s money related matters. This course addresses the topic of Financial analysis with a practical focus, focusing especially on demystifying analytics for finance managers, financial analysts from both statistical and computing point of view.
After completing this course you will be able to:
- Use MS Excel to create and automate the calculation of Financial Ratios
- Gain solid understanding on Financial Analysis and the role of Financial Analyst using MS Excel
- Learn basics and advanced level Financial Accounting concepts that are required for Financial Analysis, specifically for job roles of Financial Analysts.
- Make Finance Dashboards required for Financial Analysis and understand all the charts that you can draw in Excel
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world financial problems
- Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the financial data and to do Financial Analysis for your organization
- Learn the commonly used financial formulas available in excel to calculate depreciation, loan-related calculations, NPV, IRR, etc., required for Financial Analysis
Who this course is for:
- Anyone curious to master Excel for Financial Analysis in a short span of time
- Financial Analysts/ Managers who want to expand on the current set of skills
