HLOOKUP-LEFT-RIGHT-MID-LEN | EDUCBA

Autoplay
Autocomplete

Previous Lesson Complete and Continue

PROJECT FINANCE

Microsoft Excel - Beginners

Accessing MS Excel (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 (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 (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 - Beginners

Logical Function - IF (8:21)
AND OR and XOR Functions (8:41)
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)

Advanced Excel Practicals: Essentials for the Real World

Case Study Overview (8:34)
AND-OR (6:56)
SUM-MOD-SUMIF (9:38)
SUMIFS-AVERAGEIF-AVERAGEIFS (8:47)
VLOOKUP-INDEX-MATCH (8:58)
HLOOKUP-LEFT-RIGHT-MID-LEN (12:13)
Histogram (10:00)
Sparklines (5:16)
Thermometer Chart (6:55)
Scatter Plot (5:56)
Creating a Pivot Table (9:30)
Advanced usage of Pivot Tables (6:02)
Using What If Analysis (6:00)
Data Tables (7:48)
Department Data Validation (8:47)
Introduction to Macros (8:06)
Continuing with Macros (9:15)
Running a Macro (7:42)
Recorder Problems (11:30)
Using Message Boxes (7:36)
Message Box Statement (5:35)

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 (6:34)
Income Statement Format (8:23)
Calculating Profit Margins (2:33)
Non Recurring Items (9:10)
Changes In Accounting Estimates (3:00)
Final Remarks (3:09)
Revenue Recognition Percentage Completion and Completed Contract (11:30)
Revenue Recognition Installment Method and Cost Recovery (6:22)
Depreciation Expense (10:40)
Downloading Colgates Income Statement (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 (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 Techniques

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)

Project Finance Modeling - From Novice to Expert

Introduction To Project Finance, Learning Objectives And Overview (2:25)
What Is Project Finance (11:30)
Project Finance Continued (8:40)
Estimating The Cost Of The Project (3:42)
Feasibility Analysis - Part 1 (5:04)
Feasibility Analysis - Part 2 (7:11)
Means Of Finance (4:01)
Risk Analysis And Mitigation (6:14)
Important Ratios In Project Finance (5:29)
Introduction To Project Finance Modeling (3:15)
Assumptions - Project Model & Steps (5:02)
Assumptions - Operating (6:31)
Assumptions - Expenses And Equity (5:22)
Revenue Indicators And Assumptions (6:22)
Calculating Operating Revenues (11:53)
Operating Cost & Tax Calculations (6:01)
Calculating Project Cost (6:03)
Calculating Debt Drawals (5:28)
Idc And Circular Loops (7:13)
Land Building And Civil Works (8:05)
Misc Fixed Assets (4:16)
Idc Allocation (5:54)
Completing The Income Statement (4:15)
Calculating Principal Repayments (4:12)
Completing The Balance Sheet (7:17)
Completing The Cash Flow Statements (8:03)
Calculating Dscr (6:07)
Calculating Project Irr (5:48)
Calculating Npv (2:27)
Formatting The Project Model (8:06)
Sensitivity Analysis - Interest Rate And Irr (5:38)
Sensitivity Analysis - Parking Charges And Irr (3:52)
Preparing A Project Finance Report (4:15)
Conclusion Of Project Finance (3:37)

Project Finance Tutorials

Introduction to Project Finance (10:46)
Agenda (11:33)
InfraStructure in India (2:22)
Types of Projects (7:48)
Tipical Project Statges (5:32)
Characteristics of Project Finance (8:18)
Risk and Mtigants (4:55)
Example of Risk and Mitigants (12:00)
More on Risk and Mitigants (6:49)
More on Risk and Mitigants Continues (6:03)
Implicit Political Risk in Project Finance (9:19)
Repayment in Project Finance (9:11)
Example of Pricing in Project Finance (10:57)
Example of Pricing in Project Finance Continues (9:47)
Basic and Date Function in Project Finance (5:21)
More on Date Function in Project Finance (7:15)
H Lookup in Project Finance (8:37)
Pivot Table in Project Finance (9:24)
Working with BOT Scheme in Project Finance (12:00)
More on BOT Scheme (10:53)
Revenues and Bot Cost in BOT Scheme (11:46)
Revenues and Bot Cost in BOT Scheme Continues (11:16)
Case Study Example in Project Finance (7:39)
How to Find Date in Bot Revenue Scheme (9:41)
Concept of Swap Agreement (6:51)
Forward Rate Agreement (6:47)
Costing on Total Project (5:38)
Calculating in New Derivatives (7:24)
Cash Waterfall Model (4:46)
Internal Rate of Return (4:32)
More on Cash Waterfall Model (6:35)
Cashfow for Internal Rate of Return (6:56)
Net Cashflow in IRR (5:42)
BECK Cashflow in IRR (8:20)
Calculating Cashflow in IRR (5:24)
Cashflow for KAP in IRR (6:05)
Net Cashflow Statements (6:49)

Project Finance

Contents (1:22)
Introduction to Project Finance (5:12)
Features of Project Finance (7:08)
Project Fin vs Corporate Fin (2:43)
Project Finance Structure (1:51)
Importance of Project Finance (1:20)
Types of Project Finance (9:32)
Steps in Project Implementation (3:16)
Project Cost (10:58)
What is Feasibility Analysis (6:24)
Understand Feasibility Analysis (8:41)
Manpower Feasibility (5:29)
Economic Feasibility (6:15)
Valuation and Financial Feasibility (7:36)
Valuation and Financial Feasibility Continues (8:40)
Purchasing Power Adjustments (6:16)
Means of Financing (4:52)
Risk Analysis (9:20)
Ratio and Fin Analysis (8:50)
Break Even Analysis (7:20)
Sensitivity Analysis (8:26)
Current Ratio (5:21)
Debt Equity Ratio (7:55)
Creditors Turnover Ratio (7:24)
Project Finance Modeling (1:27)
Steps of PFM (11:08)
Complete the Assumptions (3:35)
Working on Cash Flow (6:54)
Working on Cash Flow Continues (8:10)
Calculate EBT (10:44)
Balance sheet (5:09)
Working on IRR and NPV (4:27)
Ratio Analysis (8:15)
Ratio Analysis Continues (7:53)

Teach online with

HLOOKUP-LEFT-RIGHT-MID-LEN

Lesson content locked

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

Enroll in Course to Unlock