Excel 2007: Advanced Formatting Techniques

Author

Released

3/19/2010

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.

Topics include:

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

Skill Level Intermediate

3h 8m

Duration

64,569

Views

Show MoreShow Less

- Hi, I'm Dennis Taylor,and I'm please to present Excel 2007.When you're working with Excel using eitherspreadsheet or database-like data,there's no question that appearances count.If you're preparing data for that all important meetingor that printed quarterly report,a dull, lifeless display won'tget the attention it deserves.To accentuate and emphasize specific cellsand add flair and pizzazz to your worksheets,you need to know the scope of Excel'sformatting features and the quickestand best ways to get to them.

In this course, I'll explore not onlywidely used formatting features,but also give you time saving keystroke shortcutsand show you those features that enhancethe appearance of worksheets,giving them wide visual appeal,as well as making them clearerand easier to understand.I'll show you the best ways to applynumeric formatting,use built in formats for phone numbers,social security numbers, dates,and other data types so that you caneliminate any doubt about what your data means.I'll also explain how to use the powerfulconditional formatting feature fordynamic visual effectsand 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 informationin a clear, and even interesting, way.Let me show you how in Excel 2007.