Lynda com - Excel 2010 Advanced Formatting Techniques

1. 00 Introduction/0001 Welcome.mov7.91MB
2. 00 Introduction/0002 Using the exercise files.mov1004.79KB
3. 01 Adjusting Numeric Formats Quickly/0101 Working with the numeric formatting options.mov16.17MB
4. 01 Adjusting Numeric Formats Quickly/0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15MB
5. 01 Adjusting Numeric Formats Quickly/0104 Building custom numeric formats.mov14.27MB
6. 01 Adjusting Numeric Formats Quickly/0102 Learning the important formatting keystroke shortcuts.mov13.57MB
7. 01 Adjusting Numeric Formats Quickly/0105 Building custom date formats.mov12.92MB
8. 02 Controlling Fonts, Borders, and Cell Colors/0204 Applying border styles and adjusting gridlines.mov11.97MB
9. 02 Controlling Fonts, Borders, and Cell Colors/0201 Applying and adjusting fonts and font colors.mov7.65MB
10. 02 Controlling Fonts, Borders, and Cell Colors/0203 Applying underline, strikethrough, subscript, and superscript formatting.mov5.98MB
11. 02 Controlling Fonts, Borders, and Cell Colors/0205 Using fill color and patterns for cell backgrounds.mov5.69MB
12. 02 Controlling Fonts, Borders, and Cell Colors/0202 Adding custom formats with font color variations.mov3.74MB
13. 03 Alignment Tools/0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45MB
14. 03 Alignment Tools/0302 Creating angled text variations for greater variety and readability.mov7.52MB
15. 03 Alignment Tools/0304 Simplifying title adjustments with the versatile Merge and Center commands.mov6.43MB
16. 03 Alignment Tools/0301 Adjusting horizontal and vertical cell alignment.mov6.4MB
17. 03 Alignment Tools/0303 Indenting data and dollar signs.mov5.67MB
18. 04 Other Valuable Formatting Tools/0405 Adding a background image to a worksheet.mov11.61MB
19. 04 Other Valuable Formatting Tools/0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27MB
20. 04 Other Valuable Formatting Tools/0404 Formatting text from Word or the web with the Justify feature.mov5.79MB
21. 04 Other Valuable Formatting Tools/0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17MB
22. 04 Other Valuable Formatting Tools/0402 Applying different formatting styles within the same cell.mov4.89MB
23. 05 Row, Column, and Sheet Adjustments/0503 Working with the Hide Unhide options.mov10.41MB
24. 05 Row, Column, and Sheet Adjustments/0502 Working with rows, columns, and sheets.mov8.98MB
25. 05 Row, Column, and Sheet Adjustments/0501 Adjusting single and multiple row heights and column widths without commands.mov6.44MB
26. 06 Displaying Data as an Outline/0601 Setting up data for outlining.mov11.63MB
27. 06 Displaying Data as an Outline/0602 Using outlining symbols and levels.mov7.98MB
28. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0701 Converting data into a table and reformatting it.mov25.47MB
29. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0702 Using styles and themes for consistent formatting.mov16.94MB
30. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0704 Fine-tuning shape effects.mov13.16MB
31. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0706 Formatting Sparklines for optimum impact.mov13.07MB
32. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0703 Understanding the options in shape formatting.mov9.13MB
33. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0705 Learning the WordArt essentials for titles and headings.mov5.59MB
34. 08 Adding Pictures/0801 Converting a chart to a picture and adding new images.mov7.66MB
35. 08 Adding Pictures/0803 Adding borders and effects to pictures.mov6.26MB
36. 08 Adding Pictures/0802 Applying picture styles.mov4.27MB
37. 09 Dynamically Accentuating Data with Conditional Formatting/0903 Creating formats based on formulas.mov10.51MB
38. 09 Dynamically Accentuating Data with Conditional Formatting/0902 Creating value-based formatting using data bars and color scales.mov9.69MB
39. 09 Dynamically Accentuating Data with Conditional Formatting/0901 Creating value-based formatting using logical operators.mov6.26MB
40. 10 Specialized Power Formatting Techniques/1003 Displaying large values without using formulas.mov7.8MB
41. 10 Specialized Power Formatting Techniques/1002 Restoring missing title data in a column.mov6.36MB
42. 10 Specialized Power Formatting Techniques/1001 Hiding repeating titles in a column to clarify printed output.mov5.16MB
43. 10 Specialized Power Formatting Techniques/1005 Formatting a list for double-spaced printing.mov3.71MB
44. 10 Specialized Power Formatting Techniques/1004 Formatting column row titles.mov3.45MB
45. 11 Conclusion/1101 Final thoughts.mov1.73MB