Curriculum
- 7 Sections
- 64 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions)17
- 0.01.0 Introduction & Overview1 Minute
- 0.11.1 Introduction to Excel12 Minutes
- 0.21.2 Formatting8 Minutes
- 0.31.3 Percentage Calculation8 Minutes
- 0.41.4 Basic Calculation5 Minutes
- 0.51.5 Data Validation3 Minutes
- 0.61.6 IF Statement11 Minutes
- 0.71.7 SUM6 Minutes
- 0.81.8 SUMIF9 Minutes
- 0.91.9 SUMIFS5 Minutes
- 0.101.10 COUNT3 Minutes
- 0.111.11 COUNTIF2 Minutes
- 0.121.12 COUNTIFS
- 0.131.13 AVERAGE3 Minutes
- 0.141.14 AVERAGEIF3 Minutes
- 0.151.15 AVERAGEIFS6 Minutes
- 0.16Quiz 12 Questions
- Financial Analysis & Modelling Part 2 (Advance Analytical Functions)8
- Financial Analysis & Modelling Part 3 (Financial Functions & Analysis)6
- Financial Analysis & Modelling Part 4 (Financial Statements & Model)8
- 3.04.0 Introduction & Overview1 Minute
- 3.14.27 Profit Loss Statement Pt 114 Minutes
- 3.24.28 Profit Loss Statement Pt 210 Minutes
- 3.34.29 Profit Loss Statement Pt 322 Minutes
- 3.44.30 Balance Sheet9 Minutes
- 3.54.31 Three Statement Financial Model Pt 19 Minutes
- 3.64.32 Three Statement Financial Model Pt 222 Minutes
- 3.74.33 Financial Ratios19 Minutes
- Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards)4
- Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting)9
- 5.06.0 Introduction & Overview1 Minute
- 5.16.37 Trend Analysis14 Minutes
- 5.26.38 Comparative Analysis18 Minutes
- 5.36.39 Regression Analysis Pt 1 (Relationship)16 Minutes
- 5.46.40 Regression Analysis Pt 2 (Forecasting)10 Minutes
- 5.56.41 What If Analysis (Data Table) Pt 17 Minutes
- 5.66.42 What If Analysis (Data Table) Pt 28 Minutes
- 5.76.43 What If Analysis (Scenario Manager n Goal Seek) Pt 311 Minutes
- 5.86.44 Forecasting9 Minutes
- Financial Analysis & Modelling Part 7 (Financial Modelling)14
- 6.07.0 Part 7 Intro (Financial Modelling)5 Minutes
- 6.17.45 Financial Modelling pt1 (Facts & Findings)9 Minutes
- 6.27.46 Financial Modelling pt2 (Monthly Revenue 1)13 Minutes
- 6.37.47 Financial Modelling pt3 (Monthly Revenue 2)13 Minutes
- 6.47.48 Financial Modelling pt4 (Monthly Revenue 3)12 Minutes
- 6.57.49 Financial Modelling pt5 (Monthly Revenue 4)16 Minutes
- 6.67.50 Financial Modelling pt6 (Monthly P&L 1)7 Minutes
- 6.77.51 Financial Modelling pt7 (Monthly P&L 2)15 Minutes
- 6.87.52 Financial Modelling pt8 (Capital Structure)5 Minutes
- 6.97.53 Financial Modelling pt9 (Fixed Asset Schedules)16 Minutes
- 6.107.54 Financial Modelling pt10 (Working Capital)17 Minutes
- 6.117.55 Financial Modelling pt11 (Annual P&L)16 Minutes
- 6.127.56 Financial Modelling pt12 (Cash Flow Statement)
- 6.137.57 Financial Modelling pt13 (Balance Sheet)12 Minutes