EXCEL SCREENCASTING
Below videos illustrate various concepts and methods that can be performed in MS Excel.

Index Function Demo in Excel
In this sample I present how to use Index function where VLOOKUP function fails to work for more complex lookup tasks.

Time Value of Money Excel Application
This video displays how Excel VBA programming can be used to cerate a simple application for the user to perform some financial calculations for personal finance. They could be borrowing decision, loan or mortgage payment plan, saving plans etc.

Simple XLOOKUP in MS Excel
This screencast talks about how to do a simple XLOOKUP in Excel.

XLOOKUP Horizontal
This video shows how to ue the XLOOKUP function in Excel in horizontal manner with a sample data.

XLOOKUP in Reverse Order
This video decribes how to use XLOOKUP function to obtain the values that are on the left side of the lookup field unlike VLOOKUP function.