Excel 2007: Advanced Formatting Techniques
Making important information presentable is what sets successful business reports and presentations apart from staid, unintelligible data. In Excel 2007: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making information readable and understandable, including automation techniques that take the drudgery out of formatting even the largest amounts of data. This course covers techniques for accentuating and emphasizing specific cells and adding style and readability to worksheets. Exercise files accompany this course.
- Saving time with keyboard shortcuts
- Adjusting fonts, cell borders, and fills
- Setting themes
- Formatting numeric data with cell formats
- Using the Conditional Formatting feature
- Hiding repeating column information
- Printing double-spaced data
- Elbow formatting
(Music playing.) Hi! I am Dennis Taylor, and I'm pleased to present Excel 2007. When you're working with Excel, using either spreadsheet or database-like data, there is no question that appearances count. If you're preparing data for that all-important meeting or that printed quarterly report, a dull, lifeless display won't get the attention it deserves. To accentuate and emphasize specific cells, and to add flair and pizzazz your worksheets, 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 explore not only widely used formatting features, but also give you timesaving keystroke shortcuts and show you those features that enhance the appearance of worksheets, giving them wide visual appeal, as well as making them clearer and easier to understand. I'll sure you the best ways to apply numeric formatting, used built-in formats for phone numbers, Social Security numbers, dates, and other data types, so you can eliminate any doubt about what your data means. I'll also explain how to use the powerful conditional formatting feature for dynamic visual effects, and some specialized techniques, like Elbow formatting, hiding repeating column information, and a cool two-step process for printing data double-spaced.
Excel isn't just for numbers; It's an important business tool to present information in a clear, and even interesting way. Let me show you how, in Excel 2007.
There are currently no FAQs about Excel 2007: Advanced Formatting Techniques.
Excel 2007 Essential Training2,805,842 Views
Excel 2013 Essential Training5,687,914 Views
Excel 2010 Essential Training5,772,091 Views
Foundations of Programming: Fundamentals6,780,099 Views
Excel 2007: Advanced Formulas and Functions362,028 Views
Windows 10 Essential Training733,943 Views
Access 2010 Essential Training3,084,789 Views
PHP with MySQL Essential Training3,926,247 Views