Index Function Demo in ExcelIn 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 ApplicationThis 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.
Copy file names from a selected folder into Excel
Simple XLOOKUP in MS ExcelThis screencast talks about how to do a simple XLOOKUP in Excel.
XLOOKUP HorizontalThis video shows how to ue the XLOOKUP function in Excel in horizontal manner with a sample data.
XLOOKUP in Reverse OrderThis video decribes how to use XLOOKUP function to obtain the values that are on the left side of the lookup field unlike VLOOKUP function.
XLOOKUP and INDEX MATCH FunctionThis video decribes the advantage of using XLOOKUP function as oppose to INDEX MATCH fuinction to achieve the same outcome via faster and easier way.
Excel Power Query Demo for Merging Data Sets
Excel Pivot Table Data Range Automation
Excel Business INtelligence Dashboard