-
Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions) 17
-
1.0 Introduction & Overview 01 minLecture1.1
-
1.1 Introduction to Excel 12 minLecture1.2
-
1.2 Formatting 08 minLecture1.3
-
1.3 Percentage Calculation 08 minLecture1.4
-
1.4 Basic Calculation 05 minLecture1.5
-
1.5 Data Validation 03 minLecture1.6
-
1.6 IF Statement 11 minLecture1.7
-
1.7 SUM 06 minLecture1.8
-
1.8 SUMIF 09 minLecture1.9
-
1.9 SUMIFS 05 minLecture1.10
-
1.10 COUNT 03 minLecture1.11
-
1.11 COUNTIF 02 minLecture1.12
-
1.12 COUNTIFS 06 minLecture1.13
-
1.13 AVERAGE 03 minLecture1.14
-
1.14 AVERAGEIF 03 minLecture1.15
-
1.15 AVERAGEIFS 06 minLecture1.16
-
Quiz 1 1 questionQuiz1.1
-
-
Financial Analysis & Modelling Part 2 (Advance Analytical Functions) 8
-
2.0 Introduction & Overview 01 minLecture2.1
-
2.16 HlookUp 06 minLecture2.2
-
2.17 VlookUp 03 minLecture2.3
-
2.18 XlookUp 12 minLecture2.4
-
2.19 Pivot Table 17 minLecture2.5
-
2.20 Power Query (Transforming 1) 05 minLecture2.6
-
2.21 Power Query (Transforming 2) 07 minLecture2.7
-
Quiz 2 0 questionQuiz2.1
-
-
Financial Analysis & Modelling Part 3 (Financial Functions & Analysis) 7
-
3.0 Introduction & Overview 01 minLecture3.1
-
3.22 Present Value (PV) 06 minLecture3.2
-
3.23 Future Value (Compounding Frequencies) 09 minLecture3.3
-
3.24 PMT (Loan Monthly Payment) 07 minLecture3.4
-
3.25 Amortization Table 04 minLecture3.5
-
3.26 Internal Rate of Return 12 minLecture3.6
-
Quiz 3 0 questionQuiz3.1
-
-
Financial Analysis & Modelling Part 4 (Financial Statements & Model) 9
-
4.0 Introduction & Overview 01 minLecture4.1
-
4.27 Profit Loss Statement Pt 1 14 minLecture4.2
-
4.28 Profit Loss Statement Pt 2 10 minLecture4.3
-
4.29 Profit Loss Statement Pt 3 22 minLecture4.4
-
4.30 Balance Sheet 09 minLecture4.5
-
4.31 Three Statement Financial Model Pt 1 09 minLecture4.6
-
4.32 Three Statement Financial Model Pt 2 21 minLecture4.7
-
4.33 Financial Ratios 19 minLecture4.8
-
Quiz 4 0 questionQuiz4.1
-
-
Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards) 5
-
5.0 Introduction & Overview 01 minLecture5.1
-
5.34 Sales Reporting (Dashboard) Pt 1 19 minLecture5.2
-
5.35 Sales Reporting (Dashboard) Pt 2 19 minLecture5.3
-
5.36 Sales Reporting (Dashboard) Pt 3 31 minLecture5.4
-
Quiz 5 0 questionQuiz5.1
-
-
Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting) 10
-
6.0 Introduction & Overview 01 minLecture6.1
-
6.37 Trend Analysis 14 minLecture6.2
-
6.38 Comparative Analysis 18 minLecture6.3
-
6.39 Regression Analysis Pt 1 (Relationship) 16 minLecture6.4
-
6.40 Regression Analysis Pt 2 (Forecasting) 10 minLecture6.5
-
6.41 What If Analysis (Data Table) Pt 1 07 minLecture6.6
-
6.42 What If Analysis (Data Table) Pt 2 08 minLecture6.7
-
6.43 What If Analysis (Scenario Manager n Goal Seek) Pt 3 11 minLecture6.8
-
6.44 Forecasting 09 minLecture6.9
-
Quiz 6 0 questionQuiz6.1
-
-
Financial Analysis & Modelling Part 7 (Financial Modelling) 15
-
7.0 Part 7 Intro (Financial Modelling) 05 minLecture7.1
-
7.45 Financial Modelling pt1 (Facts & Findings) 15 minLecture7.2
-
7.46 Financial Modelling pt2 (Monthly Revenue 1) 13 minLecture7.3
-
7.47 Financial Modelling pt3 (Monthly Revenue 2) 12 minLecture7.4
-
7.48 Financial Modelling pt4 (Monthly Revenue 3) 12 minLecture7.5
-
7.49 Financial Modelling pt5 (Monthly Revenue 4) 17 minLecture7.6
-
7.50 Financial Modelling pt6 (Monthly P&L 1) 07 minLecture7.7
-
7.51 Financial Modelling pt7 (Monthly P&L 2) 15 minLecture7.8
-
7.52 Financial Modelling pt8 (Capital Structure) 05 minLecture7.9
-
7.53 Financial Modelling pt9 (Fixed Asset Schedules) 16 minLecture7.10
-
7.54 Financial Modelling pt10 (Working Capital) 19 minLecture7.11
-
7.55 Financial Modelling pt11 (Annual P&L) 16 minLecture7.12
-
7.56 Financial Modelling pt12 (Cash Flow Statement) 06 minLecture7.13
-
7.57 Financial Modelling pt13 (Balance Sheet) 12 minLecture7.14
-
Quiz 7 0 questionQuiz7.1
-
This content is protected, please login and enroll course to view this content!
35 Comments
How can i watch the videos on my laptop
Login to the site using your laptop and download the videos directly into your laptop.
There’s a download link attached to all the videos.
I can learn the system keeps showing rating box query
please cant download the course file. its says file must have been damaged. Please can you help?
That should be a challenge from your end. The file is not damaged. Reach out to me via mail to get it
awesome8emmanuel@gmail.com
Hi Emmanuel, when i click to open the files they are only giving me the option to copy the files.
Please advise? thanks
I guess you want the lesson materials, you can reach me via mail to get it
awesome8emmanuel@gmail.com
Hope I have access to this course anytime I like
Secondly can I download this course on my phone??
Hi Ema,
Kindly send the lesson materials as I couldn’t download the file since yesterday
Thank you
Faruku Saidu
Here’s the link to download the lesson materials
https://drive.google.com/file/d/1kc-PJFKRziMc6cVoExTDaE36lWw6X_Qe/view?usp=drivesdk
Great Job, Mr. Awesome Emmanuel.
Thanks for the information
Hi Emmanuel,
Please I need the link to the cracked Excel version as the one installed on the laptop is not compatible with the one downloaded.
Thanks.
I don’t know if you will be able to install the crack version of Office on your own. HOWEVER you can try it out.
Go to this website
getintopc.com
Search for Office Suite 2016 or 2021
Download it and install.
There’s an installation video attached to guide you.
If you can’t do this then you will have to outsource it
please i cant download the file
You can send a mail to get it
awesome8emmanuel@gmail.com
Very great course, however I have been having issues, my computer is restricted by my office network, and on phone, i can’t go pass chapter two. Each time i tried it would be showing error 404, ( don’t know what that mean though) please assist. I can actually seen the complete course to chapter 7 on the system but blocked from viewing due office policy.
There’s nothing we can do.
Get another laptop.
Or download the videos using your phone and practice on the laptop
please how do i download the excell installer
The Ms Excel application is not a free software. Majority of the users however use the cracked version.
You can get the cracked version on this site
getintopc.com
Search for Microsoft office suite 2021 and follow the video installation guide
Scammed
I’m failing to download course file ,is it possible to get it through email ?
After this introduction. I can’t find next topics. Kindly guide on this issue.
wow! thank you so much
Thank you so much
I am looking forward to learning…
Thanks…
Hi, where are we supposed to download the excel for practice?
There’s a download link just beneath the first video. You can also get it via mail.
Here’s my email address
awesome8emmanuel@gmail.com
Hello
Am not able to move past the first two lessons
Sorry about that. Kindly contact our Support Officer Mr Samuel for assistance
+234 813 294 1277
WhatsApp
WOW! Thank God for this Course I learned a lot. This course is so great and very timely for me. Thank you AQskill for putting this together.