This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Connect Values in Excel using Lookup Functions (Intermediate)
Course Workbook
DOWNLOAD: Course Workbook
VLOOKUP
Lookup Types & Exact VLOOKUP (5:28)
EXERCISE: Coffee Shop Menu (2:39)
Approximate VLOOKUP (2:30)
EXERCISE: Commission Payout (4:05)
INDEX
The INDEX Function (1:20)
EXERCISE: Food Menu Search, Pt 1 (3:46)
MATCH
The MATCH Function (2:33)
EXERCISE: Food Menu Search, Pt 2 (7:52)
Combining Concepts
VLOOKUP & MATCH (0:57)
EXERCISE: Coffee Shop Revisited, Pt 1 (4:02)
INDEX & MATCH (1:22)
EXERCISE: Coffee Shop Revisited, Pt 2 (3:46)
EXERCISE: Matching SKU to Menu Item (5:37)
OFFSET
OFFSET (2:17)
EXERCISE: New & Returning Customers (13:39)
Course Solutions
Solutions Workbook
EXERCISE: Commission Payout
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock