-
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!
Prev
1.7 SUM
Next
1.9 SUMIFS
8 Comments
Hello, how do i get the data used in each of the videos to practice ?
The download link is attached to the first video lesson of this course.
You can also get it by reaching out to me via mail
awesome8emmanuel@gmail.com
can sumif work without values being in T-table?
Yes
excellent work, will please share the data set
The lesson materials is attached to the first lesson. Click on it to download.
You can also send a request mail
awesome8emmanuel@gmail.com
Hello Awesome Emmanuel, the excel i am using is 2016 crack version and some of the formulas aren’t working e.g. sequence in the first part. therefore, how can i solve this issue? thanks.
Hello Friend.
Sequence by default is not in 2016. So it’s not because it’s Cracked.
I used 2021 version that why I had Sequence Function in mine. However, the Course was designed in such a way that even 2016 users can relate.
I just mentioned Sequence function in the video, it’s not mandatory to use it.
Once you upgrade you will get other new functions