Financial Analysis & Modelling with Microsoft Excel – Complete Course → 2.18 XlookUp

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

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.

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

2 Comments

Leave a Reply to Awesome Emmanuel A. Cancel reply