Lynda - Excel 2010: Advanced Formatting Techniques
In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course.
Table of Contents
Introduction1. Adjusting Numeric Formats Quickly 2. Controlling Fonts, Borders, and Cell Colors 3. Alignment Tools 4. Other Valuable Formatting Tools 5. Row, Column, and Sheet Adjustments 6. Displaying Data as an Outline 7. Tables, Themes, Styles, and Other Essential Data Visualization Tools 8. Adding Pictures9. Dynamically Accentuating Data with Conditional Formatting 10. Specialized Power Formatting Techniques Conclusion