Lynda Com Excel 2010 Advanced Formatting Techniques | 274A77E610A23DFDF28B5F3BBB1680A44FB66AA5

Lynda Com Excel 2010 Advanced Formatting Techniques

Name	Lynda.Com.Excel.2010.Advanced.Formatting.Techniques	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	409.2 MB
Total Files	46
Hash	274A77E610A23DFDF28B5F3BBB1680A44FB66AA5

/00 Introduction/
0001 Welcome.mov	8.3 MB
0002 Using the exercise files.mov	1.0 MB
/01 Adjusting Numeric Formats Quickly/
0101 Working with the numeric formatting options.mov	17.0 MB
0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov	15.9 MB
0104 Building custom numeric formats.mov	15.0 MB
0102 Learning the important formatting keystroke shortcuts.mov	14.2 MB
0105 Building custom date formats.mov	13.5 MB
/02 Controlling Fonts, Borders, and Cell Colors/
0204 Applying border styles and adjusting gridlines.mov	12.5 MB
0201 Applying and adjusting fonts and font colors.mov	8.0 MB
0203 Applying underline, strikethrough, subscript, and superscript formatting.mov	6.3 MB
0205 Using fill color and patterns for cell backgrounds.mov	6.0 MB
0202 Adding custom formats with font color variations.mov	3.9 MB
/03 Alignment Tools/
0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov	8.9 MB
0302 Creating angled text variations for greater variety and readability.mov	7.9 MB
0304 Simplifying title adjustments with the versatile Merge and Center commands.mov	6.7 MB
0301 Adjusting horizontal and vertical cell alignment.mov	6.7 MB
0303 Indenting data and dollar signs.mov	6.0 MB
/04 Other Valuable Formatting Tools/
0405 Adding a background image to a worksheet.mov	12.2 MB
0403 Copying formats quickly with dragging techniques and the Format Painter.mov	8.7 MB
0404 Formatting text from Word or the web with the Justify feature.mov	6.1 MB
0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov	5.4 MB
0402 Applying different formatting styles within the same cell.mov	5.1 MB
/05 Row, Column, and Sheet Adjustments/
0503 Working with the Hide Unhide options.mov	10.9 MB
0502 Working with rows, columns, and sheets.mov	9.4 MB
0501 Adjusting single and multiple row heights and column widths without commands.mov	6.8 MB
/06 Displaying Data as an Outline/
0601 Setting up data for outlining.mov	12.2 MB
0602 Using outlining symbols and levels.mov	8.4 MB
/07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/
0701 Converting data into a table and reformatting it.mov	26.7 MB
0702 Using styles and themes for consistent formatting.mov	17.8 MB
0704 Fine-tuning shape effects.mov	13.8 MB
0706 Formatting Sparklines for optimum impact.mov	13.7 MB
0703 Understanding the options in shape formatting.mov	9.6 MB
0705 Learning the WordArt essentials for titles and headings.mov	5.9 MB
/08 Adding Pictures/
0801 Converting a chart to a picture and adding new images.mov	8.0 MB
0803 Adding borders and effects to pictures.mov	6.6 MB
0802 Applying picture styles.mov	4.5 MB
/09 Dynamically Accentuating Data with Conditional Formatting/
0903 Creating formats based on formulas.mov	11.0 MB
0902 Creating value-based formatting using data bars and color scales.mov	10.2 MB
0901 Creating value-based formatting using logical operators.mov	6.6 MB
/10 Specialized Power Formatting Techniques/
1003 Displaying large values without using formulas.mov	8.2 MB
1002 Restoring missing title data in a column.mov	6.7 MB
1001 Hiding repeating titles in a column to clarify printed output.mov	5.4 MB
1005 Formatting a list for double-spaced printing.mov	3.9 MB
1004 Formatting column row titles.mov	3.6 MB
/11 Conclusion/
1101 Final thoughts.mov	1.8 MB
/Exercise Files/
ex_files_ex10_adv_form.zip	2.5 MB
Total files 46