-
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!
18 Comments
Please note that creating financial model template for modules 4.3 page is not found or rather is not available. Kindly help us attend to it immediately.
Also, I was able to download video play but course excel files are not accessible. How can I go about it. Kindly assist 🙏 please
Good day,
Apologies for the difficulties you encountered. The issues have now been resolved.
I have difficulties in downloading the videos. Try and make to download once a person has paid.
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
Dashboard design for Financial reporting video is not there, it’s showing Real option investment from Module 8 when you click the dashboard design for Financial reporting in module 9, it display Real option video
Why I’m I failing to proceed
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
Why I’m I just on course outline I’m tired with this
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
The material in this course is empty which cannot be downloaded. Kindly provide the downloadable material to this course
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
I am new here please I need direction
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
Please I’m new here I need to download course materials. Thanks
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
hi i am unable to download my certificate for Microsoft Excel programm
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
Thank you so much for the Lesson well delivered.