589689.xyz

Lynda - Cleaning Up Your Excel 2013 Data

  • 收录时间:2018-02-27 20:59:59
  • 文件大小:319MB
  • 下载次数:87
  • 最近下载:2020-11-05 11:06:07
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 07. Using Specialized Techniques/07_02-Filling in missing title information.mp4 33MB
  2. 02. Readjusting Data Layouts/02_03-Using Sort to eliminate empty rows and columns.mp4 30MB
  3. 07. Using Specialized Techniques/07_05-Understanding Text to Columns and Flash Fill differences.mp4 25MB
  4. 07. Using Specialized Techniques/07_03-Combining data via concatenation and Flash Fill.mp4 22MB
  5. 07. Using Specialized Techniques/07_04-Splitting data into multiple columns with Text to Columns.mp4 21MB
  6. 03. Replacing Data at the Character Level/03_02-Dealing with special characters, wildcards, and the REPLACE function.mp4 17MB
  7. 07. Using Specialized Techniques/07_01-Using text functions.mp4 16MB
  8. 04. Adjusting Date-Like Data/04_01-Splitting unusual date formats into columns.mp4 15MB
  9. 03. Replacing Data at the Character Level/03_03-Removing leading single quotes.mp4 15MB
  10. 05. Working with Number-Text Conversion Issues/05_03-Adding leading zeros.mp4 14MB
  11. 06. Using Spell Checker and AutoCorrect/06_02-Creating data-entry shortcuts via the AutoCorrect feature.mp4 12MB
  12. 04. Adjusting Date-Like Data/04_04-Converting between time units Dayhour, yearday, etc..mp4 11MB
  13. 04. Adjusting Date-Like Data/04_05-Converting to and from Julian dates.mp4 10MB
  14. 02. Readjusting Data Layouts/02_02-Transposing row-column layouts into column-row layouts.mp4 10MB
  15. 06. Using Spell Checker and AutoCorrect/06_01-Correcting multiple misspellings.mp4 9MB
  16. 03. Replacing Data at the Character Level/03_01-Replacing data with the Replace command and SUBSTITUTE function.mp4 9MB
  17. 02. Readjusting Data Layouts/02_01-Moving and inserting rows and columns of data with a simple drag.mp4 8MB
  18. 01. Introduction/01_01-Welcome.mp4 8MB
  19. 05. Working with Number-Text Conversion Issues/05_01-Converting text data to values.mp4 7MB
  20. 04. Adjusting Date-Like Data/04_02-Using the Text to Columns command for selected date formats.mp4 6MB
  21. 04. Adjusting Date-Like Data/04_03-Using the DATEVALUE and TIMEVALUE functions.mp4 6MB
  22. 05. Working with Number-Text Conversion Issues/05_02-Using error-checking options to convert text data to values.mp4 6MB
  23. 03. Replacing Data at the Character Level/03_04-Removing trailing minus signs while converting data to negative values.mp4 4MB
  24. 08. Conclusion/08_01-Next steps.mp4 2MB
  25. 01. Introduction/01_02-Using the exercise files.mp4 2MB
  26. Exercice Files/Ex_Files_Cleanup_Ex2013.zip 1MB