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