Prerequisites for this course

Contents

• Introduction Introduction

  • Welcome

    43s
  • Prerequisites for this course

    19s
  • About the exercise files

    25s
• 1. Control Fonts, Borders, and Cell Color 1. Control Fonts, Borders, and Cell Color

  • Adjust fonts, font sizes, and font colors

    4m 55s
  • (Locked)
    Apply underline, strikethrough, subscript, and superscript formatting

    5m 48s
  • (Locked)
    Apply border styles and adjust gridlines

    7m 16s
  • (Locked)
    Use fill color and patterns for cell backgrounds

    4m 1s
• 2. Alignment Tools 2. Alignment Tools

  • (Locked)
    Adjust horizontal and vertical cell alignment

    6m 48s
  • Create angled text variations for greater variety and readability

    3m 39s
  • (Locked)
    Indent data and dollar signs

    2m 7s
  • (Locked)
    Simplify title adjustments using the Merge and Center button

    4m 33s
  • (Locked)
    Control titles and headings using Wrap Text and Shrink to Fit

    5m 41s
• 3. Adjust Numeric Formats Quickly 3. Adjust Numeric Formats Quickly

  • (Locked)
    Work with numeric formatting options

    4m 44s
  • (Locked)
    Master the numeric formatting keyboard shortcuts

    4m 35s
  • (Locked)
    Set special formats for dates, times, phone numbers, and zip codes

    7m 26s
  • (Locked)
    Build custom numeric formats

    6m 59s
  • (Locked)
    Build custom date formats

    4m 33s
• 4. Accentuate Dynamic Data with Conditional Formatting 4. Accentuate Dynamic Data with Conditional Formatting

  • Create value-based formatting using logical operators

    3m 57s
  • (Locked)
    Create value-based formatting using data bars, color scales, and icons

    9m 16s
  • (Locked)
    Create formats based on formulas

    5m 45s
• 5. Tables, Styles, and Themes 5. Tables, Styles, and Themes

  • (Locked)
    Work with tables

    9m 10s
  • (Locked)
    Use styles and themes for consistent formatting

    5m 8s
• 6. Row, Column, and Sheet Adjustments 6. Row, Column, and Sheet Adjustments

  • (Locked)
    Adjust single and multiple row heights and column widths without commands

    7m 31s
  • (Locked)
    Work with rows, columns, and sheets

    6m 54s
  • (Locked)
    Work with the Hide and Unhide options

    6m 52s
• 7. Other Worksheet Formatting Tools 7. Other Worksheet Formatting Tools

  • (Locked)
    Use the Format Cells dialog box and the pop-up mini-toolbar

    3m 53s
  • (Locked)
    Apply different formatting styles within the same cell

    2m 52s
  • (Locked)
    Copy formats quickly using dragging techniques and the Format Painter

    6m 27s
  • (Locked)
    Format text from Word or the web with the Justify feature

    5m 4s
  • (Locked)
    Add a background image to a worksheet

    4m 32s
• 8. Display Data as an Outline 8. Display Data as an Outline

  • (Locked)
    Set up data for outlines

    5m 59s
  • (Locked)
    Use the Subtotal feature to create outlines

    6m 34s
• 9. Format Images 9. Format Images

  • (Locked)
    Format picture styles

    3m 25s
  • (Locked)
    Add borders and effects to pictures

    5m 21s
  • (Locked)
    Format sparklines for optimum visual impact

    5m 34s
  • (Locked)
    Use WordArt for formatted titles and headings

    4m 28s
• 10. Specialized Power-Formatting Techniques 10. Specialized Power-Formatting Techniques

  • (Locked)
    Hide repeating column titles for better printing

    3m 44s
  • (Locked)
    Restore missing title data in a column

    5m 13s
  • (Locked)
    Display large values without using formulas

    4m 32s
  • (Locked)
    Create picture links

    6m 2s
  • (Locked)
    Format column and row titles

    2m 36s
  • (Locked)
    Format a list for double-spaced printing

    3m 12s
• Conclusion Conclusion

  • (Locked)
    Next steps

    41s