Microsoft Excel for Financial Analysis, Modelling & Accounting

This content is protected, please login and enroll course to view this content!

Prev Course Overview

Next Installation of Microsoft Excel 2021

5 Comments

Chanda Katongo

20/12/2023

HAPPY TO BE ON BOARD

MUTSAWAISHE A MUPINYURI

30/12/2023

an interesting lecture

Ejiofor Goodness

19/01/2024

Happy to be here

Clement Rosemary Nengiwealth Nengiwealth

24/01/2024

Interesting teaching I want to know more

Chabala Changa

04/05/2024

Well structured and easy to understand Lessons.

Leave A Reply Cancel reply

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

5 Comments

Leave A Reply Cancel reply

Module 1 - Introduction to Finance 4

Module 2 - Excel Basics 5

Module 3 - Time Value of Money & Sensitivity Analys. 4

Module 4 - Understanding & Creating Financial Models 3

Module 5 - MIcrosoft Excel for Accounting 5

Module 6 - Forecasting & Creating Budgets 6

Module 7 - Valuations 4

Module 8 - Investment Analysis 4

Module 9 - Financial Reporting 3

Module 10 - Profit and Loss Statement (P & L) 4

Module 11 - Loan repayment & Amortization Table 4