Excel Screencasting:

I created below screencasts on some Excel examples to illustrate some select the concepts and methods audiovisually.

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]

 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.