Learn simple formatting tips to make your spreadsheet data more readable and compelling.Learn simple formatting tips to make your spreadsheet data more readable and compelling.
Overview
Syllabus
Introduction
- Save time with effective Excel formatting
- Formatting with fonts
- Cell fill and borders
- Alignment options and what to avoid
- Important number formats
- Custom number formats
- Scaling
- Date and time formats
- Symbols in formats
- Conditional color formats
- Leading and trailing characters
- Default styles
- Custom styles
- Themes
- Built-in rules
- Data bars
- Color scales
- Icons
- Conditional formatting formulas
- Manage rules
- Where to learn more
Taught by
Dennis Taylor