Lynda Com Excel 2010 Advanced Formatting Techniques
File List
| File | Size |
|---|---|
| 00 Introduction/0001 Welcome.mov | 7.91 MB |
| 00 Introduction/0002 Using the exercise files.mov | 1004.79 KB |
| 01 Adjusting Numeric Formats Quickly/0101 Working with the numeric formatting options.mov | 16.17 MB |
| 01 Adjusting Numeric Formats Quickly/0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov | 15.15 MB |
| 01 Adjusting Numeric Formats Quickly/0104 Building custom numeric formats.mov | 14.27 MB |
| 01 Adjusting Numeric Formats Quickly/0102 Learning the important formatting keystroke shortcuts.mov | 13.57 MB |
| 01 Adjusting Numeric Formats Quickly/0105 Building custom date formats.mov | 12.92 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0204 Applying border styles and adjusting gridlines.mov | 11.97 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0201 Applying and adjusting fonts and font colors.mov | 7.65 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0203 Applying underline, strikethrough, subscript, and superscript formatting.mov | 5.98 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0205 Using fill color and patterns for cell backgrounds.mov | 5.69 MB |
| 02 Controlling Fonts, Borders, and Cell Colors/0202 Adding custom formats with font color variations.mov | 3.74 MB |
| 03 Alignment Tools/0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov | 8.45 MB |
| 03 Alignment Tools/0302 Creating angled text variations for greater variety and readability.mov | 7.52 MB |
| 03 Alignment Tools/0304 Simplifying title adjustments with the versatile Merge and Center commands.mov | 6.43 MB |
| 03 Alignment Tools/0301 Adjusting horizontal and vertical cell alignment.mov | 6.4 MB |
| 03 Alignment Tools/0303 Indenting data and dollar signs.mov | 5.67 MB |
| 04 Other Valuable Formatting Tools/0405 Adding a background image to a worksheet.mov | 11.61 MB |
| 04 Other Valuable Formatting Tools/0403 Copying formats quickly with dragging techniques and the Format Painter.mov | 8.27 MB |
| 04 Other Valuable Formatting Tools/0404 Formatting text from Word or the web with the Justify feature.mov | 5.79 MB |
| 04 Other Valuable Formatting Tools/0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov | 5.17 MB |
| 04 Other Valuable Formatting Tools/0402 Applying different formatting styles within the same cell.mov | 4.89 MB |
| 05 Row, Column, and Sheet Adjustments/0503 Working with the Hide Unhide options.mov | 10.41 MB |
| 05 Row, Column, and Sheet Adjustments/0502 Working with rows, columns, and sheets.mov | 8.98 MB |
| 05 Row, Column, and Sheet Adjustments/0501 Adjusting single and multiple row heights and column widths without commands.mov | 6.44 MB |
| 06 Displaying Data as an Outline/0601 Setting up data for outlining.mov | 11.63 MB |
| 06 Displaying Data as an Outline/0602 Using outlining symbols and levels.mov | 7.98 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0701 Converting data into a table and reformatting it.mov | 25.47 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0702 Using styles and themes for consistent formatting.mov | 16.94 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0704 Fine-tuning shape effects.mov | 13.16 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0706 Formatting Sparklines for optimum impact.mov | 13.07 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0703 Understanding the options in shape formatting.mov | 9.13 MB |
| 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0705 Learning the WordArt essentials for titles and headings.mov | 5.59 MB |
| 08 Adding Pictures/0801 Converting a chart to a picture and adding new images.mov | 7.66 MB |
| 08 Adding Pictures/0803 Adding borders and effects to pictures.mov | 6.26 MB |
| 08 Adding Pictures/0802 Applying picture styles.mov | 4.27 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0903 Creating formats based on formulas.mov | 10.51 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0902 Creating value-based formatting using data bars and color scales.mov | 9.69 MB |
| 09 Dynamically Accentuating Data with Conditional Formatting/0901 Creating value-based formatting using logical operators.mov | 6.26 MB |
| 10 Specialized Power Formatting Techniques/1003 Displaying large values without using formulas.mov | 7.8 MB |
| 10 Specialized Power Formatting Techniques/1002 Restoring missing title data in a column.mov | 6.36 MB |
| 10 Specialized Power Formatting Techniques/1001 Hiding repeating titles in a column to clarify printed output.mov | 5.16 MB |
| 10 Specialized Power Formatting Techniques/1005 Formatting a list for double-spaced printing.mov | 3.71 MB |
| 10 Specialized Power Formatting Techniques/1004 Formatting column row titles.mov | 3.45 MB |
| 11 Conclusion/1101 Final thoughts.mov | 1.73 MB |
| Exercise Files/ex_files_ex10_adv_form.zip | 2.37 MB |
Trackers
No trackers found.