Excel 2010 - Advanced Formatting Techniques (Lynda.com)

1. 7 - Tables, Themes, Styles and Other Visualization Tools/7-1 Converting data into a table and reformatting it.mov 26.08 MB
2. 7 - Tables, Themes, Styles and Other Visualization Tools/7-2 Using styles and themes for consistent formatting.mov 17.34 MB
3. 1 - Adjusting Numeric Formats Quickly/1-1 Working with the numeric formatting options.mov 16.56 MB
4. 1 - Adjusting Numeric Formats Quickly/1-3 Setting special formats for dates, times, phone numbers, fractions, etc.mov 15.52 MB
5. 1 - Adjusting Numeric Formats Quickly/1-4 Building custom numeric formats.mov 14.61 MB
6. 1 - Adjusting Numeric Formats Quickly/1-2 Learning the important formatting keystroke shortcuts.mov 13.90 MB
7. 7 - Tables, Themes, Styles and Other Visualization Tools/7-4 Fine-tuning shape effects.mov 13.48 MB
8. 7 - Tables, Themes, Styles and Other Visualization Tools/7-6 Formatting Sparklines for optimum impact.mov 13.38 MB
9. 1 - Adjusting Numeric Formats Quickly/1-5 Building custom date formats.mov 13.23 MB
10. 2 - Controlling Fonts, Borders, and Cell Colors/2-4 Applying border styles and adjusting gridlines.mov 12.25 MB
11. 6 - Displaying Data as an Outline/6-1 Setting up data for outlining.mov 11.91 MB
12. 4 - Other Valuable Formatting Tools/4-5 Adding a background image to a worksheet.mov 11.88 MB
13. 9 - Dynamically Accentuating Data with Conditional Formatting/9-3 Creating formats based on formulas.mov 10.76 MB
14. 5 - Row, Column, and Sheet Adjustments/5-3 Working with the Hide Unhide options.mov 10.66 MB
15. 9 - Dynamically Accentuating Data with Conditional Formatting/9-2 Creating value-based formatting using data bars and color scales.mov 9.92 MB
16. 7 - Tables, Themes, Styles and Other Visualization Tools/7-3 Understanding the options in shape formatting.mov 9.35 MB
17. 5 - Row, Column, and Sheet Adjustments/5-2 Working with rows, columns, and sheets.mov 9.19 MB
18. 3 - Alignment Tools/3-5 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov 8.65 MB
19. 4 - Other Valuable Formatting Tools/4-3 Copying formats quickly with dragging techniques and the Format Painter.mov 8.47 MB
20. 6 - Displaying Data as an Outline/6-2 Using outlining symbols and levels.mov 8.17 MB
21. 0 - Introduction/0-1 Welcome.mov 8.10 MB
22. 10 - Specialized Power Formatting Techniques/10-3 Displaying large values without using formulas.mov 7.99 MB
23. 8 - Adding Pictures/8-1 Converting a chart to a picture and adding new images.mov 7.84 MB
24. 2 - Controlling Fonts, Borders, and Cell Colors/2-1 Applying and adjusting fonts and font colors.mov 7.83 MB
25. 3 - Alignment Tools/3-2 Creating angled text variations for greater variety and readability.mov 7.70 MB
26. 5 - Row, Column, and Sheet Adjustments/5-1 Adjusting single and multiple row heights and column widths without commands.mov 6.59 MB
27. 3 - Alignment Tools/3-4 Simplifying title adjustments with the versatile Merge and Center commands.mov 6.58 MB
28. 3 - Alignment Tools/3-1 Adjusting horizontal and vertical cell alignment.mov 6.55 MB
29. 10 - Specialized Power Formatting Techniques/10-2 Restoring missing title data in a column.mov 6.52 MB
30. 8 - Adding Pictures/8-3 Adding borders and effects to pictures.mov 6.41 MB
31. 9 - Dynamically Accentuating Data with Conditional Formatting/9-1 Creating value-based formatting using logical operators.mov 6.41 MB
32. 2 - Controlling Fonts, Borders, and Cell Colors/2-3 Applying underline, strikethrough, subscript, and superscript formatting .mov 6.13 MB
33. 4 - Other Valuable Formatting Tools/4-4 Formatting text from Word or the web with the Justify feature.mov 5.93 MB
34. 2 - Controlling Fonts, Borders, and Cell Colors/2-5 Using fill color and patterns for cell backgrounds.mov 5.83 MB
35. 3 - Alignment Tools/3-3 Indenting data and dollar signs.mov 5.81 MB
36. 7 - Tables, Themes, Styles and Other Visualization Tools/7-5 Learning the WordArt essentials for titles and headings.mov 5.72 MB
37. 4 - Other Valuable Formatting Tools/4-1 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov 5.29 MB
38. 10 - Specialized Power Formatting Techniques/10-1 Hiding repeating titles in a column to clarify printed output.mov 5.28 MB
39. 4 - Other Valuable Formatting Tools/4-2 Applying different formatting styles within the same cell.mov 5.01 MB
40. 8 - Adding Pictures/8-2 Applying picture styles.mov 4.37 MB
41. 2 - Controlling Fonts, Borders, and Cell Colors/2-2 Adding custom formats with font color variations.mov 3.82 MB
42. 10 - Specialized Power Formatting Techniques/10-5 Formatting a list for double-spaced printing.mov 3.80 MB
43. 10 - Specialized Power Formatting Techniques/10-4 Formatting column row titles.mov 3.53 MB
44. Exercise Files/Ex_files_Excel_2010_Advanced Formatting Techniques.zip 2.43 MB
45. Conclusion/Final thoughts.mov 1.77 MB
46. 0 - Introduction/0-2 Using the exercise files.mov 1.00 MB
47. collected from j[A]hiD, __007™.txt 0 KB