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