Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Free Preview: Excel Pro Tips for Power Users
Getting Started
About this Preview Course
Course Structure & Outline (1:58)
Downloading the Course Resources
Setting Expectations (1:45)
Productivity Tips
Introduction (0:29)
Customizing the Footer (4:03)
CTRL Shortcuts (8:01)
ALT Key Tips
"Go To" Special Options
Removing Blank Rows
Data Validation Drop-Downs (7:11)
Autofill & Flash Fill
Customizing the Ribbon
Splitting Text to Columns
Synchronous Scrolling
Extracting Unique Values
Named Range & Table References
Protecting Cells & Formulas (8:09)
Multi-Level Row & Column Sorting
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
Format Painter
Color & Border Design
Freezing Panes (5:58)
Center Across Selection
Invisible Text Formatting
Zip Codes & Phone Numbers
Grouping Columns & Rows
Formatting Errors with IFERROR
Converting Text to Date Values
Formula-Based Formats (10:41)
Advanced Number Formats
QUIZ: Formatting Tips
Formula Tips
Introduction (0:28)
Manual vs. Automatic Calculation (4:19)
Formula Line Breaks (4:05)
Converting Units of Measurement
Real-Time Tools with TODAY & NOW
Formula Auditing Tools
Pivot-Style Reports with Formulas
Counting Words in a Cell
Dependent Drop-Downs with INDIRECT (8:28)
Hyperlinking Between Worksheets
"Fuzzy Match" Lookups
Random Selection with OFFSET & RANDBETWEEN (6:26)
Combining INDEX & MATCH
Matching Items Between Lists (11:00)
Counting Duplicates with SUMPRODUCT
Many-to-Many Lookups
QUIZ: Formula Tips
Visualization Tips
Introduction (0:24)
Chart Properties (Move & Size) (5:08)
Hidden Chart Source Data (2:43)
Filled Maps (Excel 2016+)
Customizing Charts to Tell a Story
Adding Sparklines
Custom Chart Templates
Heat Maps with Color Scales (7:11)
Analyzing Distribution with Histograms
Goal Pacing with Gauge Charts
Highlighting Time Periods
Dynamic Source Ranges
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
Counting Non-Numerical Fields
Grouping Dates
Enabling Multiple Filters
Grouping Values
Adding Value Calculations
Showing Empty Items
Configuring Slicers & Timelines
Conditional Formatting (8:23)
Removing & Reviving Source Data
Adding Custom Sort Lists (5:23)
Solve Order & List Formulas
QUIZ: PivotTable Tips
Analytics Tips
Introduction (0:29)
Quick Analysis Tools (6:03)
Scenario Manager (7:55)
Optimizing with Goal Seek
Basic Forecasting
Outlier Detection
Automated Data Tables
Power Query Tools
Data Modeling 101
CUBE Functions
Monte Carlo Simulation
Advanced Optimization with Solver (12:16)
Analysis ToolPak (Preview)
QUIZ: Analytics Tips
Wrapping Up
Resources & Next Steps (1:56)
Dependent Drop-Downs with INDIRECT
Complete and Continue