->
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


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss