VBA Tutorial Video 4: Excel and VBA Tips: Data Validation Tool, OFFSET, VLOOKUP, and Pivot Tables

Excel Document:

Reference Material:
VBA For Modelers, 5th Edition by Christian Albright

A Few Excel Tips: Data Validation Tool, Offset and VLOOKUP, Dynamic Charts, Form Controls, Pivot Tables, VBA Help, Ivey Publishing, Dennis Li, Mehmet A. Begen

Time Stamps:
0:00 Introduction to Excel and VBA Tips
1:02 Data Validation Tool
3:57 OFFSET Function
5:57 Offset VBA Object
7:21 VLOOKUP Function
9:11 Pivot Tables
12:41 Outroduction