Excel: Introduction to Formatting
1h 6mIntermediate2023-09-01
Authors
Mynda Treacy
Course details
Get a quick crash course in Excel formatting that will help transform your spreadsheets from boring to compelling. Microsoft Excel MVP Mynda Treacy takes you through the fundamentals of formatting in Excel and along the way drops pro tips and tricks she has accumulated in over 20 years of working with Excel. Topics include how to emphasize data with fonts, borders, colors, and the pitfalls to avoid. Learn how to control alignment, write custom number formats, accentuate dynamic data with conditional formatting, and use styles to transform the look and feel of spreadsheets with one click.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Save time with effective Excel formatting
1. Cell Formats
- 02 - Formatting with fonts
- 03 - Cell fill and borders
- 04 - Alignment options and what to avoid
- 05 - Important number formats
2. Custom Formats
- 06 - Custom number formats
- 07 - Scaling
- 08 - Date and time formats
- 09 - Symbols in formats
- 10 - Conditional color formats
- 11 - Leading and trailing characters
3. Cell Styles and Themes
- 12 - Default styles
- 13 - Custom styles
- 14 - Themes
4. Conditional Formatting
- 15 - Built-in rules
- 16 - Data bars
- 17 - Color scales
- 18 - Icons
- 19 - Conditional formatting formulas
- 20 - Manage rules
Conclusion
- 21 - Where to learn more