-
Module 1 - Introduction to Finance 4
-
Course Overview 03 minLecture1.1
-
Importance of Financial analysis 16 minLecture1.2
-
Installation of Microsoft Excel 2021 12 minLecture1.3
-
Excel tools for Financial analysis 17 minLecture1.4
-
-
Module 2 - Excel Basics 5
-
Data Entry and Formatting 23 minLecture2.1
-
Excel Navigation and Basic Functions 09 minLecture2.2
-
Excel References 09 minLecture2.3
-
Basic Formulas & Functions 09 minLecture2.4
-
Data Validation and Error Handling 06 minLecture2.5
-
-
Module 3 - Time Value of Money & Sensitivity Analys. 4
-
Understanding the Time Value of Money 12 minLecture3.1
-
Present & Future value calculations 11 minLecture3.2
-
Excel Functions for TVM(NPV, IRR) 09 minLecture3.3
-
Using data tables for Sensitivity Analysis 08 minLecture3.4
-
-
Module 4 - Understanding & Creating Financial Models 3
-
Requirement of a Financial Model 09 minLecture4.1
-
Drafting Assumption of Financial Model 18 minLecture4.2
-
Creating Financial Model Templates 19 minLecture4.3
-
-
Module 5 - MIcrosoft Excel for Accounting 5
-
Balance Sheet Analysis 20 minLecture5.1
-
Balance Sheet Analysis 2 11 minLecture5.2
-
Income Statement Analysis 17 minLecture5.3
-
Cashflow Statement Analysis 17 minLecture5.4
-
Ratio Analysis 10 minLecture5.5
-
-
Module 6 - Forecasting & Creating Budgets 6
-
Sales & Revenue Forecasting 16 minLecture6.1
-
Expense Forecasting 17 minLecture6.2
-
Scenario Analysis & Goal Seeking 15 minLecture6.3
-
Creating budgets and Projections 01 18 minLecture6.4
-
Creating budgets and Projections 02 22 minLecture6.5
-
Creating budgets and Projections 03 24 minLecture6.6
-
-
Module 7 - Valuations 4
-
Introduction to Valuation 06 minLecture7.1
-
Discounted Cash flow(DCF) Valuation 16 minLecture7.2
-
Comparable Company Analysis(CCA) 16 minLecture7.3
-
Excel Models for Valuations 05 minLecture7.4
-
-
Module 8 - Investment Analysis 4
-
Capital Budgeting and Investment Appraisal 09 minLecture8.1
-
Payback period, NPV, and IRR for investment decisions 20 minLecture8.2
-
Risk Analysis and Monte Carlo Simulation 10 minLecture8.3
-
Real Options in Investment Analysis 04 minLecture8.4
-
-
Module 9 - Financial Reporting 3
-
Creating Financial Charts and Graphs 16 minLecture9.1
-
Data Tables and PivotTables for Analysis 11 minLecture9.2
-
Dashboard design for Financial reporting 26 minLecture9.3
-
-
Module 10 - Profit and Loss Statement (P & L) 4
-
Introduction to Profit and Loss(P & L) statement 04 minLecture10.1
-
Overview of the P & L and its significance in Financial analysis 05 minLecture10.2
-
Components of P & L statement 05 minLecture10.3
-
Reading and Analysis P & L statements in Excel 08 minLecture10.4
-
-
Module 11 - Loan repayment & Amortization Table 4
-
Introduction to Loan Repayment 07 minLecture11.1
-
Types of loans – Amortizing vs Interest only 07 minLecture11.2
-
Building an amortization table using ExcelLecture11.3
-
Demonstrations, Calculations and others 18 minLecture11.4
-
