Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pro Tips for Power Users
Getting Started
Course Structure & Outline (1:58)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
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
Formatting Tips
Introduction (0:26)
Formatting Shortcuts (4:28)
Snap to Grid (4:30)
Hiding Workbook Elements (4:03)
Format Painter (6:41)
Color & Border Design (7:03)
Freezing Panes (5:58)
Center Across Selection (4:33)
Invisible Text Formatting (3:55)
Zip Codes & Phone Numbers (5:09)
Grouping Columns & Rows (6:25)
Formatting Errors with IFERROR (5:50)
Converting Text to Date Values (10:39)
Formula-Based Formats (10:41)
Advanced Number Formats (10:37)
QUIZ: Formatting Tips
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
Visualization Tips
Introduction (0:24)
Chart Properties (Move & Size) (5:08)
Hidden Chart Source Data (2:43)
Filled Maps (Excel 2016+) (5:10)
Customizing Charts to Tell a Story (8:53)
Adding Sparklines (7:44)
Custom Chart Templates (6:06)
Heat Maps with Color Scales (7:11)
Analyzing Distribution with Histograms (9:28)
Goal Pacing with Gauge Charts (10:26)
Highlighting Time Periods (8:05)
Dynamic Source Ranges (12:08)
Interactive Form Controls (11:48)
QUIZ: Visualization Tips
PivotTable Tips
Introduction (0:18)
Customizing the Field List (4:07)
Autofitting Column Width (4:21)
Outline & Tabular Layouts (7:46)
Counting Non-Numerical Fields (6:05)
Grouping Dates (8:03)
Enabling Multiple Filters (5:00)
Grouping Values (6:50)
Adding Value Calculations (9:01)
Showing Empty Items (6:22)
Configuring Slicers & Timelines (10:23)
Conditional Formatting (8:23)
Removing & Reviving Source Data (8:19)
Adding Custom Sort Lists (5:23)
Solve Order & List Formulas (6:16)
QUIZ: PivotTable Tips
Analytics Tips
Introduction (0:29)
Quick Analysis Tools (6:03)
Scenario Manager (7:55)
Optimizing with Goal Seek (6:33)
Basic Forecasting (11:09)
Outlier Detection (9:24)
Automated Data Tables (8:06)
Power Query Tools (10:41)
Data Modeling 101 (10:23)
CUBE Functions (16:21)
Monte Carlo Simulation (11:38)
Advanced Optimization with Solver (12:16)
Analysis ToolPak (Preview) (8:10)
QUIZ: Analytics Tips
Wrapping Up
Resources & Next Steps (1:56)
More from Maven Analytics
Pivot-Style Reports with Formulas
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock