A Few Excel Tips: Data Validation Tool, Offset and Vlookup, Dynamic Charts, Form Controls, Pivot Tables, VBA Help

Name: A Few Excel Tips: Data Validation Tool, Offset and Vlookup, Dynamic Charts, Form Controls, Pivot Tables, VBA Help (English version)
SKU: 9B11E018

Mehmet A. Begen; Dennis Li

Product #:9B11E018

Supplier:Ivey

Discipline:Management Science

Setting:2011

Details:Note (PDF) • 14 pages • 2011-06-30 (Rev: 2018-01-17)

Subjects:

Analytics and data science Data science

Your Price:

$10.54

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

This note is designed to give readers an overview of some useful tools within Microsoft Excel and Visual Basic for Applications (VBA), including offset, vlookup, dynamic charts, form controls, and pivot tables. These tools have purposes such as eliminating errors in data entry or extracting insights from large sets of categorical data. This note contains explanations followed by examples and screenshots for each tool.