EXCEL SCREENCASTING
I created below screencasts using Excel examples to illustrate some select concepts and methods audiovisually. The application that I used to create these screencasts is Screenpresso.

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.

Copy file names from a selected folder into Excel

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 and INDEX MATCH Function
This 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

Power BI Data Visualization

Excel Pivot Table Data Range Automation

Excel Business INtelligence Dashboard

EXCEL SCREENCASTING I created below screencasts using Excel examples to illustrate some select concepts and methods audiovisually. The application that I used to create these screencasts is Screenpresso.

Power BI Data Visualization

www.rayerden.com

EXCEL SCREENCASTING
I created below screencasts using Excel examples to illustrate some select concepts and methods audiovisually. The application that I used to create these screencasts is Screenpresso.