Skip to content

Lynda Com - Excel 2010 Advanced Formatting Techniques

Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda Com - ExcelGroup: NOGRPYear: 2010Source: Lynda.Com
Info Hash
88075C02E293D46998FC4BCFB1EDEB8A986F7782
Source
Unverified
Total Size
396.82 MB
Total Files
61
Seeders
1
Leechers
0
Health
1.00
Score
2
Type
Bookware

File List

FileSize
00 Introduction/0001 Welcome.mov7.91 MB
00 Introduction/0002 Using the exercise files.mov1004.79 KB
01 Adjusting Numeric Formats Quickly/0101 Working with the numeric formatting options.mov16.17 MB
01 Adjusting Numeric Formats Quickly/0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15 MB
01 Adjusting Numeric Formats Quickly/0104 Building custom numeric formats.mov14.27 MB
01 Adjusting Numeric Formats Quickly/0102 Learning the important formatting keystroke shortcuts.mov13.57 MB
01 Adjusting Numeric Formats Quickly/0105 Building custom date formats.mov12.92 MB
02 Controlling Fonts, Borders, and Cell Colors/0204 Applying border styles and adjusting gridlines.mov11.97 MB
02 Controlling Fonts, Borders, and Cell Colors/0201 Applying and adjusting fonts and font colors.mov7.65 MB
02 Controlling Fonts, Borders, and Cell Colors/0203 Applying underline, strikethrough, subscript, and superscript formatting.mov5.98 MB
02 Controlling Fonts, Borders, and Cell Colors/0205 Using fill color and patterns for cell backgrounds.mov5.69 MB
02 Controlling Fonts, Borders, and Cell Colors/0202 Adding custom formats with font color variations.mov3.74 MB
03 Alignment Tools/0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45 MB
03 Alignment Tools/0302 Creating angled text variations for greater variety and readability.mov7.52 MB
03 Alignment Tools/0304 Simplifying title adjustments with the versatile Merge and Center commands.mov6.43 MB
03 Alignment Tools/0301 Adjusting horizontal and vertical cell alignment.mov6.4 MB
03 Alignment Tools/0303 Indenting data and dollar signs.mov5.67 MB
04 Other Valuable Formatting Tools/0405 Adding a background image to a worksheet.mov11.61 MB
04 Other Valuable Formatting Tools/0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27 MB
04 Other Valuable Formatting Tools/0404 Formatting text from Word or the web with the Justify feature.mov5.79 MB
04 Other Valuable Formatting Tools/0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17 MB
04 Other Valuable Formatting Tools/0402 Applying different formatting styles within the same cell.mov4.89 MB
05 Row, Column, and Sheet Adjustments/0503 Working with the Hide Unhide options.mov10.41 MB
05 Row, Column, and Sheet Adjustments/0502 Working with rows, columns, and sheets.mov8.98 MB
05 Row, Column, and Sheet Adjustments/0501 Adjusting single and multiple row heights and column widths without commands.mov6.44 MB
06 Displaying Data as an Outline/0601 Setting up data for outlining.mov11.63 MB
06 Displaying Data as an Outline/0602 Using outlining symbols and levels.mov7.98 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0701 Converting data into a table and reformatting it.mov25.47 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0702 Using styles and themes for consistent formatting.mov16.94 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0704 Fine-tuning shape effects.mov13.16 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0706 Formatting Sparklines for optimum impact.mov13.07 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0703 Understanding the options in shape formatting.mov9.13 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0705 Learning the WordArt essentials for titles and headings.mov5.59 MB
08 Adding Pictures/0801 Converting a chart to a picture and adding new images.mov7.66 MB
08 Adding Pictures/0803 Adding borders and effects to pictures.mov6.26 MB
08 Adding Pictures/0802 Applying picture styles.mov4.27 MB
09 Dynamically Accentuating Data with Conditional Formatting/0903 Creating formats based on formulas.mov10.51 MB
09 Dynamically Accentuating Data with Conditional Formatting/0902 Creating value-based formatting using data bars and color scales.mov9.69 MB
09 Dynamically Accentuating Data with Conditional Formatting/0901 Creating value-based formatting using logical operators.mov6.26 MB
10 Specialized Power Formatting Techniques/1003 Displaying large values without using formulas.mov7.8 MB
10 Specialized Power Formatting Techniques/1002 Restoring missing title data in a column.mov6.36 MB
10 Specialized Power Formatting Techniques/1001 Hiding repeating titles in a column to clarify printed output.mov5.16 MB
10 Specialized Power Formatting Techniques/1005 Formatting a list for double-spaced printing.mov3.71 MB
10 Specialized Power Formatting Techniques/1004 Formatting column row titles.mov3.45 MB
11 Conclusion/1101 Final thoughts.mov1.73 MB
Exercise Files/olive_tree_v2.tiff6.34 MB
Exercise Files/IMG_0058.JPG789.06 KB
Exercise Files/Ch_08_Pictures.xlsx527.29 KB
Exercise Files/TTOO_logo.tiff457.46 KB
Exercise Files/E863A600144.83 KB
Exercise Files/Ch_10_Power.xlsx143.9 KB
Exercise Files/Ch_09_Conditional.xlsx92 KB
Exercise Files/Ch_05_RowColumn.xlsx90.89 KB
Exercise Files/Ch_06_Outlining.xlsx90.62 KB
Exercise Files/Ch_07_Visualization.xlsx86.53 KB
Exercise Files/Ch_01_Numeric.xlsx65.67 KB
Exercise Files/Ch_04_Tools.xlsx57.34 KB
Exercise Files/TTOliveOil_Confidential.tiff52.7 KB
Exercise Files/Ch_03_Alignment.xlsx46.49 KB
Exercise Files/Ch_02_Display.xlsx31.95 KB
Exercise Files/TwoTreesValley_small.jpg15.11 KB

Trackers

No trackers found.