Financial Analysis & Modelling with Microsoft Excel - Complete Course

This content is protected, please login and enroll course to view this content!

Prev 2.17 VlookUp

Next 2.19 Pivot Table

2 Comments

Kakuwa namushi

11/06/2023

HOW DO I ACCESS XLOOK UP ON MICROSOFT EXCELL 2010?

Awesome Emmanuel A.

11/06/2023
Reply

No Xlookup in 2010 version. Only available on 2021.
The only way is to upgrade. However, you can use either HLookup and Vlookup in place of Xlookup.

Leave A Reply Cancel reply

Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions) 17
- Lecture1.1
  
  1.0 Introduction & Overview 01 min
- Lecture1.2
  
  1.1 Introduction to Excel 12 min
- Lecture1.3
  
  1.2 Formatting 08 min
- Lecture1.4
  
  1.3 Percentage Calculation 08 min
- Lecture1.5
  
  1.4 Basic Calculation 05 min
- Lecture1.6
  
  1.5 Data Validation 03 min
- Lecture1.7
  
  1.6 IF Statement 11 min
- Lecture1.8
  
  1.7 SUM 06 min
- Lecture1.9
  
  1.8 SUMIF 09 min
- Lecture1.10
  
  1.9 SUMIFS 05 min
- Lecture1.11
  
  1.10 COUNT 03 min
- Lecture1.12
  
  1.11 COUNTIF 02 min
- Lecture1.13
  
  1.12 COUNTIFS 06 min
- Lecture1.14
  
  1.13 AVERAGE 03 min
- Lecture1.15
  
  1.14 AVERAGEIF 03 min
- Lecture1.16
  
  1.15 AVERAGEIFS 06 min
- Quiz1.1
  
  Quiz 1 1 question
Financial Analysis & Modelling Part 2 (Advance Analytical Functions) 8
- Lecture2.1
  
  2.0 Introduction & Overview 01 min
- Lecture2.2
  
  2.16 HlookUp 06 min
- Lecture2.3
  
  2.17 VlookUp 03 min
- Lecture2.4
  
  2.18 XlookUp 12 min
- Lecture2.5
  
  2.19 Pivot Table 17 min
- Lecture2.6
  
  2.20 Power Query (Transforming 1) 05 min
- Lecture2.7
  
  2.21 Power Query (Transforming 2) 07 min
- Quiz2.1
  
  Quiz 2 0 question
Financial Analysis & Modelling Part 3 (Financial Functions & Analysis) 7
- Lecture3.1
  
  3.0 Introduction & Overview 01 min
- Lecture3.2
  
  3.22 Present Value (PV) 06 min
- Lecture3.3
  
  3.23 Future Value (Compounding Frequencies) 09 min
- Lecture3.4
  
  3.24 PMT (Loan Monthly Payment) 07 min
- Lecture3.5
  
  3.25 Amortization Table 04 min
- Lecture3.6
  
  3.26 Internal Rate of Return 12 min
- Quiz3.1
  
  Quiz 3 0 question
Financial Analysis & Modelling Part 4 (Financial Statements & Model) 9
- Lecture4.1
  
  4.0 Introduction & Overview 01 min
- Lecture4.2
  
  4.27 Profit Loss Statement Pt 1 14 min
- Lecture4.3
  
  4.28 Profit Loss Statement Pt 2 10 min
- Lecture4.4
  
  4.29 Profit Loss Statement Pt 3 22 min
- Lecture4.5
  
  4.30 Balance Sheet 09 min
- Lecture4.6
  
  4.31 Three Statement Financial Model Pt 1 09 min
- Lecture4.7
  
  4.32 Three Statement Financial Model Pt 2 21 min
- Lecture4.8
  
  4.33 Financial Ratios 19 min
- Quiz4.1
  
  Quiz 4 0 question
Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards) 5
- Lecture5.1
  
  5.0 Introduction & Overview 01 min
- Lecture5.2
  
  5.34 Sales Reporting (Dashboard) Pt 1 19 min
- Lecture5.3
  
  5.35 Sales Reporting (Dashboard) Pt 2 19 min
- Lecture5.4
  
  5.36 Sales Reporting (Dashboard) Pt 3 31 min
- Quiz5.1
  
  Quiz 5 0 question
Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting) 10
- Lecture6.1
  
  6.0 Introduction & Overview 01 min
- Lecture6.2
  
  6.37 Trend Analysis 14 min
- Lecture6.3
  
  6.38 Comparative Analysis 18 min
- Lecture6.4
  
  6.39 Regression Analysis Pt 1 (Relationship) 16 min
- Lecture6.5
  
  6.40 Regression Analysis Pt 2 (Forecasting) 10 min
- Lecture6.6
  
  6.41 What If Analysis (Data Table) Pt 1 07 min
- Lecture6.7
  
  6.42 What If Analysis (Data Table) Pt 2 08 min
- Lecture6.8
  
  6.43 What If Analysis (Scenario Manager n Goal Seek) Pt 3 11 min
- Lecture6.9
  
  6.44 Forecasting 09 min
- Quiz6.1
  
  Quiz 6 0 question
Financial Analysis & Modelling Part 7 (Financial Modelling) 15
- Lecture7.1
  
  7.0 Part 7 Intro (Financial Modelling) 05 min
- Lecture7.2
  
  7.45 Financial Modelling pt1 (Facts & Findings) 15 min
- Lecture7.3
  
  7.46 Financial Modelling pt2 (Monthly Revenue 1) 13 min
- Lecture7.4
  
  7.47 Financial Modelling pt3 (Monthly Revenue 2) 12 min
- Lecture7.5
  
  7.48 Financial Modelling pt4 (Monthly Revenue 3) 12 min
- Lecture7.6
  
  7.49 Financial Modelling pt5 (Monthly Revenue 4) 17 min
- Lecture7.7
  
  7.50 Financial Modelling pt6 (Monthly P&L 1) 07 min
- Lecture7.8
  
  7.51 Financial Modelling pt7 (Monthly P&L 2) 15 min
- Lecture7.9
  
  7.52 Financial Modelling pt8 (Capital Structure) 05 min
- Lecture7.10
  
  7.53 Financial Modelling pt9 (Fixed Asset Schedules) 16 min
- Lecture7.11
  
  7.54 Financial Modelling pt10 (Working Capital) 19 min
- Lecture7.12
  
  7.55 Financial Modelling pt11 (Annual P&L) 16 min
- Lecture7.13
  
  7.56 Financial Modelling pt12 (Cash Flow Statement) 06 min
- Lecture7.14
  
  7.57 Financial Modelling pt13 (Balance Sheet) 12 min
- Quiz7.1
  
  Quiz 7 0 question

2 Comments

Leave A Reply Cancel reply

Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions) 17

Financial Analysis & Modelling Part 2 (Advance Analytical Functions) 8

Financial Analysis & Modelling Part 3 (Financial Functions & Analysis) 7

Financial Analysis & Modelling Part 4 (Financial Statements & Model) 9

Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards) 5

Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting) 10

Financial Analysis & Modelling Part 7 (Financial Modelling) 15