Excel 2013: Advanced Formatting Techniques

with Dennis Taylor
please wait ...
Excel 2013: Advanced Formatting Techniques
Video duration: 0s 2h 58m Advanced


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


- [Voiceover] Hi, I'm Dennis Taylor and I'm happy to present Excel 2013: Advanced Formatting Techniques. When you're working with Excel, there's no question that appearances count. A dull, lifeless display won't get the attention it deserves. You need to know the scope of Excel's formatting features and the quickest and best ways to get to them. In this course, I'll show you keystroke shortcuts to format numeric cells, how to use conditional formatting to apply formats dynamically, the most efficient ways to copy formats quickly and numerous tools that add flair and visual interest to your worksheets.

Excel gives you formatting tools that will allow you to eliminate any doubt about what your data means. I'm looking forward to showing them to you in Excel 2013: Advanced Formatting Techniques.

please wait ...