Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pro Tips: Formatting
Getting Started
Course Structure & Outline (1:41)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
Important Note for StackSkills Students
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
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Setting Expectations
Complete and Continue