Lynda - Cleaning Up Your Excel 2013 Data
File List
- 07. Using Specialized Techniques/07_02-Filling in missing title information.mp4 33.2 MB
- 02. Readjusting Data Layouts/02_03-Using Sort to eliminate empty rows and columns.mp4 29.7 MB
- 07. Using Specialized Techniques/07_05-Understanding Text to Columns and Flash Fill differences.mp4 24.6 MB
- 07. Using Specialized Techniques/07_03-Combining data via concatenation and Flash Fill.mp4 21.8 MB
- 07. Using Specialized Techniques/07_04-Splitting data into multiple columns with Text to Columns.mp4 21.1 MB
- 03. Replacing Data at the Character Level/03_02-Dealing with special characters, wildcards, and the REPLACE function.mp4 16.9 MB
- 07. Using Specialized Techniques/07_01-Using text functions.mp4 16.0 MB
- 04. Adjusting Date-Like Data/04_01-Splitting unusual date formats into columns.mp4 15.3 MB
- 03. Replacing Data at the Character Level/03_03-Removing leading single quotes.mp4 14.8 MB
- 05. Working with Number-Text Conversion Issues/05_03-Adding leading zeros.mp4 14.1 MB
- 06. Using Spell Checker and AutoCorrect/06_02-Creating data-entry shortcuts via the AutoCorrect feature.mp4 11.7 MB
- 04. Adjusting Date-Like Data/04_04-Converting between time units Dayhour, yearday, etc..mp4 11.3 MB
- 04. Adjusting Date-Like Data/04_05-Converting to and from Julian dates.mp4 10.3 MB
- 02. Readjusting Data Layouts/02_02-Transposing row-column layouts into column-row layouts.mp4 10.2 MB
- 06. Using Spell Checker and AutoCorrect/06_01-Correcting multiple misspellings.mp4 9.1 MB
- 03. Replacing Data at the Character Level/03_01-Replacing data with the Replace command and SUBSTITUTE function.mp4 8.8 MB
- 02. Readjusting Data Layouts/02_01-Moving and inserting rows and columns of data with a simple drag.mp4 8.2 MB
- 01. Introduction/01_01-Welcome.mp4 7.7 MB
- 05. Working with Number-Text Conversion Issues/05_01-Converting text data to values.mp4 7.2 MB
- 04. Adjusting Date-Like Data/04_02-Using the Text to Columns command for selected date formats.mp4 6.2 MB
- 04. Adjusting Date-Like Data/04_03-Using the DATEVALUE and TIMEVALUE functions.mp4 6.1 MB
- 05. Working with Number-Text Conversion Issues/05_02-Using error-checking options to convert text data to values.mp4 5.8 MB
- 03. Replacing Data at the Character Level/03_04-Removing trailing minus signs while converting data to negative values.mp4 4.3 MB
- 08. Conclusion/08_01-Next steps.mp4 1.9 MB
- 01. Introduction/01_02-Using the exercise files.mp4 1.7 MB
- Exercice Files/Ex_Files_Cleanup_Ex2013.zip 1.2 MB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.