fileLynda-Cleaning-Up-Your-E-12tzI

Lynda Cleaning Your Excel 2013 Data
  • MP401. Introduction\\/01_01-Welcome.mp47.75MB
  • MP401. Introduction\\/01_02-Using the exercise files.mp41.67MB
  • MP402. Readjusting Data Layouts\\/02_01-Moving and inserting rows and columns of data with a simple drag.mp48.16MB
  • MP402. Readjusting Data Layouts\\/02_02-Transposing row-column layouts into column-row layouts.mp410.17MB
  • MP402. Readjusting Data Layouts\\/02_03-Using Sort to eliminate empty rows and columns.mp429.71MB
  • MP403. Replacing Data at the Character Level\\/03_01-Replacing data with the Replace comnd and SUBSTITUTE function.mp48.84MB
  • MP403. Replacing Data at the Character Level\\/03_02-Dealing with special characters wildcards and the REPLACE function.mp416.94MB
  • MP403. Replacing Data at the Character Level\\/03_03-Removing leading single quotes.mp414.83MB
  • MP403. Replacing Data at the Character Level\\/03_04-Removing trailing minus signs while converting data to negative values.mp44.29MB
  • MP404. Adjusting Date-Like Data\\/04_01-Splitting unusual date forts into columns.mp415.30MB
  • MP404. Adjusting Date-Like Data\\/04_02-Using the Text to Columns comnd for selected date formats.mp46.20MB
  • MP404. Adjusting Date-Like Data\\/04_03-Using the DATEVALUE and TIMEVALUE functions.mp46.13MB
  • MP404. Adjusting Date-Like Data\\/04_04-Converting between time units Dayhour yearday etc..mp411.26MB
  • MP404. Adjusting Date-Like Data\\/04_05-Converting to and from Julian dates.mp410.31MB
  • MP405. Working with Number-Text Conversion Issues\\/05_01-Converting text data to values.mp47.17MB
  • MP405. Working with Number-Text Conversion Issues\\/05_02-Using error-checking options to convert text data to values.mp45.77MB
  • MP405. Working with Number-Text Conversion Issues\\/05_03-Adding leading zeros.mp414.13MB
  • MP406. Using Spell Checker and AutoCorrect\\/06_01-Correcting multiple misspellings.mp49.05MB
  • MP406. Using Spell Checker and AutoCorrect\\/06_02-Creating data-entry shortcuts via the AutoCorrect feature.mp411.74MB
  • MP407. Using Specialized Techniques\\/07_01-Using text functions.mp415.97MB
  • MP407. Using Specialized Techniques\\/07_02-Filling in missing ti<x>tle infortion.mp433.17MB
  • MP407. Using Specialized Techniques\\/07_03-Combining data via concatenation and Flash Fill.mp421.83MB
  • MP407. Using Specialized Techniques\\/07_04-Splitting data into multiple columns with Text to Columns.mp421.06MB
  • MP407. Using Specialized Techniques\\/07_05-Understanding Text to Columns and Flash Fill differences.mp424.59MB
  • MP408. Conclusion\\/08_01-Next steps.mp41.85MB
  • ZIPExercice Files\\/Ex_Files_Cleanup_Ex2013.zip1.21MB
Latest Search: 1.ASFB-046   2.HITMA-53   3.NADE-936   4.HYA-04   5.DVDES-335   6.DVH-110   7.MAX-006   8.ZUKO-002   9.PSD-410   10.CMN-113   11.MIDD-947   12.KWBD-066   13.FAX-295   14.MILD-473   15.MIAD-583   16.REAL-414   17.NSPS-194   18.XV-783   19.RKI-234   20.MIBD-647   21.BIB-030   22.ARMG-067   23.NFDM-147   24.RKDVR-024   25.DVDPS-168   26.AMD-239   27.ADVO-039   28.MIBD-019   29.EDGD-020   30.MDLD-279   31.TBD-021   32.MIBD-685   33.OKAS-083   34.ONSD-599   35.AAJB-008   36.PSSD-280   37.KTDS-565   38.KWBD-106   39.BS-22   40.HODV-20822   41.MXBD-116   42.VRXS-070   43.SMT-005   44.CAOH-016   45.PPB-009   46.RDD-115   47.JS-49   48.ABS-127   49.CMC-114   50.CMC-017   51.MGDV-002   52.GFT-216   53.CADV-185   54.CWM-028   55.MVBD-081   56.ADVSR-0072   57.PLTD-08   58.UM-160   59.TXXD-064   60.ONE-236   61.DSS-083   62.CAV-3700077   63.MVD-060   64.FLOB-003   65.NEWS-015   66.KS-8168   67.SMJD-008   68.DP-095   69.OKAS-111   70.M-879   71.045   72.038   73.018   74.315   75.02   76.003   77.20026   78.001   79.019   80.007   81.20021   82.27   83.004   84.033   85.106   86.124   87.0025   88.094   89.5   90.253   91.610   92.028   93.655   94.070   95.018   96.007   97.33   98.006   99.603   100.531   101.505   102.254   103.607   104.399   105.574   106.298   107.03   108.025   109.680   110.543   111.017   112.194   113.288   114.420   115.03   116.041   117.018   118.139   119.043   120.015   121.096   122.355   123.0146   124.15   125.133   126.001   127.355   128.144   129.9245   130.002   131.001   132.144   133.054   134.059   135.086   136.014   137.298   138.533   139.001   140.185D