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

Skills covered

Office 365Microsoft 365SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Formatting tips to build compelling spreadsheets

1. Control Fonts, Borders, Cell Colors, and Alignment Options

02 - Adjust fonts and cell colors
03 - Apply border styles, gridlines, and underlining
04 - Adjust horizontal and vertical cell alignment

2. Adjust Numeric Format

05 - Work with numeric formatting options
06 - Essential numeric formatting keystroke shortcuts
07 - Set special formats for dates, times, and more

3. Accentuate Data with Conditional Formatting

08 - Create value-based formatting using logical operators
09 - Create value-based formatting using data bars, color scales, and icons

4. Row and Column Adjustments

10 - Adjust one or more row heights and column widths without commands
11 - Work with the hide unhide options

5. Other Worksheet Formatting Tools

12 - Work with tables
13 - Use the Format Cells dialog box and the pop-up mini-toolbar
14 - Copy formats with dragging techniques and Format Painter

Conclusion

15 - Next steps