Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pro Tips: Formulas
Getting Started
Course Structure & Outline (1:41)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
Important Note for StackSkills Students
Formula Tips
Introduction (0:28)
Manual vs. Automatic Calculation (4:19)
Formula Line Breaks (4:05)
Converting Units of Measurement (5:50)
Real-Time Tools with TODAY & NOW (10:18)
Formula Auditing Tools (11:18)
Pivot-Style Reports with Formulas (8:37)
Counting Words in a Cell (7:24)
Dependent Drop-Downs with INDIRECT (8:28)
Hyperlinking Between Worksheets (8:13)
Approximate Match Lookups (7:15)
Random Selection with OFFSET & RANDBETWEEN (6:26)
Combining INDEX & MATCH (8:40)
Matching Items Between Lists (11:00)
Counting Duplicates with SUMPRODUCT (8:59)
Many-to-Many Lookups (9:53)
QUIZ: Formula Tips
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Counting Duplicates with SUMPRODUCT
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock