Lynda com Excel 2010 Advanced Formatting Techniques | CEEA3D21C66CB83829406D0A6400C878DE116A73

Lynda com Excel 2010 Advanced Formatting Techniques

Name	Lynda.com - Excel 2010 Advanced Formatting Techniques	DOWNLOAD Copy Link
Total Size	416.1 MB
Total Files	61
Hash	CEEA3D21C66CB83829406D0A6400C878DE116A73

/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
/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
/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
/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
/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
/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
/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
/00 Introduction/
0001 Welcome.mov	8.3 MB
0002 Using the exercise files.mov	1.0 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
/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
/Exercise Files/
olive_tree_v2.tiff	6.7 MB
IMG_0058.JPG	808.0 KB
Ch_08_Pictures.xlsx	539.9 KB
TTOO_logo.tiff	468.4 KB
E863A600	148.3 KB
Ch_10_Power.xlsx	147.3 KB
Ch_09_Conditional.xlsx	94.2 KB
Ch_05_RowColumn.xlsx	93.1 KB
Ch_06_Outlining.xlsx	92.8 KB
Ch_07_Visualization.xlsx	88.6 KB
Ch_01_Numeric.xlsx	67.2 KB
Ch_04_Tools.xlsx	58.7 KB
TTOliveOil_Confidential.tiff	54.0 KB
Ch_03_Alignment.xlsx	47.6 KB
Ch_02_Display.xlsx	32.7 KB
TwoTreesValley_small.jpg	15.5 KB
/11 Conclusion/
1101 Final thoughts.mov	1.8 MB
Total files 61