Excel: Introduction to Formatting (2019)
59mBeginner2019-01-17
Authors
Dennis Taylor
Excel expert with 25+ years of experience
Course details
Get a quick crash course in Excel formatting to make your spreadsheets more readable and compelling. Dennis Taylor shows the basics of formatting in Excel, including how to emphasize data with fonts, borders, and colors. Learn how to adjust the formatting of numbers, dates, and times; create value-based conditional formatting; adjust rows and columns without commands; and easily copy and even paint formatting across multiple cells.
Learning objectives
Controlling fonts, borders, colors, and alignment
Adjusting numeric formats quickly
Accentuating dynamic data with conditional formatting
Adjusting rows and columns
Learning objectives
Controlling fonts, borders, colors, and alignment
Adjusting numeric formats quickly
Accentuating dynamic data with conditional formatting
Adjusting rows and columns
Skills covered
Office 365Microsoft 365SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
Introduction
- Formatting tips to build compelling spreadsheets
Control Fonts, Borders, Cell Colors, and Alignment Options
- Adjust fonts and cell colors
- Apply border styles, gridlines, and underlining
- Adjust horizontal and vertical cell alignment
Adjust Numeric Format
- Work with numeric formatting options
- Essential numeric formatting keystroke shortcuts
- Set special formats for dates, times, and more
Accentuate Data with Conditional Formatting
- Create value-based formatting using logical operators
- Create value-based formatting using data bars, color scales, and icons
Row and Column Adjustments
- Adjust one or more row heights and column widths without commands
- Work with the hide unhide options
Other Worksheet Formatting Tools
- Work with tables
- Use the Format Cells dialog box and the pop-up mini-toolbar
- Copy formats with dragging techniques and Format Painter
Conclusion
- Next steps