Filename | Size |
| 00 Introduction/0001 Welcome.mov | 7.9 MB |
| 00 Introduction/0002 Using the exercise files.mov | 1004.8 KB |
| 01 Adjusting Numeric Formats Quickly/0101 Working with the numeric formatting options.mov | 16.2 MB |
| 01 Adjusting Numeric Formats Quickly/0102 Learning the important formatting keystroke shortcuts.mov | 13.6 MB |
| 01 Adjusting Numeric Formats Quickly/0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov | 15.2 MB |
| 01 Adjusting Numeric Formats Quickly/0104 Building custom numeric formats.mov | 14.3 MB |
| 01 Adjusting Numeric Formats Quickly/0105 Building custom date formats.mov | 12.9 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0201 Applying and adjusting fonts and font colors.mov | 7.6 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0202 Adding custom formats with font color variations.mov | 3.7 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0203 Applying underline, strikethrough, subscript, and superscript formatting.mov | 6 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0204 Applying border styles and adjusting gridlines.mov | 12 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0205 Using fill color and patterns for cell backgrounds.mov | 5.7 MB |
| 03 Alignment Tools/0301 Adjusting horizontal and vertical cell alignment.mov | 6.4 MB |
| 03 Alignment Tools/0302 Creating angled text variations for greater variety and readability.mov | 7.5 MB |
| 03 Alignment Tools/0303 Indenting data and dollar signs.mov | 5.7 MB |
| 03 Alignment Tools/0304 Simplifying title adjustments with the versatile Merge and Center commands.mov | 6.4 MB |
| 03 Alignment Tools/0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov | 8.4 MB |
| 04 Other Valuable Formatting Tools/0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov | 5.2 MB |
| 04 Other Valuable Formatting Tools/0402 Applying different formatting styles within the same cell.mov | 4.9 MB |
| 04 Other Valuable Formatting Tools/0403 Copying formats quickly with dragging techniques and the Format Painter.mov | 8.3 MB |
| 04 Other Valuable Formatting Tools/0404 Formatting text from Word or the web with the Justify feature.mov | 5.8 MB |
| 04 Other Valuable Formatting Tools/0405 Adding a background image to a worksheet.mov | 11.6 MB |
| 05 Row, Column, and Sheet Adjustments/0501 Adjusting single and multiple row heights and column widths without commands.mov | 6.4 MB |
| 05 Row, Column, and Sheet Adjustments/0502 Working with rows, columns, and sheets.mov | 9 MB |
| 05 Row, Column, and Sheet Adjustments/0503 Working with the Hide Unhide options.mov | 10.4 MB |
| 06 Displaying Data as an Outline/0601 Setting up data for outlining.mov | 11.6 MB |
| 06 Displaying Data as an Outline/0602 Using outlining symbols and levels.mov | 8 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0701 Converting data into a table and reformatting it.mov | 25.5 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0702 Using styles and themes for consistent formatting.mov | 16.9 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0703 Understanding the options in shape formatting.mov | 9.1 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0704 Fine-tuning shape effects.mov | 13.2 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0705 Learning the WordArt essentials for titles and headings.mov | 5.6 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0706 Formatting Sparklines for optimum impact.mov | 13.1 MB |
| 08 Adding Pictures/0801 Converting a chart to a picture and adding new images.mov | 7.7 MB |
| 08 Adding Pictures/0802 Applying picture styles.mov | 4.3 MB |
| 08 Adding Pictures/0803 Adding borders and effects to pictures.mov | 6.3 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0901 Creating value-based formatting using logical operators.mov | 6.3 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0902 Creating value-based formatting using data bars and color scales.mov | 9.7 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0903 Creating formats based on formulas.mov | 10.5 MB |
| 10 Specialized Power Formatting Techniques/1001 Hiding repeating titles in a column to clarify printed output.mov | 5.2 MB |
| 10 Specialized Power Formatting Techniques/1002 Restoring missing title data in a column.mov | 6.4 MB |
| 10 Specialized Power Formatting Techniques/1003 Displaying large values without using formulas.mov | 7.8 MB |
| 10 Specialized Power Formatting Techniques/1004 Formatting column row titles.mov | 3.5 MB |
| 10 Specialized Power Formatting Techniques/1005 Formatting a list for double-spaced printing.mov | 3.7 MB |
| 11 Conclusion/1101 Final thoughts.mov | 1.7 MB |
| Exercise Files/Ch_01_Numeric.xlsx | 65.7 KB |
| Exercise Files/Ch_02_Display.xlsx | 31.9 KB |
| Exercise Files/Ch_03_Alignment.xlsx | 46.5 KB |
| Exercise Files/Ch_04_Tools.xlsx | 57.3 KB |
| Exercise Files/Ch_05_RowColumn.xlsx | 90.9 KB |
| Exercise Files/Ch_06_Outlining.xlsx | 90.6 KB |
| Exercise Files/Ch_07_Visualization.xlsx | 86.5 KB |
| Exercise Files/Ch_08_Pictures.xlsx | 527.3 KB |
| Exercise Files/Ch_09_Conditional.xlsx | 92 KB |
| Exercise Files/Ch_10_Power.xlsx | 143.9 KB |
| Exercise Files/E863A600 | 144.8 KB |
| Exercise Files/IMG_0058.JPG | 789.1 KB |
| Exercise Files/olive_tree_v2.tiff | 6.3 MB |
| Exercise Files/TTOliveOil_Confidential.tiff | 52.7 KB |
| Exercise Files/TTOO_logo.tiff | 457.5 KB |
| Exercise Files/TwoTreesValley_small.jpg | 15.1 KB |