Lynda.com - Excel 2010 Advanced Formatting Techniques

seeders: 14
leechers: 15
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda.com - Excel 2010 Advanced Formatting Techniques (Size: 396.82 MB)
 0001 Welcome.mov7.91 MB
 0002 Using the exercise files.mov1004.79 KB
 0101 Working with the numeric formatting options.mov16.17 MB
 0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15 MB
 0104 Building custom numeric formats.mov14.27 MB
 0102 Learning the important formatting keystroke shortcuts.mov13.57 MB
 0105 Building custom date formats.mov12.92 MB
 0204 Applying border styles and adjusting gridlines.mov11.97 MB
 0201 Applying and adjusting fonts and font colors.mov7.65 MB
 0203 Applying underline, strikethrough, subscript, and superscript formatting.mov5.98 MB
 0205 Using fill color and patterns for cell backgrounds.mov5.69 MB
 0202 Adding custom formats with font color variations.mov3.74 MB
 0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45 MB
 0302 Creating angled text variations for greater variety and readability.mov7.52 MB
 0304 Simplifying title adjustments with the versatile Merge and Center commands.mov6.43 MB
 0301 Adjusting horizontal and vertical cell alignment.mov6.4 MB
 0303 Indenting data and dollar signs.mov5.67 MB
 0405 Adding a background image to a worksheet.mov11.61 MB
 0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27 MB
 0404 Formatting text from Word or the web with the Justify feature.mov5.79 MB
 0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17 MB
 0402 Applying different formatting styles within the same cell.mov4.89 MB
 0503 Working with the Hide Unhide options.mov10.41 MB
 0502 Working with rows, columns, and sheets.mov8.98 MB
 0501 Adjusting single and multiple row heights and column widths without commands.mov6.44 MB
 0601 Setting up data for outlining.mov11.63 MB
 0602 Using outlining symbols and levels.mov7.98 MB
 0701 Converting data into a table and reformatting it.mov25.47 MB
 0702 Using styles and themes for consistent formatting.mov16.94 MB
 0704 Fine-tuning shape effects.mov13.16 MB
 0706 Formatting Sparklines for optimum impact.mov13.07 MB
 0703 Understanding the options in shape formatting.mov9.13 MB
 0705 Learning the WordArt essentials for titles and headings.mov5.59 MB
 0801 Converting a chart to a picture and adding new images.mov7.66 MB
 0803 Adding borders and effects to pictures.mov6.26 MB
 0802 Applying picture styles.mov4.27 MB
 0903 Creating formats based on formulas.mov10.51 MB
 0902 Creating value-based formatting using data bars and color scales.mov9.69 MB
 0901 Creating value-based formatting using logical operators.mov6.26 MB
 1003 Displaying large values without using formulas.mov7.8 MB
 1002 Restoring missing title data in a column.mov6.36 MB
 1001 Hiding repeating titles in a column to clarify printed output.mov5.16 MB
 1005 Formatting a list for double-spaced printing.mov3.71 MB
 1004 Formatting column row titles.mov3.45 MB
 1101 Final Thoughts.mov1.73 MB
 olive_tree_v2.tiff6.34 MB
 IMG_0058.jpg789.06 KB
 Ch_08_Pictures.xlsx527.29 KB
 TTOO_logo.tiff457.46 KB
 E863A600144.83 KB
 Ch_10_Power.xlsx143.9 KB
 Ch_09_Conditional.xlsx92 KB
 Ch_05_RowColumn.xlsx90.89 KB
 Ch_06_Outlining.xlsx90.62 KB
 Ch_07_Visualization.xlsx86.53 KB


Description

3h 2m Intermediate Feb 10, 2011

In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course.
Topics include:

Saving time with keyboard shortcuts
Adjusting fonts, cell borders, and fills
Setting themes
Formatting numeric data with cell formats
Using conditional formatting
Hiding repeating column information
Printing double-spaced data
Elbow formatting

Software:
Excel Office
Author:
Dennis Taylor

SourcePage


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
396.82 MB
seeders:14
leechers:15
Lynda.com - Excel 2010 Advanced Formatting Techniques