Lynda.com.Excel.2010.Advanced.Fortting.Techniques
- 00 Introduction0001 Welcome.mov7.91MB
- 00 Introduction0002 Using the exercise files.mov1004.79KB
- 01 Adjusting Numeric Forts Quickly0101 Working with the numeric formatting options.mov16.17MB
- 01 Adjusting Numeric Forts Quickly0102 Learning the important formatting keystroke shortcuts.mov13.57MB
- 01 Adjusting Numeric Forts Quickly0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15MB
- 01 Adjusting Numeric Forts Quickly0104 Building custom numeric formats.mov14.27MB
- 01 Adjusting Numeric Forts Quickly0105 Building custom date formats.mov12.92MB
- 02 Controlling Fonts, Borders, and Cell Colors0201 Applying and adjusting fonts and font colors.mov7.65MB
- 02 Controlling Fonts, Borders, and Cell Colors0202 Adding custom forts with font color variations.mov3.74MB
- 02 Controlling Fonts, Borders, and Cell Colors0203 Applying underline, strikethrough, subscript, and superscript fortting.mov5.98MB
- 02 Controlling Fonts, Borders, and Cell Colors0204 Applying border styles and adjusting gridlines.mov11.97MB
- 02 Controlling Fonts, Borders, and Cell Colors0205 Using fill color and patterns for cell backgrounds.mov5.69MB
- 03 Alignment Tools0301 Adjusting horizontal and vertical cell alignment.mov6.40MB
- 03 Alignment Tools0302 Creating angled text variations for greater variety and readability.mov7.52MB
- 03 Alignment Tools0303 Indenting data and dollar signs.mov5.67MB
- 03 Alignment Tools0304 Simplifying title adjustments with the versatile Merge and Center comnds.mov6.43MB
- 03 Alignment Tools0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45MB
- 04 Other Valuable Fortting Tools0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17MB
- 04 Other Valuable Fortting Tools0402 Applying different formatting styles within the same cell.mov4.89MB
- 04 Other Valuable Fortting Tools0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27MB
- 04 Other Valuable Fortting Tools0404 Formatting text from Word or the web with the Justify feature.mov5.79MB
- 04 Other Valuable Fortting Tools0405 Adding a background image to a worksheet.mov11.61MB
- 05 Row, Column, and Sheet Adjustments0501 Adjusting single and multiple row heights and column widths without comnds.mov6.44MB
- 05 Row, Column, and Sheet Adjustments0502 Working with rows, columns, and sheets.mov8.98MB
- 05 Row, Column, and Sheet Adjustments0503 Working with the Hide Unhide options.mov10.41MB
- 06 Displaying Data as an Outline0601 Setting up data for outlining.mov11.63MB
- 06 Displaying Data as an Outline0602 Using outlining symbols and levels.mov7.98MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0701 Converting data into a table and refortting it.mov25.47MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0702 Using styles and themes for consistent fortting.mov16.94MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0703 Understanding the options in shape fortting.mov9.13MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0704 Fine-tuning shape effects.mov13.16MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0705 Learning the WordArt essentials for titles and headings.mov5.59MB
- 07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0706 Fortting Sparklines for optimum impact.mov13.07MB
- 08 Adding Pictures0801 Converting a chart to a picture and adding new iges.mov7.66MB
- 08 Adding Pictures0802 Applying picture styles.mov4.27MB
- 08 Adding Pictures0803 Adding borders and effects to pictures.mov6.26MB
- 09 Dynamically Accentuating Data with Conditional Fortting0901 Creating value-based formatting using logical operators.mov6.26MB
- 09 Dynamically Accentuating Data with Conditional Fortting0902 Creating value-based formatting using data bars and color scales.mov9.69MB
- 09 Dynamically Accentuating Data with Conditional Fortting0903 Creating formats based on formulas.mov10.51MB
- 10 Specialized Power Fortting Techniques1001 Hiding repeating titles in a column to clarify printed output.mov5.16MB
- 10 Specialized Power Fortting Techniques1002 Restoring missing title data in a column.mov6.36MB
- 10 Specialized Power Fortting Techniques1003 Displaying large values without using formulas.mov7.80MB
- 10 Specialized Power Fortting Techniques1004 Formatting column row titles.mov3.45MB
- 10 Specialized Power Fortting Techniques1005 Formatting a list for double-spaced printing.mov3.71MB
- 11 Conclusion1101 Final thoughts.mov1.73MB
- Exercise FilesCh_08_Pictures.xlsx527.29KB
- Exercise FilesCh_10_Power.xlsx143.90KB
- Exercise FilesE863A600144.83KB
- Exercise FilesIMG_0058.JPG789.06KB
- Exercise Filesolive_tree_v2.tiff6.34MB
- Exercise FilesTTOO_logo.tiff457.46KB
- CreateTime2017-08-08
- UpdateTime2017-08-08
- FileTotalCount61
- TotalSize397.21MBHotTimes7ViewTimes13DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.SPC-001 2.TYWD-037 3.MN-036 4.IBW-208 5.NTD-043 6.MIBD-596 7.DKSW-305 8.CABD-046 9.ARM-174 10.JUSD-297 11.HONE-38 12.CMC-002 13.HPP-004 14.ATAD-096 15.DSML-013 16.SW-048 17.BIB-047 18.MIBD-502 19.ONSD-448 20.ONSD-683 21.BTWD-009 22.ONSD-378 23.SEED-37 24.DSD-055 25.PBD-053 26.JUSD-358 27.DXDB-011 28.PAR-222 29.MIBD-455 30.MIBD-572 31.IDBD-303 32.ONSD-532 33.CSV-006 34.XV-670 35.PBD-099 36.MIBD-658 37.PBD-215 38.DVDPS-919 39.SW-086 40.SEED-71 41.JBOX-004 42.STAR-181 43.CCC-221 44.MIBD-423 45.ISSD-046 46.DOKS-286 47.JUC-799 48.SHKD-500 49.AST-31 50.QBD-016 51.EMBW-067 52.DSE-790 53.MAYS-002 54.ETC-054 55.HRWX-001 56.IFLY-008 57.P-1300025 58.AEIL-322 59.DKSW-195 60.MVS-088 61.DSE-125 62.RMILD-480 63.BNDV-725 64.WNZ-281 65.CF-013 66.DSMG-043 67.NIT-005 68.MARD-229 69.WHPD-004 70.LA-003 71.463 72.041 73. 74.658 75.00813 76.249 77.132 78.060 79.00823 80.003 81.177 82.095 83.027 84.084 85.281 86.239 87.204 88.789 89.256 90.511 91.09 92.101 93.24 94.02 95.034 96.209 97.411 98.203 99.2 100.050 101.053 102.09 103.027 104.210 105.032 106.177 107.1005 108.305 109.223 110.041 111.165 112.180 113.018 114.175 115.66 116.857 117.153 118.82 119.006 120.270 121.219 122.19 123.13 124.001 125.170 126.003 127.025 128.001 129.088 130.021 131.149 132.379 133.055 134.171 135.001 136.487 137.057 138.103 139.277 140.033