-
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 COUNTIFSLecture1.13
-
1.13 AVERAGE 03 minLecture1.14
-
1.14 AVERAGEIF 03 minLecture1.15
-
1.15 AVERAGEIFS 06 minLecture1.16
-
Quiz 1 2 questionsQuiz1.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) 6
-
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
-
-
Financial Analysis & Modelling Part 4 (Financial Statements & Model) 8
-
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 22 minLecture4.7
-
4.33 Financial Ratios 19 minLecture4.8
-
-
Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards) 4
-
5.0 Introduction & Overview 01 minLecture5.1
-
5.34 Sales Reporting (Dashboard) Pt 1 19 minLecture5.2
-
5.35 Sales Reporting (Dashboard) Pt 2 18 minLecture5.3
-
5.36 Sales Reporting (Dashboard) Pt 35.36 Sales Reporting (Dashboard) Pt 3 31 minLecture5.4
-
-
Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting) 9
-
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
-
-
Financial Analysis & Modelling Part 7 (Financial Modelling) 14
-
7.0 Part 7 Intro (Financial Modelling) 05 minLecture7.1
-
7.45 Financial Modelling pt1 (Facts & Findings) 09 minLecture7.2
-
7.46 Financial Modelling pt2 (Monthly Revenue 1) 13 minLecture7.3
-
7.47 Financial Modelling pt3 (Monthly Revenue 2) 13 minLecture7.4
-
7.48 Financial Modelling pt4 (Monthly Revenue 3) 12 minLecture7.5
-
7.49 Financial Modelling pt5 (Monthly Revenue 4) 16 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) 17 minLecture7.11
-
7.55 Financial Modelling pt11 (Annual P&L) 16 minLecture7.12
-
7.56 Financial Modelling pt12 (Cash Flow Statement)Lecture7.13
-
7.57 Financial Modelling pt13 (Balance Sheet) 12 minLecture7.14
-
This content is protected, please login and enroll course to view this content!
Prev
1.9 SUMIFS
Next
1.11 COUNTIF
8 Comments
COUNTIF & COUNTIFS are missing
Good day,
Apologies for the difficulties you encountered. The issues have now been resolved.
The next course 1.11 is not playing. What is the problem?
Good day,
Apologies for the difficulties you encountered. The issues have now been resolved.
I CAN DOWNLOAD THIS but Unable to down COUNTIF, COUNTIFS
Good day,
Apologies for the difficulties you encountered. The issues have now been resolved.
How can I get the Excel document of these lectures?
Kindly check the last lesson in module 3 and the first three lesson of the following module