Excel VBA Project with Assistance from ChatGPT
Excel Business Intelligence Dashboard for Sales Tracking
This video shows three Excel examples with VBA to illustrate how to use ChatGPT in the process which is extremely useful in order to achieve particularly coding aspects of data analysis work.
This video shows a simple pivot table and its data source to illustrate how automatically multiple pivot tables can be updated for dynamically changing data ranges.
Index Function Demo in ExcelIn this sample I present how to use Index function where VLOOKUP function may not provide enough power to work for more complex lookup tasks.
Excel Power Query Demo
Excel Macro to Copy File Names
Excel Financial Calculations via VBA
Power BI Sample
Excel Dynamic Range Update
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_INDEX_MATCHThis video compares XLOOKUP vs. INDEX_MATCH function.