Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pro Tips: Productivity Tools
Getting Started
Course Structure & Outline (1:41)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
Important Note for StackSkills Students
Productivity Tips
Introduction (0:29)
Customizing the Footer (4:03)
CTRL Shortcuts (8:01)
ALT Key Tips (6:53)
"Go To" Special Options (4:36)
Removing Blank Rows (3:17)
Data Validation Drop-Downs (7:11)
Autofill & Flash Fill (8:26)
Customizing the Ribbon (6:53)
Splitting Text to Columns (7:39)
Synchronous Scrolling (2:58)
Extracting Unique Values (4:06)
Named Range & Table References (8:12)
Protecting Cells & Formulas (8:09)
Multi-Level Row & Column Sorting (10:54)
Advanced Filter Criteria (9:27)
QUIZ: Productivity Tips
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Course Structure & Outline
Complete and Continue