fileLynda.com.Excel.2010.Advanced.Fortting.Techniques

Lynda Excel 2010 Advanced Fortting Techniques
  • MOV00 Introduction0001 Welcome.mov7.91MB
  • MOV00 Introduction0002 Using the exercise files.mov1004.79KB
  • MOV01 Adjusting Numeric Forts Quickly0101 Working with the numeric formatting options.mov16.17MB
  • MOV01 Adjusting Numeric Forts Quickly0102 Learning the important formatting keystroke shortcuts.mov13.57MB
  • MOV01 Adjusting Numeric Forts Quickly0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15MB
  • MOV01 Adjusting Numeric Forts Quickly0104 Building custom numeric formats.mov14.27MB
  • MOV01 Adjusting Numeric Forts Quickly0105 Building custom date formats.mov12.92MB
  • MOV02 Controlling Fonts, Borders, and Cell Colors0201 Applying and adjusting fonts and font colors.mov7.65MB
  • MOV02 Controlling Fonts, Borders, and Cell Colors0202 Adding custom forts with font color variations.mov3.74MB
  • MOV02 Controlling Fonts, Borders, and Cell Colors0203 Applying underline, strikethrough, subscript, and superscript fortting.mov5.98MB
  • MOV02 Controlling Fonts, Borders, and Cell Colors0204 Applying border styles and adjusting gridlines.mov11.97MB
  • MOV02 Controlling Fonts, Borders, and Cell Colors0205 Using fill color and patterns for cell backgrounds.mov5.69MB
  • MOV03 Alignment Tools0301 Adjusting horizontal and vertical cell alignment.mov6.40MB
  • MOV03 Alignment Tools0302 Creating angled text variations for greater variety and readability.mov7.52MB
  • MOV03 Alignment Tools0303 Indenting data and dollar signs.mov5.67MB
  • MOV03 Alignment Tools0304 Simplifying title adjustments with the versatile Merge and Center comnds.mov6.43MB
  • MOV03 Alignment Tools0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45MB
  • MOV04 Other Valuable Fortting Tools0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov5.17MB
  • MOV04 Other Valuable Fortting Tools0402 Applying different formatting styles within the same cell.mov4.89MB
  • MOV04 Other Valuable Fortting Tools0403 Copying formats quickly with dragging techniques and the Format Painter.mov8.27MB
  • MOV04 Other Valuable Fortting Tools0404 Formatting text from Word or the web with the Justify feature.mov5.79MB
  • MOV04 Other Valuable Fortting Tools0405 Adding a background image to a worksheet.mov11.61MB
  • MOV05 Row, Column, and Sheet Adjustments0501 Adjusting single and multiple row heights and column widths without comnds.mov6.44MB
  • MOV05 Row, Column, and Sheet Adjustments0502 Working with rows, columns, and sheets.mov8.98MB
  • MOV05 Row, Column, and Sheet Adjustments0503 Working with the Hide Unhide options.mov10.41MB
  • MOV06 Displaying Data as an Outline0601 Setting up data for outlining.mov11.63MB
  • MOV06 Displaying Data as an Outline0602 Using outlining symbols and levels.mov7.98MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0701 Converting data into a table and refortting it.mov25.47MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0702 Using styles and themes for consistent fortting.mov16.94MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0703 Understanding the options in shape fortting.mov9.13MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0704 Fine-tuning shape effects.mov13.16MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0705 Learning the WordArt essentials for titles and headings.mov5.59MB
  • MOV07 Tables, Themes, Styles, and Other Essential Data Visualization Tools0706 Fortting Sparklines for optimum impact.mov13.07MB
  • MOV08 Adding Pictures0801 Converting a chart to a picture and adding new iges.mov7.66MB
  • MOV08 Adding Pictures0802 Applying picture styles.mov4.27MB
  • MOV08 Adding Pictures0803 Adding borders and effects to pictures.mov6.26MB
  • MOV09 Dynamically Accentuating Data with Conditional Fortting0901 Creating value-based formatting using logical operators.mov6.26MB
  • MOV09 Dynamically Accentuating Data with Conditional Fortting0902 Creating value-based formatting using data bars and color scales.mov9.69MB
  • MOV09 Dynamically Accentuating Data with Conditional Fortting0903 Creating formats based on formulas.mov10.51MB
  • MOV10 Specialized Power Fortting Techniques1001 Hiding repeating titles in a column to clarify printed output.mov5.16MB
  • MOV10 Specialized Power Fortting Techniques1002 Restoring missing title data in a column.mov6.36MB
  • MOV10 Specialized Power Fortting Techniques1003 Displaying large values without using formulas.mov7.80MB
  • MOV10 Specialized Power Fortting Techniques1004 Formatting column row titles.mov3.45MB
  • MOV10 Specialized Power Fortting Techniques1005 Formatting a list for double-spaced printing.mov3.71MB
  • MOV11 Conclusion1101 Final thoughts.mov1.73MB
  • XLSXExercise FilesCh_08_Pictures.xlsx527.29KB
  • XLSXExercise FilesCh_10_Power.xlsx143.90KB
  • EXERCISE FILESE863A600Exercise FilesE863A600144.83KB
  • JPGExercise FilesIMG_0058.JPG789.06KB
  • TIFFExercise Filesolive_tree_v2.tiff6.34MB
  • TIFFExercise FilesTTOO_logo.tiff457.46KB
Latest 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