Lynda Excel 2010 Advanced Formatting Techniques

Author: Dennis Taylor
Duration (hr:min): 03:02
Released on: 02/2011
Exercise files: Yes
Software works on: Windows only

In Excel 2010 Advanced Formatting Techniques he 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.

Topics include:

• Saving time with keyboard shortcuts
• Adjusting fonts, cell borders, and fills
• Setting themes
• Formatting numeric data with cell formats
• Using conditional formatting
• Hiding repeating column information
• Printing double-spaced data
• Elbow formatting

Content:

Introduction - 00:01:16

• Welcome - 00:00:49
• Using the exercise files - 00:00:27

1. Adjusting Numeric Formats Quickly - 00:33:29

• Working with the numeric formatting options - 00:08:10
• Learning the important formatting keystroke shortcuts - 00:06:50
• Setting special formats for dates, times, phone numbers, fractions, etc. - 00:06:30
• Building custom numeric formats - 00:06:41
• Building custom date formats - 00:05:18

2. Controlling Fonts, Borders, and Cell Colors - 00:16:00

• Applying and adjusting fonts and font colors - 00:03:26
• Adding custom formats with font color variations - 00:02:24
• Applying underline, strikethrough, subscript, and superscript formatting - 00:02:59
• Applying border styles and adjusting gridlines - 00:04:27
• Using fill color and patterns for cell backgrounds - 00:02:44

3. Alignment Tools - 00:17:30

• Adjusting horizontal and vertical cell alignment - 00:04:03
• Creating angled text variations for greater variety and readability - 00:03:15
• Indenting data and dollar signs - 00:02:34
• Simplifying title adjustments with the versatile Merge and Center commands - 00:03:16
• Controlling titles and headings with the Wrap Text and Shrink to Fit options - 00:04:22

4. Other Valuable Formatting Tools - 00:15:24

• Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar - 00:02:42
• Applying different formatting styles within the same cell - 00:02:48
• Copying formats quickly with dragging techniques and the Format Painter - 00:04:20
• Formatting text from Word or the web with the Justify feature - 00:03:42
• Adding a background image to a worksheet - 00:01:52

5. Row, Column, and Sheet Adjustments - 00:14:13

• Adjusting single and multiple row heights and column widths without commands - 00:04:12
• Working with rows, columns, and sheets - 00:05:24
• Working with the Hide/Unhide options - 00:04:37

6. Displaying Data as an Outline - 00:09:25

• Setting up data for outlining - 00:05:48
• Using outlining symbols and levels - 00:03:37

7. Tables, Themes, Styles, and Other Essential Data Visualization Tools - 00:36:22

• Converting data into a table and reformatting it - 00:06:17
• Using styles and themes for consistent formatting - 00:07:06
• Understanding the options in shape formatting - 00:04:56
• Fine-tuning shape effects - 00:07:32
• Learning the WordArt essentials for titles and headings - 00:02:37
• Formatting Sparklines for optimum impact - 00:07:54

8. Adding Pictures - 00:08:57

• Converting a chart to a picture and adding new images - 00:03:30
• Applying picture styles - 00:02:24
• Adding borders and effects to pictures - 00:03:03

9. Dynamically Accentuating Data with Conditional Formatting - 00:16:56

• Creating value-based formatting using logical operators - 00:04:37
• Creating value-based formatting using data bars and color scales - 00:06:32
• Creating formats based on formulas - 00:05:47

10. Specialized Power Formatting Techniques - 00:12:54

• Hiding repeating titles in a column to clarify printed output - 00:02:26
• Restoring missing title data in a column - 00:03:30
• Displaying large values without using formulas - 00:03:07
• Formatting column/row titles - 00:01:58
• Formatting a list for double-spaced printing - 00:01:53

Conclusion - 00:00:27

• Final thoughts - 00:00:27