Lynda - Excel 2013 Advanced Formatting Techniques

1. Working with tables-157962.mp454.11MB
2. Setting up data for outlining-157974.mp433.22MB
3. Creating value-based formatting using data bars, color scales, and icons-157958.mp425.5MB
4. Creating linked worksheet images-157985.mp424.31MB
5. Working with the Hide and Unhide options-157967.mp422.21MB
6. Creating formats based on formulas-157959.mp419.89MB
7. Working with rows, columns, and sheets-157966.mp419.82MB
8. Restoring missing title data in a column-157983.mp419.72MB
9. Conditional formatting in PivotTables-157960.mp417.79MB
10. Adjusting single and multiple row heights and column widths without commands-157965.mp417.68MB
11. Essential numeric formatting keystroke shortcuts-157952.mp417.56MB
12. Working with numeric formatting options-157951.mp417.03MB
13. Building custom date formats-157955.mp416.64MB
14. Building custom numeric formats-157954.mp415.76MB
15. Setting special formats for dates, times, phone numbers, ZIP codes, etc.-157953.mp415.57MB
16. Using styles and themes for consistent formatting-157963.mp415.42MB
17. Adjusting fonts, font sizes, and font colors-157940.mp415.01MB
18. Formatting sparklines for optimum impact-157979.mp412.66MB
19. Controlling titles and headings with the Wrap Text and Shrink to Fit options-157949.mp411.51MB
20. Copying formats quickly with dragging techniques and the Format Painter-157971.mp410.01MB
21. Adding borders and effects to pictures-157978.mp49.9MB
22. Applying underline, strikethrough, subscript, and superscript formatting-157941.mp49.46MB
23. Using outlining symbols and levels-157975.mp49.35MB
24. Using fill color and patterns for cell backgrounds-157943.mp49.18MB
25. Welcome-157937.mp48.93MB
26. Applying border styles and adjusting gridlines-157942.mp48.85MB
27. Simplifying title adjustments with the Merge & Center button-157948.mp48.39MB
28. Adjusting horizontal and vertical cell alignment-157945.mp48.16MB
29. Formatting picture styles-157977.mp48.12MB
30. Creating value-based formatting using logical operators-157957.mp48.1MB
31. Hiding repeating titles in a column to clarify printed output-157982.mp47.64MB
32. Displaying large values without using formulas-157984.mp47.48MB
33. Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar-157969.mp46.34MB
34. Applying different formatting styles within the same cell-157970.mp46.14MB
35. Using WordArt for formatted titles and headings-157980.mp46.09MB
36. Formatting text from Word or the web with the Justify feature-157972.mp45.76MB
37. Formatting a list for double-spaced printing-157987.mp45.44MB
38. Creating angled text variations for greater variety and readability-157946.mp45.19MB
39. Indenting data and dollar signs-157947.mp45.13MB
40. Formatting column and row titles-157986.mp44.62MB
41. Using the exercise files-157938.mp41.07MB
42. Goodbye-157989.mp4777.01KB