Agenda
*Where to get help.
*Modeling
​*Project Work

• Help with Lynda
• Formulas and Functions
• V-Lookup and H-Lookup
• Macros​
• Pivot Tables and Pivot Charts

​

Formulas, Functions and More

Functions

Order of Operations

Please Excuse My Dear Aunt Sally.

---

V-Lookups and H-Lookups

V-LookUp Demo File

 VLookUp Challenge I
VLookUp Challenge II

Macros

Macro Demo File

​

---

Pivot Tables

Lynda's Pivot Tables Demo File

Lynda's Data Analysis Demo File

​

---

Pivot Charts