Lynda com Excel 2010 Advanced Formatting Techniques | FC284547B0EEC778D30EC35CE44AAF2946DBD5D0

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	416.1 MB
Total Files	61
Hash	FC284547B0EEC778D30EC35CE44AAF2946DBD5D0

/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
0102 Learning the important formatting keystroke shortcuts.mov	14.2 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
0105 Building custom date formats.mov	13.5 MB
/02 Controlling Fonts, Borders, and Cell Colors/
0201 Applying and adjusting fonts and font colors.mov	8.0 MB
0202 Adding custom formats with font color variations.mov	3.9 MB
0203 Applying underline, strikethrough, subscript, and superscript formatting.mov	6.3 MB
0204 Applying border styles and adjusting gridlines.mov	12.5 MB
0205 Using fill color and patterns for cell backgrounds.mov	6.0 MB
/03 Alignment Tools/
0301 Adjusting horizontal and vertical cell alignment.mov	6.7 MB
0302 Creating angled text variations for greater variety and readability.mov	7.9 MB
0303 Indenting data and dollar signs.mov	6.0 MB
0304 Simplifying title adjustments with the versatile Merge and Center commands.mov	6.7 MB
0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov	8.9 MB
/04 Other Valuable Formatting Tools/
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
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
0405 Adding a background image to a worksheet.mov	12.2 MB
/05 Row, Column, and Sheet Adjustments/
0501 Adjusting single and multiple row heights and column widths without commands.mov	6.8 MB
0502 Working with rows, columns, and sheets.mov	9.4 MB
0503 Working with the Hide Unhide options.mov	10.9 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
0703 Understanding the options in shape formatting.mov	9.6 MB
0704 Fine-tuning shape effects.mov	13.8 MB
0705 Learning the WordArt essentials for titles and headings.mov	5.9 MB
0706 Formatting Sparklines for optimum impact.mov	13.7 MB
/08 Adding Pictures/
0801 Converting a chart to a picture and adding new images.mov	8.0 MB
0802 Applying picture styles.mov	4.5 MB
0803 Adding borders and effects to pictures.mov	6.6 MB
/09 Dynamically Accentuating Data with Conditional Formatting/
0901 Creating value-based formatting using logical operators.mov	6.6 MB
0902 Creating value-based formatting using data bars and color scales.mov	10.2 MB
0903 Creating formats based on formulas.mov	11.0 MB
/10 Specialized Power Formatting Techniques/
1001 Hiding repeating titles in a column to clarify printed output.mov	5.4 MB
1002 Restoring missing title data in a column.mov	6.7 MB
1003 Displaying large values without using formulas.mov	8.2 MB
1004 Formatting column row titles.mov	3.6 MB
1005 Formatting a list for double-spaced printing.mov	3.9 MB
/11 Conclusion/
1101 Final thoughts.mov	1.8 MB
/Exercise Files/
Ch_01_Numeric.xlsx	67.2 KB
Ch_02_Display.xlsx	32.7 KB
Ch_03_Alignment.xlsx	47.6 KB
Ch_04_Tools.xlsx	58.7 KB
Ch_05_RowColumn.xlsx	93.1 KB
Ch_06_Outlining.xlsx	92.8 KB
Ch_07_Visualization.xlsx	88.6 KB
Ch_08_Pictures.xlsx	539.9 KB
Ch_09_Conditional.xlsx	94.2 KB
Ch_10_Power.xlsx	147.3 KB
E863A600	148.3 KB
IMG_0058.JPG	808.0 KB
olive_tree_v2.tiff	6.7 MB
TTOliveOil_Confidential.tiff	54.0 KB
TTOO_logo.tiff	468.4 KB
TwoTreesValley_small.jpg	15.5 KB
Total files 61