-
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!
27 Comments
Indeed, it will be an exciting journey. Thanks
This is adult Montessori teaching. You made it simple and undetstable.
Hi, I cannot find the materials used in this session.
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 couldn’t find any link in this video to enable me to access the files
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 not seeing any download link
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
Please I don’t see the link under this video
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 didn’t see any link to download the course fie
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 cannot see the link to download the files
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
This great and well explained.
Good Afternoon Sammy, Kindly help me with the course materials to follow the video explanations proper please, Thanks
https://www.aqskill.com/wp-content/uploads/2023/12/COURSE-FILES.zip
Links for the course files please
https://www.aqskill.com/wp-content/uploads/2023/12/COURSE-FILES.zip
hello I can’t find the course materials
https://www.aqskill.com/wp-content/uploads/2023/12/COURSE-FILES.zip
I’m loving this already.
This is indeed value for money.
Hi How do i access the course files
https://www.aqskill.com/wp-content/uploads/2023/12/COURSE-FILES.zip
yay google is my king assisted me to find this outstanding site! .
Hello sir,
Lesson is well explained and detailed.
Thank you
I am delighted to be part of this amazing knowledge sharing platform.
Thank you guys for this amazing initiate.