-
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.15 AVERAGEIFS
30 Comments
good
I LOVE THIS COURSE. IT IS FULL OF KNOWLEDGE
Wow, I loved the lessons, they were relatable. The class was not boring at all 🙂
thanks for the knowledge shared
so much new tricks, loving it
I love this course, is really increasing my knowledge in Excel
The lessons are great, I love them
The lessons are wonderful
Thank you very much I enjoyed the lessons
Thanks for the breakdown of excel
Great work
The lesson is awesome
Thanks.
Woooooooooow this is very helpful
I Love your simple but detailed ways of teaching
Indeed knowledge is power. Thank you so much for making this type of information availabel at such an affordable cost.
Nice course outline….
Just love it
I so much love the course outlines and how explanatory they were relate. Thanks.
Learning new short cuts
Am enjoying each lesson, Videos are so detailed
Amazing lessons. The Excel is so fun to use.
I really appreciate the knowledge am gaining from you sir greatly appreciate
Interesting
Fantastic, i love this
The lesson was quite interesting.
Thank you.
friendly and simple to comprehend.
Thanks
Great work
Indeed, I am learning a number of things that I didn’t know. I really love the contents in this training.
Great Knowledge
Wonderful