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.
MP4 video/audio file [71.6 MB]
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.
MP4 video/audio file [44.0 MB]
Simple XLOOKUP in MS Excel
This screencast talks about how to do a simple XLOOKUP in Excel.
MP4 video/audio file [11.7 MB]
XLOOKUP Horizontal
This video shows how to ue the XLOOKUP function in Excel in horizontal manner with a sample data.
MP4 video/audio file [4.8 MB]
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.
MP4 video/audio file [11.9 MB]
This video compares XLOOKUP vs. INDEX_MATCH function.
MP4 video/audio file [9.1 MB]

 ADVANCEd   Excel                                     Access                 databases                                       VBA macros                                       SQL scripts                                       BI Reports                                         data   integrity                                          big data                                             data science                                   data mining                                     data mapping                                   data profiling                                 data   visualization                                   data modeling                                 financial     analysis                                           SCORE CARDS                                     BENCHMARKS                                     PERFORMANCE   KPI METRICS

Print Print | Sitemap Recommend this page Recommend this page
© Ray Erden

This website was created using 1&1 IONOS MyWebsite.