EXCEL SCREENCASTING
I created below videos to illustrate some select concepts and methods in Microsoft Excel utilizing spreadsheet formula level functions, user defined functions, VBA, Microsoft Query, Power Pivots, DAX, Power BI and using ChatGPT as an assistant in data analysis, coding and data manipulation projects.

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 Excel
In 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 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.

XLOOKUP_INDEX_MATCH
This video compares XLOOKUP vs. INDEX_MATCH function.

www.rayerden.com