Excel 2013 Advanced Formatting Techniques

1. 05 Tables, styles, and themes/1 Working with tables.mp454.11MB
2. 08 Displaying data as an outline/1 Setting up data for outlining.mp433.22MB
3. 04 Accentuating dynamic data with conditional formatting/2 Creating value-based formatting using data bars, color scales, and icons.mp425.5MB
4. 10 Specialized power formatting techniques/4 Creating linked worksheet images.mp424.31MB
5. 06 Row, column, and sheet adjustment/3 Working with the Hide and Unhide options.mp422.21MB
6. 04 Accentuating dynamic data with conditional formatting/3 Creating formats based on formulas.mp419.89MB
7. 06 Row, column, and sheet adjustment/2 Working with rows, columns, and sheets.mp419.82MB
8. 10 Specialized power formatting techniques/2 Restoring missing title data in a column.mp419.72MB
9. 04 Accentuating dynamic data with conditional formatting/4 Conditional formatting in PivotTables.mp417.79MB
10. 06 Row, column, and sheet adjustment/1 Adjusting single and multiple row heights and column widths without commands.mp417.68MB
11. 03 Adjusting Numeric formats quickly/2 Essential numeric formatting keystroke shortcuts.mp417.56MB
12. 03 Adjusting Numeric formats quickly/1 Working with numeric formatting options.mp417.03MB
13. 03 Adjusting Numeric formats quickly/5 Building custom date formats.mp416.64MB
14. 03 Adjusting Numeric formats quickly/4 Building custom numeric formats.mp415.76MB
15. 03 Adjusting Numeric formats quickly/3 Setting special formats for dates, times, phone numbers, ZIP codes, etc..mp415.57MB
16. 05 Tables, styles, and themes/2 Using styles and themes for consistent formatting.mp415.42MB
17. 01 Controlling fonts, borders, and cell color/1 Adjusting fonts, font sizes, and font colors.mp415.01MB
18. 09 Adding pictures/3 Formatting sparklines for optimum impact.mp412.66MB
19. 02 Alignment tools/5 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mp411.51MB
20. 07 Other worksheet formatting tools/3 Copying formats quickly with dragging techniques and the Format Painter.mp410.01MB
21. 09 Adding pictures/2 Adding borders and effects to pictures.mp49.9MB
22. 01 Controlling fonts, borders, and cell color/2 Applying underline, strikethrough, subscript, and superscript formatting.mp49.46MB
23. 08 Displaying data as an outline/2 Using outlining symbols and levels.mp49.35MB
24. 01 Controlling fonts, borders, and cell color/4 Using fill color and patterns for cell backgrounds.mp49.18MB
25. Intro/1 Welcome.mp48.93MB
26. 01 Controlling fonts, borders, and cell color/3 Applying border styles and adjusting gridlines.mp48.85MB
27. 02 Alignment tools/4 Simplifying title adjustments with the Merge & Center button.mp48.39MB
28. 02 Alignment tools/1 Adjusting horizontal and vertical cell alignment.mp48.16MB
29. 09 Adding pictures/1 Formatting picture styles.mp48.12MB
30. 04 Accentuating dynamic data with conditional formatting/1 Creating value-based formatting using logical operators.mp48.1MB
31. 10 Specialized power formatting techniques/1 Hiding repeating titles in a column to clarify printed output.mp47.64MB
32. 10 Specialized power formatting techniques/3 Displaying large values without using formulas.mp47.48MB
33. 07 Other worksheet formatting tools/1 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mp46.34MB
34. 07 Other worksheet formatting tools/2 Applying different formatting styles within the same cell.mp46.14MB
35. 09 Adding pictures/4 Using WordArt for formatted titles and headings.mp46.09MB
36. 07 Other worksheet formatting tools/4 Formatting text from Word or the web with the Justify feature.mp45.76MB
37. 10 Specialized power formatting techniques/6 Formatting a list for double-spaced printing.mp45.44MB
38. 02 Alignment tools/2 Creating angled text variations for greater variety and readability.mp45.19MB
39. 02 Alignment tools/3 Indenting data and dollar signs.mp45.13MB
40. 10 Specialized power formatting techniques/5 Formatting column and row titles.mp44.62MB
41. Intro/2 Using the exercise files.mp41.07MB
42. Intro/Goodbye.mp4777.01KB