Excel 2016: Advanced Formatting Techniques

Introduction

• Welcome
• Prerequisites for this course
• About the exercise files

1. Control Fonts, Borders, and Cell Color

• 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

2. Alignment Tools

• 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

3. Adjust Numeric Formats Quickly

• 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

4. Accentuate Dynamic Data with Conditional Formatting

• Create value-based formatting using logical operators
• Create value-based formatting using data bars, color scales, and icons
• Create formats based on formulas

5. Tables, Styles, and Themes

• Work with tables
• Use styles and themes for consistent formatting

6. Row, Column, and Sheet Adjustments

• Adjust single and multiple row heights and column widths without commands
• Work with rows, columns, and sheets
• Work with the Hide and Unhide options

7. Other Worksheet Formatting Tools

• 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

8. Display Data as an Outline

• Set up data for outlines
• Use the Subtotal feature to create outlines

9. Format Images

• Format picture styles
• Add borders and effects to pictures
• Format sparklines for optimum visual impact
• Use WordArt for formatted titles and headings

10. Specialized Power-Formatting Techniques

• 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

Conclusion

• Next steps