-
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!
Next
1.2 Formatting
29 Comments
Hi please i need a link to download 2021 ms excel.
Here’s the cracked version link.
Uninstall the version you have before installing this.
Also note that this version works better for Windows 10 Systems.
There’s an installation guide on this site to guide you
Best Regards
Awesome Emmanuel
https://getintopc.com/softwares/office-tools/microsoft-office-2021-pro-plus-august-2022-free-download-1466108/
hi
how do i download all the files?
There’s a link attached to the first video to download the files. You can also reach me via my email address
awesome8emmanuel@gmail.com
thank you so much for the explaining the course thoroughly, keep up the good work
Good morning sir, please how many days can this course be runned. I don’t want to finish the course today so how many days am I still allowed to run through the course
I am not able to install your App on my laptop how do I go about it(
We are smoothly progressing
hello. how can i get the excel folders used for practice. Thank you
Hi, the download link is attached to the first videos lesson. You can also send me a mail to get it.
awesome8emmanuel@gmail.com
great lesson and very interesting
Hello,. how can i get the excel folders used for practice. Thank you
The lesson materials is attached to the first lesson. Click on it to download.
You can also send a request mail
awesome8emmanuel@gmail.com
This is impressive 👏
Wonderful I have learnt a number of things that I didn’t know. Thank you
please I need the link to download and install the latest Ms excel and the key to use.
bencnweke@gmail.com
thank you
The Microsoft Office package is not a FREE app. I don’t have the installation raw file but you can search for the cracked version on this site
getintopc.com
The installation guide is also there.
However if that didn’t work you need to either purchase the pro version or meet a Computer accessories vendor to get the crack version
So far so good..🤝🏾
Do you have modules apart from the video presentation
How do I get the certificate please
The sequence formula is blaring I can read it properly
=SEQUENCE(1000,1,1)
Thank you for clear explanations it’s easier to follow.
Nice course