Screencasts


Introduction to Structured References with Tables

Published on May 18, 2017 at 03:46PM

Excel formulas are better with Structured References for Tables.

VLOOKUP vs INDEX MATCH

Published on May 18, 2017 at 03:45PM

What's better than a VLOOKUP? INDEX MATCH!!

Introduction to Visual Basic for Applications VBA

Published on May 18, 2017 at 03:32PM

A short introduction to VBA by building something simple

Introduction to the Visual Basic Editor VBE

Published on May 13, 2017 at 11:55PM

Go under the Excel hood by getting to know the Visual Basic Editor. The power house of the Excel workbook.