Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
Overview
Syllabus
Introduction
- Welcome
- Prerequisites for this course
- About the exercise files
- Adjust fonts, font sizes, and font colors
- Apply underline, strikethrough, subscript, and superscript formatting
- Apply border styles and adjust gridlines
- Use fill color and patterns for cell backgrounds
- Adjust horizontal and vertical cell alignment
- Create angled text variations for greater variety and readability
- Indent data and dollar signs
- Simplify title adjustments using the Merge and Center button
- Control titles and headings using Wrap Text and Shrink to Fit
- Work with numeric formatting options
- Master the numeric formatting keyboard shortcuts
- Set special formats for dates, times, phone numbers, and zip codes
- Build custom numeric formats
- Build custom date formats
- Create value-based formatting using logical operators
- Create value-based formatting using data bars, color scales, and icons
- Create formats based on formulas
- Work with tables
- Use styles and themes for consistent formatting
- Adjust single and multiple row heights and column widths without commands
- Work with rows, columns, and sheets
- Work with the Hide and Unhide options
- Use the Format Cells dialog box and the pop-up mini-toolbar
- Apply different formatting styles within the same cell
- Copy formats quickly using dragging techniques and the Format Painter
- Format text from Word or the web with the Justify feature
- Add a background image to a worksheet
- Set up data for outlines
- Use the Subtotal feature to create outlines
- Format picture styles
- Add borders and effects to pictures
- Format sparklines for optimum visual impact
- Use WordArt for formatted titles and headings
- Hide repeating column titles for better printing
- Restore missing title data in a column
- Display large values without using formulas
- Create picture links
- Format column and row titles
- Format a list for double-spaced printing
- Next steps
Taught by
Dennis Taylor