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.

Power BI Data Visualization

Excel Pivot Table Data Range Automation

Excel Business INtelligence Dashboard