Excel 2016 Advanced Formatting Techniques

Dennis Taylor, An Excel Guru

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (54m)
    • Adjust fonts, font sizes, and font colors

      4:55
    • Adjust horizontal and vertical cell alignment

      6:48
    • Apply border styles and adjust grid lines

      7:16
    • Apply underline, strikethrough, subscript, and superscript formatting

      5:48
    • Build custom date formats

      4:33
    • Build custom numeric formats

      6:59
    • Control titles and headings using Wrap Text and Shrink to Fit

      5:41
    • Create angled text variations for greater variety and readability

      3:39
    • Work with numeric formatting options

      4:44
    • Create value based formatting using logical operators

      3:57
    • Prerequisites for this course

      0:19
    • Use fill color and patterns for cell backgrounds 473587

      4:01

About This Class

Get simple, powerful tips for making spreadsheet information readable and understandable in Microsoft Excel 2016. 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 (including conditional formatting) that take the drudgery out of formatting even the largest amounts of data.Topics include: Controlling fonts, borders, and cell color Adjusting horizontal and vertical cell alignment Creating angled text Adjusting numeric formatting Building custom date and numeric formats Creating value-based formatting Working with tables Using styles and themes Adjusting row heights and column widths Hiding and unhiding sheets Copying formats Formatting text with Justify Displaying data as outlines Formatting images and sparklines Creating picture links Formatting column and row titles

2

Students

--

Projects

0

Reviews (0)

Dennis Taylor

An Excel Guru

Dennis is the author of Teach Yourself Microsoft Excel 2000 and a co-author of four other books on spreadsheet software. He has developed customized Excel courses for specific clients, and has recorded over over 140 hours of Excel training courses for Lynda.com. Since 2006 he has presented over 500 public webinars on a variety of Excel topics.

A former employee of Levi Strauss, the University of Colorado, Amoco Oil, and the federal government, Dennis has taught over 5,000 seminars and ...

See full profile