Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Excel Pro Tips: Formulas & Functions
Getting Started
Course Structure & Outline (1:41)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
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)
"Fuzzy 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
Hyperlinking Between Worksheets
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock