01:07:37

Mastering vector operations in MS Excel

08:35

How to determine SWP in volatile returns environment?

09:18

How to model depreciation under straight line method?

08:46

IDC circularity solved!! Modelling interest during construction without circular reference

05:27

How to do mid-year discounting in MS Excel using the NPV function? | Mid-year discounting formula

05:19

Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative

10:00

How to automate calculation in MS Word and Zoho Writer? | Sum, Product and many more

06:19

1 Cell referencing

05:28

How to repeat set of values varying number of times in MS Excel

06:33

How to automatically add numbering to text in a single cell in MS Excel?

16:56

Introduction to equity and business valuation - Part 1

08:21

How to add data labels to waterfall chart created with Up down bars?

07:49

How to connect slicer to waterfall charts in MS Excel?

10:55

How to create waterfall charts in MS Excel

10:26

How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars

01:01

What is the difference between Value and NumberValue function

07:20

Find number of days employees worked in a month

05:48

Trim function not working? No-break space could be the reason

20:31

MS Excel 101: Text functions in MS Excel

09:24

How to apply slicer on formulas in MS Excel

13:04

How to value life insurance company? | Embedded value and distance to market cap

01:02:24

Mathematical thinking for MS Excel, financial modelling and programming

04:22

XLOOKUP vs Lookup vs Index Match? Xlookup performance issues

18:06

When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models

11:41

How to calculate portfolio draw down in MS Excel?

14:07

When and how to use ByRow and ByCol functions in MS Excel

10:13

Create dynamic debt amortization schedule with just one function using Lambda

04:06

Reverse wild card lookup | How to lookup when lookup value is in between a larger text?

08:01

Create Lambda function step by step | ProductIF

05:40

Instead of using Nested IF, use LOOKUP and XLOOKUP

08:43

How to work with form controls in MS Excel? Get same input from multiple sheets in a workbook

02:15

How to create dummy variable for credit risk analytics in MS Excel and PowerBI (using PowerQuery)

01:58

How to get a clean interface in MS Excel

02:52

How to rearrange a column into table in MS Excel?

01:50

How to keep track of output in different sheet

03:29

How to work with GetPivotData function in MS Excel | Get dynamic result with GetPivotData function

02:36

Calculate year over year growth rates and ratios using Pivot Table

01:15

Mask a cell in MS Excel | How to display a text that is different from actual cell content

01:39

MS Excel short cut keys for formatting numbers

04:31

Lambda - bringing function libraries to MS Excel

25:04

Date functions in MS Excel - complete tutorial

04:31

How to compute YTD numbers in MS Excel? | 3 ways to get Year to Date Sales in MS Excel

12:11

How to prevent sorting from messing your calculations in MS Excel? | Make calculations Sort Proof

36:19

Lambda and functional programming in MS Excel

02:54

Do you know about the Y2K30 problem?

01:28:51

All about financial modelling - Webinar

02:04

How to automatically replace or create line breaks in MS Excel?

03:10

How to solve complex ratio analysis problem? | Reverse flow charting for ratio analysis

06:18

How to build financial model for a start-up or new business?

17:17

How to build powerful self-service dashboards with any formula

04:54

How to create dynamic stock price chart in MS Excel| How to link a dynamic range to a chart in Excel

24:34

Advanced Filter function in MS Excel | Office 365 | How to filter table based on large criteria set?

06:04

How to properly align paragraph in MS Word?

03:28

Get your sentences neatly aligned in MS Word using TAB stops

16:03

How to do management analysis for equity research?

08:33

Modeling traffic, volume and others using logarithmic path

04:49

How to use index and match function as replacement for Vlookup and IF function | Say No to IF

23:52

How to extract individual words from a string in MS Excel? | How to create word cloud in MS Excel?

22:33

Reverse flow charting | Problem solving techniques for financial modeling

03:16

How to get fiscal quarter or fiscal month in MS Excel and Zoho Sheets | Do it the right way