-
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!
35 Comments
Hello. I am failing to install office 2021. I am getting a warning message that the file contains a virus or potentially unwanted software.
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
Hello Aqskill,
I cannot complete the download of WinRAR, due to the protection on the organization’s system I am using, please is there an alternative to completing this download or to unzip the zipped file?
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
i followed your installation process but i found out that the crack folder is empty.
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
Hello unfoturnetlly I can’t access the link. What could be the issue?
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
Hello Admin. No Winrar file can be found on Google Drive for download. please assist me in getting it. thank you
Good day sir,
kindly download it using this link
https://winrar.com/
What do I do if I already have office 360 installed on my machine.
Can I use that 1?
Good day sir,
Yes, you can.
Good day sir
Please apart from MS Excel version 2021
Which other version can we use?
Please i can’t install excel on my system. The two folders on the google drive was not showing when i clicked on the link. it showed as a zip folder.
kindly download winrar to extract it. https://winrar.com/
Can one use microsoft excel 2016,, since that what my laptop has, though it is not a new laptop. Am using a second hand laptop and found when the owner had already installed microsoft office 2016
Good day sir,
yes, you can.
I am Ahmed Hersi recently started this course I am having trouble with installation of microsoft excel 2021
kindly help me to install
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
Hello Team,
My name is Oyinlola, I recently purchased this course.
Please I’m having issues installing the Microsoft 2021. I am getting an error message
“404. The requested URL was not found on this server”
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
will this affect the Microsoft that is is already installed
Good day ma,
No, it won’t.
Please am unable to install.
I didn’t see the folder
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
Good morning
Glad I noticed this on google .
Hello
Am Marion Conteh recent student I’m facing challenges on installing the office 2021 please I need a help to install the software.,For me to move to the next step .
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
Hello, I’m unable to activate after installation.
Good day sir,
still unable to install office to 2021 on my system.
please kindly help.
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
the theme is the entitiy that is affected by the action expressed by the verb and the verb is controlled by the agent agent . The theme can also b
hello, please i already have Microsoft Office LTSC Professional Plus 2021, do i still need to download the one you sent?
i actually tried downloading and am told to be aware of potential virus .
Good day sir/ma,
You don’t have to .