Financial Analysis And Financial Modeling Using MS Excel - 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
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
Theoretical concepts and use cases of different Financial models Step-by-step instructions on implementing Financial models in excel Downloadable Excel files containing data and solutions used in each lecture Class notes and assignments to revise and practice the concepts
Sections of this Course -- 00:00:00 Introduction 00:03:11 Prerequisites: Excel formulas and functions 01:20:19 Time Value of Money 02:11:56 Analysis of Profit and Loss Statement 02:28:00 Loan Repayment Calculations 02:45:47 Methods of calculating Depreciation 03:08:08 Financial Ratio Analysis 03:36:58 Financial Charts and Dashboards - Introduction 03:40:39 Charts and Dashboards using Excel 05:57:35 Case Study - Finance Dashboard 06:29:30 Pivot Tables 06:45:00 Predictive Analytics - Introduction 06:47:10 Basics of Statistics 07:17:23 Machine Learning -Introduction 07:42:14 Getting Data Ready for Regression Model 09:00:28 Creating Regression Model 10:00:50 Finance Case Study - Linear Regression
What is Data Validation in Excel. Data validation is a feature in Excel used to control what a user can enter into a cell. Learn more about it with Examples.
Advanced Excel Online Training & Certification Courses by CETPA with Real time projects. Enroll now to get student offer of 50% on Online Course. Call us: 9212172602.
In this MS Excel tutorials, video we are going to see the differnce between tables and cell ranges in MS Excel. Also we are going to see that how can we create a Table from data given to us and what all changes we can apply to our tables.
In this MS Excel tutorials, video we are going to apply the slicers in charts in MS Excel. However, there is no direct method of doing so, that is why we are going to use a simple trick over here. Also we are going to see that how can we connect same slicer with multiple charts in MS Excel.
In this MS Excel VBA video, we are going to see the usage of the Insert Cells feature of MS Excel. Using this feature we can insert cells at some specified locations easily. In this video we will see the Overview of formulas in Excel.