-
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
-
This content is protected, please login and enroll course to view this content!
11 Comments
Please see below for what i got after downloading Office 2021. Rather than what was shown in the video (Win Rar and Office 2021 folders).
The only file i got is named: “Getintopc.com_Microsoft_Office_LTSC_2021x64_Pro_May_2021.rar”
Kindly advise.
Thank you.
N.B. I would have sent the screen shot, but for some reasons, the system didnot allow me to take a screenshot.
HI,
I NOTICED I ALREADY HAVE WINRAR INSTALLED ON MY SYSTEM. DO I NEED TO INSTALL ANOTHER ONE? YOU DIDN’T EMPHASIZE HOW YOU COME ABOUT THE WINRAR FILE ON YOUR VIDEO. THANKS AS I AWAIT YOUR RESPONSE.
Hallo, am unable to click the link for installation.kindly assist
kindly assist on how to install office
Please sir I don’t have a laptop and I’m trying to download it on my phone but I don’t know if it possible because I’m seeing Microsoft office 365
Good day, my downloads were not successful, it keeps giving me Getintopc.com_microsoft, Please what must I do?
Hi,
my crack folder when i double click is empty. so I cannot complete the set up. please advise.
Good day, below is what i got after the download and it is a Zipped file unable to open, plz help.
Getintopc.com_Microsoft_Office_LTSC_2021x64_Pro_May_2021.rar
hello,
the microsft office did not activate after following all the steps.
it wrote activated for 180 days but upon opening excel i can only view file. i cannot edit.
i am having difficulty downloading the Microsoft excel 2021