Excel: Introduction to Formatting

Excel: Introduction to Formatting

1h 6mIntermediate2023-09-01

Authors

Mynda Treacy

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

Introduction

  • Save time with effective Excel formatting

Cell Formats

  • Formatting with fonts
  • Cell fill and borders
  • Alignment options and what to avoid
  • Important number formats

Custom Formats

  • Custom number formats
  • Scaling
  • Date and time formats
  • Symbols in formats
  • Conditional color formats
  • Leading and trailing characters

Cell Styles and Themes

  • Default styles
  • Custom styles
  • Themes

Conditional Formatting

  • Built-in rules
  • Data bars
  • Color scales
  • Icons
  • Conditional formatting formulas
  • Manage rules

Conclusion

  • Where to learn more
40,000 Toman