08:17

LAMBDA Excel Lesson 6 of 8: The =TSM() Function

08:13

LAMBDA Excel Lesson 5 of 8: The =EOQUARTER() Function

04:19

LAMBDA Excel Lesson 4 of 8: The =IMPLIEDG() Function

03:33

LAMBDA Excel Lesson 3 of 8: Create a DSO function using Excel LAMBDA

04:53

LAMBDA Excel Lesson 2 of 8: Creating the CAGR Function

07:36

LAMBDA Excel Course Lesson 1: Create your first LAMBDA function in Excel!

11:43

An example where XLOOKUP loses to Index XMatch

02:22

XLOOKUP is Magic: Using XLOOKUP to Generate Multiple Values

04:47

Scenario Analysis Using XLOOKUP: 4 Minute Quick Lesson

05:27

Nested (Two-Way) XLOOKUP vs INDEX XMATCH

08:47

XLOOKUP in Excel: Why it Rocks and Comparison to VLOOKUP and Index Match

07:41

How to Calculate Project Returns in a Project Finance Model (XNPV and XIRR)

07:06

Debt Sizing: Creating a Copy-Paste Macro in a Project Finance Model (Part 1)

05:32

Debt Sizing: Creating a Copy-Paste Macro in a Project Finance Model (Part 2)

05:49

Debt Sizing: Creating a Copy-Paste Macro in a Project Finance Model (Part 3)

07:23

Project Finance - How the Financial Statements Fit Together

13:07

Modeling Debt Sculpting Through the DSCR Target Ratio in a Project Finance Model

17:00

Modeling Sources & Uses of Funds During Construction in Project Finance

09:41

Project Finance: Flexing scenarios through a scenario manager & data table

08:07

What is Funds from Operations (FFO)? | Quick Lesson

10:02

Cap Rate, Explained | Quick Lesson

02:35

What is Net Operating Income (NOI)? | Quick Lesson

03:32

Attaching Macros to Buttons

02:10

Cell Selection Change

04:04

Checkboxes and IF:THEN Logic

02:45

Creating a Procedure

02:46

Debugging VBA Code

03:04

Starting out with the Macro Recorder

07:19

The Cells Objects and Loops

05:23

Worksheet Events

09:34

5 PowerPoint Strategies to Maximize Your QAT Workflow

03:55

PowerPoint QAT Guide Shortcuts

02:23

PowerPoint Ribbon Guide Strategies

09:02

PowerPoint Ribbon Shortcuts

07:10

PowerPoint Hold Shortcuts with a Twist

08:51

PowerPoint Visible Shortcuts

08:37

PowerPoint Power Shortcuts

07:58

PowerPoint Shift Shortcuts Quiz and Demos

02:51

PowerPoint Shift Shortcuts

02:57

Power Cropping Images PowerPoint Hack

02:54

The #1 Rule to Being REALLY FAST at PowerPoint

04:15

Why Bother Learning PowerPoint Shortcuts?

02:00

PowerPoint Shortcuts for Investment Bankers Introduction

02:59

PowerPoint Secret 5: Quickly Format Your Charts

05:52

PowerPoint Secret 4: Using Sum Functions to check math "Totals"

04:30

PowerPoint Secret 3: Quickly Crop and Resize Photos

04:31

PowerPoint Secret 2: Quickly Think of New Layout Ideas

04:10

PowerPoint Secret 1: Using List Level Shortcuts Properly

07:54

Project Finance Mini Course - Part 7 of 7

06:16

Project Finance Mini Course - Part 6 of 7

05:38

Project Finance Mini Course - Part 5 of 7

04:53

Project Finance Mini Course - Part 4 of 7

05:59

Project Finance Mini Course - Part 3 of 7

10:57

Project Finance Mini Course - Part 2 of 7

01:11

Project Finance Mini Course - Part 1 of 7

04:22

Tax Reform Headlines

11:36

Football Field Valuation

04:16

Financial Restructuring Mini Course - 10 of 11 - Valuation

03:57

Financial Restructuring Mini Course - 09 of 11 - Restructuring Plan Continued

07:02

Financial Restructuring Mini Course - 02 of 11 - Simple Example