Overview
-
Make your spreadsheet data more readable and compelling with these simple Excel formatting tips.
Syllabus
-
Introduction
- Formatting tips to build compelling spreadsheets
- Adjust fonts and cell colors
- Apply border styles, gridlines, and underlining
- Adjust horizontal and vertical cell alignment
- Work with numeric formatting options
- Essential numeric formatting keystroke shortcuts
- Set special formats for dates, times, and more
- Create value-based formatting using logical operators
- Create value-based formatting using data bars, color scales, and icons
- Adjust one or more row heights and column widths without commands
- Work with the hide/unhide options
- Work with tables
- Use the Format Cells dialog box and the pop-up mini-toolbar
- Copy formats with dragging techniques and Format Painter
- Next steps
