-
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 20 minLecture4.3
-
-
Module 5 - MIcrosoft Excel for Accounting 5
-
Balance Sheet Analysis 20 minLecture5.1
-
Balance Sheet Analysis 2 20 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 04 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 Excel 03 minLecture11.3
-
Demonstrations, Calculations and others 18 minLecture11.4
-
This content is protected, please login and enroll course to view this content!
3 Comments
Dashboard design for Financial reporting video is not there, it’s showing Real option investment from Module 9 when you click the dashboard design for Financial reporting, it display Real option video
Nice one learning a pivot table, though I expected graphs and charts from the financial statements.
The invoice date that the pivot table gives in the course file is different from the one that you used in the Lesson. I mean, when i was making a pivot table for sales trend using the table provided in the course file for addida file. I drag the invoice date, i do not have the option of monthly, quarterly and yearly date as you have it in the Lesson, it give only one invoice date and that is 1/1/2020, 2/1/2020 etc.
How do i see options like the one you have in the Lesson to choose from.
Thanks