Lynda Cleaning Up Your Excel 2013 Data | C28504263242E9C8AAA8B38F8508FD065BDBF47F

Lynda Cleaning Up Your Excel 2013 Data

Name	Lynda - Cleaning Up Your Excel 2013 Data	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	334.6 MB
Total Files	26
Hash	C28504263242E9C8AAA8B38F8508FD065BDBF47F

/01. Introduction/
01_01-Welcome.mp4	8.1 MB
01_02-Using the exercise files.mp4	1.8 MB
/02. Readjusting Data Layouts/
02_01-Moving and inserting rows and columns of data with a simple drag.mp4	8.6 MB
02_02-Transposing row-column layouts into column-row layouts.mp4	10.7 MB
02_03-Using Sort to eliminate empty rows and columns.mp4	31.1 MB
/03. Replacing Data at the Character Level/
03_01-Replacing data with the Replace command and SUBSTITUTE function.mp4	9.3 MB
03_02-Dealing with special characters, wildcards, and the REPLACE function.mp4	17.8 MB
03_03-Removing leading single quotes.mp4	15.6 MB
03_04-Removing trailing minus signs while converting data to negative values.mp4	4.5 MB
/04. Adjusting Date-Like Data/
04_01-Splitting unusual date formats into columns.mp4	16.0 MB
04_02-Using the Text to Columns command for selected date formats.mp4	6.5 MB
04_03-Using the DATEVALUE and TIMEVALUE functions.mp4	6.4 MB
04_04-Converting between time units Dayhour, yearday, etc..mp4	11.8 MB
04_05-Converting to and from Julian dates.mp4	10.8 MB
/05. Working with Number-Text Conversion Issues/
05_01-Converting text data to values.mp4	7.5 MB
05_02-Using error-checking options to convert text data to values.mp4	6.0 MB
05_03-Adding leading zeros.mp4	14.8 MB
/06. Using Spell Checker and AutoCorrect/
06_01-Correcting multiple misspellings.mp4	9.5 MB
06_02-Creating data-entry shortcuts via the AutoCorrect feature.mp4	12.3 MB
/07. Using Specialized Techniques/
07_01-Using text functions.mp4	16.7 MB
07_02-Filling in missing title information.mp4	34.8 MB
07_03-Combining data via concatenation and Flash Fill.mp4	22.9 MB
07_04-Splitting data into multiple columns with Text to Columns.mp4	22.1 MB
07_05-Understanding Text to Columns and Flash Fill differences.mp4	25.8 MB
/08. Conclusion/
08_01-Next steps.mp4	1.9 MB
/Exercice Files/
Ex_Files_Cleanup_Ex2013.zip	1.3 MB
Total files 26