Excel 2013: Advanced Formatting Techniques

Download Now

Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques that take the drudgery out of formatting even the largest amounts of data.

Topics include:

• Adjusting fonts, cell borders, and fills
  
• Aligning text
  
• Indenting data
  
• Setting special formats for dates, times, phone numbers, zip codes, and more
  
• Creating formats based on formulas with conditional formatting
  
• Applying styles and themes
  
• Adjusting row heights and column widths
  
• Adding background images and pictures
  
• Outlining data
  
• Printing double-spaced data