VLookUp Function | EDUCBA

Autoplay
Autocomplete

Previous Lesson Complete and Continue

INVESTMENT BANKING COURSE

Investment Banking - An Overview

Investment Banking - Introduction new (3:34)
Investment Banks VS Retail & Commercial Banks new (11:31)
Investment Banking & Research new (11:34)
Amc, Buy Side And Sell Side Of An Investment Bank new (6:10)
Sales & Trading And Equity Research new (5:21)
Raising Capital & Ipo new (12:06)
Underwriting And Market Maker new (7:07)
M&A Advisory And Pitch-Book new (7:31)
Reorganizations And Restructuring new (3:50)
Structure Of An Investment Bank new (8:15)
Investment Banking - Conclusions new (5:31)

Basic Excel Training

accessing MS Excel new (2:41)
MS Excel Startup Screen (2:27)
Understanding the Ribbon (3:03)
Cells in Excel (1:18)
Worksheet Essentials (3:10)
Saving the File (1:14)
Formatting Cells (14:23)
Custom Cell Styles (6:12)
Custom Number Formatting in Excel (11:39)
More on Custom Number Formatting (10:59)
Custom Formats of Data (13:33)
The BEDMAS Order of Mathematical Operations (9:04)
Mathematical Operations without Functions new1 (9:43)
Mathematical Operations without Functions Continued (11:38)
IF Function (10:32)
More on IF Function (8:25)
Importing Data and Calculations (10:46)
Working with the Count Function (12:40)
Conditional Counts - CountIF Function (4:58)
Working with the Sum Function (14:02)
Finding the Average (11:17)
Conditional Average - Average IFS Function (8:31)
Finding the Maximum Value Using the MAX Function (8:36)
Finding the Minimum Value Using the MINFS Function (8:04)
Determining Proportions and Updating a Calculation (10:06)
Conditional Formatting new1 (18:24)
More on Conditional Formatting (7:47)
Working with Tables (13:03)
Formatting Table (13:31)
Filtering and Sorting of Data (9:40)
Freeze and Split (11:18)
Printing and Layouts in Excel (9:51)
Pivot Tables (7:50)
Creating Custom Tables (8:58)
Organizing Pivot Tables (8:35)
Column Chart (10:32)
Bar Chart (8:03)
Line Chart (14:24)
Pie Chart (10:27)
Map Chart (6:46)
Common Errors in Excel (11:12)
More on Common Errors (13:42)

Microsoft Excel - Advanced

Logical Function - IF new (8:21)
AND OR and XOR Functions (8:48)
IFS Function - Example 1 (6:25)
IFS Function - Example 2 (9:02)
SWITCH Function (10:17)
Other Logical Functions (8:20)
Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
Date Functions - TODAY DAY (9:36)
MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
EDATE and EOMONTH Functions (8:38)
YEARFRAC Function (7:19)
Joining Data using CONCAT and TEXTJOIN (9:59)
LEN FIND LEFT RIGHT TRIM (10:26)
Using UNIQUE and TRANSPOSE (11:27)
TEXT Function (10:00)
CHOOSE Function (10:46)
More on CHOOSE Function (6:34)
VLookUp Function (12:47)
HLOOKUP Function (5:12)
Index Function (10:31)
Match Function (9:24)
XLOOKUP and XMATCH Functions (8:43)
Using the OFFSET Function (8:49)
OFFSET Function - Total and Average Score (9:29)
OFFSET Function - Highest and Lowest Score (8:57)
OFFSET Function - Year to Month Sales (11:01)
OFFSET Function - Quarterly and Half-Month Sales (6:39)
Naming of Cell (12:30)
Naming a Range (10:01)
Text to Columns (6:35)
Grouping Tabs and Subtotal Function (12:47)
Working with Hyperlinks (11:17)
Data Validation (11:00)
Data Validation Continued (11:14)
Custom Data Validation (12:17)
Generating Random Numbers (6:10)
Custom Views (10:34)
Protecting Worksheet and Workbook (17:36)
PivotTable - Advanced Features (10:02)
More on Advanced Features (6:50)
Slicers and Timelines (6:43)
Solver (11:37)
Data Tables (10:42)
More on Data Tables (9:53)
Goal Seek (8:43)
Combo Charts (13:51)
More on Combo Charts (12:11)
Sparklines (8:10)
Waterfall Chart (9:37)
Box Chart (12:48)
Whisker Chart (11:29)
TreeMap and Sun Burst Charts (11:53)
Radar Chart (7:55)
Scroll Bar (10:00)
Spin Button and Radio Button (10:52)
Form Control Application (10:01)
Form Control Application Continued (5:32)
Data Entry Form (3:44)

Accounting - The Foundation

An Introduction To Financial Accounting (0:48)
Purpose Of Financial Statements (3:16)
Explaining A Business Cycle (2:16)
Accounting For Income Statement (9:31)
Accounting For Balance Sheet 1 (7:47)
Accounting For Balance Sheet 2 (9:53)
Accounting For Balance Sheet 3 (6:24)
Accounting For Cash Flows (5:20)
Conclusion (0:28)

Accounting: 01 - Income Statement

Financial Statements - Fiscal Year Vs Calendar Year new (6:34)
Income Statement Format new (8:23)
Calculating Profit Margins (2:33)
Non Recurring Items new (9:10)
Changes In Accounting Estimates new (3:00)
Final Remarks new (3:09)
Revenue Recognition Percentage Completion and Completed Contract new (11:30)
Revenue Recognition Installment Method and Cost Recovery new (6:22)
Depreciation Expense x (10:40)
Downloading Colgates Income Statement new (12:21)
Analyst Format Of Colgate-S Income Statement (3:17)
Formatting The Income Statement (2:39)
Investigating The Non-Recurring Charges (4:58)
Seperating non-recurring Items (7:07)
Comparision Of Margins - Before And After Adjustments (3:34)

Accounting: 02 - Balance Sheet

Introduction to Balance Sheet New (3:35)
Introduction to Current Assets (1:56)
Cash And Cash Equivalents (3:30)
Cash And Cash Equivalents - Colgate, PandG, Microsoft (6:05)
Accounts Receivables (1:50)
Accounts Receivables Case Study (10:36)
Inventory (3:02)
Inventory - Case Study (2:08)
Inventory - Lcm (5:52)
Inventory - Colgate (2:27)
Inventory Valuations (8:33)
Inventory Valuation - Recap (2:59)
Prepaid Expenses (2:23)
Other Current Assets - Colgate (1:39)
Financial Reporting Standards (7:42)
Current Liabilities (2:18)
Current Liabilities - Colgate (4:51)
Long Term Assets (7:50)
Introduction to Goodwill (6:37)
Pooling Method Of Accounting (1:51)
Purchase Method Of Accounting (9:09)
Goodwill Impairment (3:56)
Long Term Investments Part 1 (3:03)
Long Term Investments part 2 (7:31)
Long Term Investments - Example (2:53)
Long Term Liabilities (5:52)
Long Term Liabilities - Risk Profile (3:28)
Introduction to Shareholder-s Equity (6:39)
Common Stock - Par Value And Apic (4:31)
Treasury Stock or Shares (4:48)
Retained Earnings and Dividends (4:30)
Additional Other Comprehensive Income (6:30)
Introduction to Preference Shares (3:56)
Macdonald-S Shareholder-S Equity (3:08)
Dividends - Types (2:34)
Cash And Property Dividend - Example (5:32)
Stock Dividends (3:37)
Small and Large Stock Dividends - Example (5:42)
Stock Split (3:06)

Accounting: 03 - Cash Flows Analysis

Introduction To Cash Flows (7:19)
Cfo - Direct Method (6:05)
Cfo - Direct Method - Continued (9:33)
Cfo - Direct Method - Example (7:46)
Cfo - Indirect Method (5:37)
Cfo - Indirect Method - Example (5:22)
Cfi (8:09)
Cff (0:59)
Comprehensive Example - Cfo - Direct Method - 1 (8:09)
Comprehensive Example - Cfo - Direct Method - 2 (3:48)
Comprehensive Example - Cfo - Indirect Method (5:59)
Comprehensive Example - Cfi (4:12)
Comprehensive Example - Cff (3:05)
Comprehensive Example - Ending Cash Balance (2:09)

Accounting: 04 - Financial Analysis Techniq

Horizontal and Vertical Analysis (7:05)
Income Statement - Horizontal and Vertical Analysis - Example (8:01)
Balance Sheet Vertical Analysis - Example (6:37)
Introduction to Ratio Analysis (2:24)
Activity Ratios (6:24)
Activity Ratios - Receivables Turnover (4:37)
Activity Ratios - Inventory and Payables Turnover (6:45)
Activity Ratios - Cash Conversion Cycle Discussion (4:53)
Activity Ratios - Working Capital and Fixed Asset Turnover (6:09)
Liquidity Ratios (8:31)
Solvency Ratios (5:48)
Profitability Ratios (8:37)
Comprehensive Example - Activity Ratio - Cash Conversion - Part 1 (10:24)
Comprehensive Example - Activity Ratio - Cash Conversion - Part 2 (4:53)
Comprehensive Example - Activity Ratio - Working Capital and Fixed Asset Turnover (4:53)
Comprehensive Example - Liquidity Ratios (5:48)
Comprehensive Example - Solvency Ratios (8:50)
Comprehensive Example - Profitability Ratios (8:17)
ROE (9:08)
ROE Example (9:12)
Dividends Payout Ratio (3:42)

Accounting: 05 - Income Taxes

Introduction to Income Taxes - Part 1 (10:53)
Introduction to Income Taxes - Part 2 (6:29)
Sources of Deferred Taxes (1:22)
Deferred Tax Liabilities - Example - Part 1 (10:28)
Deferred Tax Liabilities - Example - Part 2 (6:11)
Deferred Tax Liabilities - Example - Part 3 (6:11)
Deferred Tax Assets - Example (7:08)
Temporary and Permanent Difference (5:48)
Valuation Allowance - Deferred Tax Assets (5:53)
Tax Base - Deferred Taxes (4:27)
Effect of Changes in Tax Rates on Deferred Taxes (4:31)

Banking Operations

Basic functions of Banking (6:01)
Banking channels (11:45)
Organization chart of a bank (8:42)
Account opening process (8:45)
Opening of different types of accounts (9:49)
Need of KYC and AML (11:10)
Dormant accounts (6:17)
Nomination (8:29)
Non resident deposits (5:53)
Bank lending principlels (8:18)
Further Principles of Banks (7:51)
Continuation of principles of banks (5:24)
Nonfund based limits and its assessment (9:05)
Working capital and methods of assessment (4:24)
Continuation of Working capital and methods of assessment (5:09)
Securities, their charging and Retail loans (6:07)
Continuation of Securities, their charging and Retail loans (9:33)
Various forms of charging of securities (9:16)
Mortgages (4:08)
Assignment, Lien and Set off (8:07)
Lending terms and documents (8:00)
Continuation of Lending terms and documents (5:10)
Documentation (7:47)
Procedure for documentation (5:32)
Continuation of Procedure for documentation (6:20)
Post disbursement activities of bank (4:27)
Continuation of Post disbursement activities of bank (5:12)
Non Performing Assets New (4:00)
Continuation of Non Performing Assets (4:29)
Classification of assets (6:07)
Management of NPAs (4:44)
Continuation of Management of NPAs (4:07)
SARFAESI ACT,2002 (7:00)
Processing of payments and CTS sytem (5:52)
Continuation of Processing of payments and CTS sytem (6:19)
Products of payment services (4:26)
Continuation of Products of payment services (5:13)
Collection Services and Forex (8:21)
Core Banking Solutions (5:46)
Inernet frauds (4:42)
Continuation of Inernet frauds (4:49)
Money Mule, Nigerian Scam and safety measures (8:19)

Financial Modeling Tesla

Tesla Unveiled (4:05)
Analyzing Teslas Sales Performance (2:23)
Sourcing Historical Data (6:01)
Navigating Teslas Annual Report (3:38)
Consolidated Financial Statements (5:22)
Historical Revenue Growth Rate (3:02)
Projecting Teslas Revenue (17:38)
Color-Coding in Financial Models (2:53)
Projecting Cost of Sales (18:07)
Forecasting Operating Expenses (9:07)
Working Capital Ratios (7:14)
Working Capital Projections (12:21)
Calculating Proportion of Assets (5:47)
CAPEX Projections (3:31)
CAPEX Distribution (2:21)
Using TRANSPOSE Function (4:14)
Calculating Machinery and Equipment Depreciation (8:38)
Completing Ending Net PPE (9:04)
Common Stock Calculations (5:16)
Retained Earnings Calculations (4:48)
Net Income Attributable to Non-Controlling Interests (7:58)
Provision for Income Taxes (8:21)
Cash Flow Statement (14:11)
Balance Sheet Linkages (9:09)
Completing cash Flow Linkages (11:59)
Cash Available for Debt Repayment (3:03)
Long-Term Debt Payments (6:48)
Income Statement Linkages (11:52)
FCFF Calculations (4:19)
Understanding WACC (4:57)
WACC Calculations (12:08)
Terminal Value Explained (7:19)
NPV Calculation Steps (13:14)
Target Share Price Calculations (5:51)
Sensitivity Analysis (7:13)
Weighted Average Number of Shares (12:11)
Basic & Diluted EPS (5:13)
EBITDA Calculations (3:57)
Tesla Ratio Analysis (16:26)

Merger & Acquisition

Introduction to Merger & Acquisitions on Balance Sheet new1 (11:51)
Merger & Acquisitions on Balance Sheet of Two Organisation new (10:42)
Merger & Acquisitions on Balance Sheet of Two Organisation Continues new (10:32)
Claculating Net Assest in Merger & Acquisitions new (10:01)
More on Merger & Acquisitions on Balance Sheet new (10:50)
Purchase Consideration new (11:37)
More on Purchase Consideration new (8:23)
Relisation Account new (8:21)
Journal Entries in M and A new (10:19)
Journal Entries in M and A Continues new (9:17)
Discuss the Journal Entries (10:31)
Assets and Liabilities (11:00)
Reconstruct the Balance Sheet (5:06)
Current Inventory (8:26)
Security Premium (8:14)

Leveraged Buyout (LBO)

Introduction to LBO (9:38)
Consolidated Balance Sheet (8:59)
Consolidated Balance Sheet Continue (3:14)
Assumptions (11:27)
Assumptions Continue (9:00)
Entry and Exit Price (3:26)
Entry and Exit Price Continue (8:18)
Sources Uses of Funds (6:26)
Opening Balance Sheet (5:59)
Forecast Financial Statements (8:19)
Forecast Financial Statements Continues (12:41)
Debt Amortization Schedule (9:16)
Cash Available for TLB (12:18)
Forecast Financial Statements and IRR (9:00)
More on Forecast Financial Statements 5 and IRR (5:11)
IRR Sensitivity (8:19)

Private Equity

Introduction Private Equity Modelling (6:44)
Illustration for Accounting Approach (2:59)
Illustration for Accounting Approach Continues (11:52)
Overview of Trade and Private Firm (7:30)
Valuing of Private Firm (7:32)
Illustration for Fundamental Approach in Private Firm (6:20)
Illustration for Fundamental Approach in Private Firm Continues (5:05)
Bottom Up Approach to Estimate the Levered Risk (7:05)
Estimate Levered Risk for Info Soft (7:11)
Adjusting for Non Diversification in Bottom Up Approach (4:17)
Illustration for Non Diversification in Bottom Up Approach (7:35)
Alternative Adjustment for Private Firm Risk (11:32)
Cost of Equity to Cost of Capital (1:14)
Debt Ratio in (9:53)
Illustration to Esitmate Cost of Capital (9:06)
Cash Flow in Equity Modeling (10:54)
Illustration on Operating and Net Income (11:48)
Illustration on Operating and Net Income Continues (6:44)
Growth in Equity Modeling (12:12)
Illustration on Estimating Growth (8:10)
Key Person Effect on Value (11:14)
Illiquidity Discount in Equity Modeling (10:55)
Example of Illiquidity Discount (5:41)
Valuation Motives and Value Estimates in Equity Modeling (8:08)
Illustration on Valuation Motives (10:41)
Illustration on Value Estimates (11:35)
Illustration on Value Estimates Continues (7:18)

Fixed Income

Introduction to Fixed Income Market (9:25)
Principal Repayment Structure (8:36)
Coupon Repayment Structure (10:45)
Global Fixed Income Market (8:26)
Primary and Secondary Bond Market (8:11)
Types of Issuer of Fixed Income Market Continues (10:33)
Fixed Income Valuation (9:02)
Example of Fixed Income Valuation (8:38)
Example of Fixed Income Valuation Continues (4:23)
Prices and Yields (7:36)
Prices and Yields Continue (9:07)
Certificate of Deposite (9:55)
Floating Rate Note (10:35)
Mony Market (12:56)
Understanding Fixed Income Risk and Return (10:16)
Souces of Rturn (7:46)
Interest Rate Risk on Fixed Rate Bonds (9:41)
Approximate Modified Duration (9:40)
Computation of Fixed Income (7:52)
Mony Duration (7:53)
Approximate Convexity (10:45)
Fundamentals of Credit Analysis (10:28)
Fundamentals of Credit Analysis Continue (8:18)
More on Fundamentals of Credit Analysis (8:31)
Credit Analysis Model (7:14)
Credit Analysis Model Continue (6:55)
Moe on Credit Analysis Model (8:09)
Backed Securities (9:32)
Residentioal Mortagage Loans (8:56)
Commercial Mortgage (7:06)
Collateralized Debt Obligations (6:31)
The Arbitration-Free Framework (9:34)
Example of The Arbitration-Free Framework (6:59)
Pricing Bonds using a Binomial Tree (11:09)
Calibrating Binomial Tree (9:23)
Bond with Embedded Options (11:18)
Example of Embedded Options (7:16)
Bond with Interest Rate Volatility (10:54)
Valuation of a Floored Floater (6:01)
The Term Structure and Interest Rate Dynamics (12:10)
The Term Structure and Interest Rate Dynamics Continues (11:05)
More on Term Structure and Interest Rate Dynamics (12:26)
Framework for Fixed Income Portfolio Management (7:41)
Managing Funds Against Bond Markets (9:04)
Managing Funds Against Liabilities (6:45)
More on Managing Funds Against Liabilities (9:24)
Fixed Income Strategies (12:13)
Fixed Income Strategies Continues (10:34)
International Bond Investment (8:51)
Selecting Fixed Income Manager (6:30)
Relative-Value Methodologies for Global Portfolio Management (9:55)
Relative-Value Methodologies for Global Portfolio Management Continues (7:27)

Venture Capital

Introduction to Venture Capital (6:10)
Feature of Venture Capital (8:44)
Stages of Venture Capital (11:54)
Advantages Of Venture Capital (9:12)

Teach online with

VLookUp Function

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock