Lynda - Excel for Mac 2016: Advanced Formatting Techniques - 431192
Lynda - Excel for Mac 2016: Advanced Formatting Techniques
When it comes to Excel, appearances count. Get simple, powerful tips for making spreadsheet information more readable and understandable in Excel for Mac 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data quickly; use conditional formatting; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover power formatting techniques—such as shortcuts and a quick copy/paste technique—that take the drudgery out of formatting even the largest amounts of data.


Table of Contents

  • Introduction
  • 1. Controlling Fonts, Borders, and Cell Color
  • 2. Alignment Tools
  • 3. Adjusting Numeric Formats Quickly
  • 4. Accentuating Dynamic Data with Conditional Formatting
  • 5. Tables, Styles, and Themes
  • 6. Row, Column, and Sheet Adjustments
  • 7. Other Worksheet Formatting Tools
  • 8. Displaying Data as an Outline
  • 9. Adding Pictures
  • 10. Specialized Power Formatting Techniques
  • Conclusion
  • Lynda - Excel for Mac 2016: Advanced Formatting Techniques


    Information
    Members of Guests cannot leave comments.




    rss