Lynda.com - Excel 2010 Advanced Formatting Techniques

1. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0701 Converting data into a table and reformatting it.mov25.47 MB
2. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0702 Using styles and themes for consistent formatting.mov16.94 MB
3. 01 Adjusting Numeric Formats Quickly0101 Working with the numeric formatting options.mov16.17 MB
4. 01 Adjusting Numeric Formats Quickly0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15 MB
5. 01 Adjusting Numeric Formats Quickly0104 Building custom numeric formats.mov14.27 MB
6. 01 Adjusting Numeric Formats Quickly0102 Learning the important formatting keystroke shortcuts.mov13.57 MB
7. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0704 Fine-tuning shape effects.mov13.16 MB
8. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0706 Formatting Sparklines for optimum impact.mov13.07 MB
9. 01 Adjusting Numeric Formats Quickly0105 Building custom date formats.mov12.92 MB
10. 02 Controlling Fonts, Borders, and Cell Colors0204 Applying border styles and adjusting gridlines.mov11.97 MB
11. 06 Displaying Data as an Outline0601 Setting up data for outlining.mov11.63 MB
12. 04 Other Valuable Formatting Tools0405 Adding a background image to a worksheet.mov11.61 MB
13. 09 Dynamically Accentuating Data with Conditional Formatting0903 Creating formats based on formulas.mov10.51 MB
14. 05 Row, Column, and Sheet Adjustments0503 Working with the Hide Unhide options.mov10.41 MB
15. 09 Dynamically Accentuating Data with Conditional Formatting0902 Creating value-based formatting using data bars and color scales.mov9.69 MB
16. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0703 Understanding the options in shape formatting.mov9.13 MB
17. 05 Row, Column, and Sheet Adjustments0502 Working with rows, columns, and sheets.mov8.98 MB
18. 03 Alignment Tools0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45 MB
19. 04 Other Valuable Formatting Tools0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27 MB
20. 06 Displaying Data as an Outline0602 Using outlining symbols and levels.mov7.98 MB
21. 00 Introduction0001 Welcome.mov7.91 MB
22. 10 Specialized Power Formatting Techniques1003 Displaying large values without using formulas.mov7.8 MB
23. 08 Adding Pictures0801 Converting a chart to a picture and adding new images.mov7.66 MB
24. 02 Controlling Fonts, Borders, and Cell Colors0201 Applying and adjusting fonts and font colors.mov7.65 MB
25. 03 Alignment Tools0302 Creating angled text variations for greater variety and readability.mov7.52 MB
26. 05 Row, Column, and Sheet Adjustments0501 Adjusting single and multiple row heights and column widths without commands.mov6.44 MB
27. 03 Alignment Tools0304 Simplifying title adjustments with the versatile Merge and Center commands.mov6.43 MB
28. 03 Alignment Tools0301 Adjusting horizontal and vertical cell alignment.mov6.4 MB
29. 10 Specialized Power Formatting Techniques1002 Restoring missing title data in a column.mov6.36 MB
30. Exercise Filesolive_tree_v2.tiff6.34 MB
31. 08 Adding Pictures0803 Adding borders and effects to pictures.mov6.26 MB
32. 09 Dynamically Accentuating Data with Conditional Formatting0901 Creating value-based formatting using logical operators.mov6.26 MB
33. 02 Controlling Fonts, Borders, and Cell Colors0203 Applying underline, strikethrough, subscript, and superscript formatting.mov5.98 MB
34. 04 Other Valuable Formatting Tools0404 Formatting text from Word or the web with the Justify feature.mov5.79 MB
35. 02 Controlling Fonts, Borders, and Cell Colors0205 Using fill color and patterns for cell backgrounds.mov5.69 MB
36. 03 Alignment Tools0303 Indenting data and dollar signs.mov5.67 MB
37. 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0705 Learning the WordArt essentials for titles and headings.mov5.59 MB
38. 04 Other Valuable Formatting Tools0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17 MB
39. 10 Specialized Power Formatting Techniques1001 Hiding repeating titles in a column to clarify printed output.mov5.16 MB
40. 04 Other Valuable Formatting Tools0402 Applying different formatting styles within the same cell.mov4.89 MB
41. 08 Adding Pictures0802 Applying picture styles.mov4.27 MB
42. 02 Controlling Fonts, Borders, and Cell Colors0202 Adding custom formats with font color variations.mov3.74 MB
43. 10 Specialized Power Formatting Techniques1005 Formatting a list for double-spaced printing.mov3.71 MB
44. 10 Specialized Power Formatting Techniques1004 Formatting column row titles.mov3.45 MB
45. 11 Conclusion1101 Final thoughts.mov1.73 MB
46. 00 Introduction0002 Using the exercise files.mov1004.79 KB
47. Exercise FilesIMG_0058.JPG789.06 KB
48. Exercise FilesCh_08_Pictures.xlsx527.29 KB
49. Exercise FilesTTOO_logo.tiff457.46 KB
50. Exercise FilesE863A600144.83 KB