Excel 2016 Cleaning Up Your Data

/Download/

551486_07_01 - Next steps.en.srt

551486_00_01 - Welcome.en.srt

551486_02_04 - Remove trailing minus signs while converting data to negative.en.srt

551486_03_04 - Convert between time units_ Day_hour, year_day, etc.en.srt

551486_01_02 - Transpose row_column into column_row layouts.en.srt

551486_02_02 - Deal with special characters, wildcards, and REPLACE function.en.srt

551486_01_01 - Move and insert rows and columns of data with a simple drag.en.srt

551486_03_03 - Use the DATEVALUE and TIMEVALUE functions.en.srt

551486_03_02 - Use a Text to Column option for selected date formats.en.srt

551486_05_04 - Split data into columns with the Text to Columns feature.en.srt

551486_05_01 - Use text functions.en.srt

551486_01_03 - Use Sort to eliminate empty rows and columns.en.srt

551486_06_03 - Remove duplicate rows from a list.en.srt

551486_03_05 - Convert to and from Julian dates.en.srt

551486_02_03 - Remove leading single quotes.en.srt

551486_04_01 - Convert text data to values.en.srt

551486_06_01 - Fill in missing title information.en.srt

551486_03_01 - Split unusual date formats into columns.en.srt

551486_04_02 - Add leading zeroes_ Zip codes, other numerical codes, and text codes.en.srt

551486_05_02 - Use the CONCAT and TEXTJOIN functions to combine data.en.srt

551486_05_03 - Combine data via concatenation.en.srt

551486_05_05 - Use Flash Fill for faster combining and splitting.en.srt

551486_02_01 - Replace data with the Replace command and SUBSTITUTE function.en.srt

551486_06_04 - Correct multiple misspellings.en.srt

551486_06_02 - Adjust phone numbers and SS numbers for consistency.en.srt

551486_07_01 - Next steps.mp4

551486_02_04 - Remove trailing minus signs while converting data to negative.mp4

551486_00_01 - Welcome.mp4

551486_01_02 - Transpose row_column into column_row layouts.mp4

551486_03_03 - Use the DATEVALUE and TIMEVALUE functions.mp4

551486_03_04 - Convert between time units_ Day_hour, year_day, etc..mp4

551486_02_02 - Deal with special characters, wildcards, and REPLACE function.mp4

551486_03_02 - Use a Text to Column option for selected date formats.mp4

551486_01_01 - Move and insert rows and columns of data with a simple drag.mp4

551486_05_04 - Split data into columns with the Text to Columns feature.mp4

551486_03_05 - Convert to and from Julian dates.mp4

551486_05_01 - Use text functions.mp4

551486_02_03 - Remove leading single quotes.mp4

551486_04_01 - Convert text data to values.mp4

551486_01_03 - Use Sort to eliminate empty rows and columns.mp4

551486_03_01 - Split unusual date formats into columns.mp4

551486_04_02 - Add leading zeroes_ Zip codes, other numerical codes, and text codes.mp4

551486_05_03 - Combine data via concatenation.mp4

551486_06_03 - Remove duplicate rows from a list.mp4

551486_05_02 - Use the CONCAT and TEXTJOIN functions to combine data.mp4

551486_06_01 - Fill in missing title information.mp4

551486_06_04 - Correct multiple misspellings.mp4

551486_05_05 - Use Flash Fill for faster combining and splitting.mp4

551486_02_01 - Replace data with the Replace command and SUBSTITUTE function.mp4

551486_06_02 - Adjust phone numbers and SS numbers for consistency.mp4

/Download/Temp/

thumbnail_551486_06_04 - Correct multiple misspellings_1_43250080E9AB59B257C1C2F4956AFA65.jpg

thumbnail_551486_06_03 - Remove duplicate rows from a list_1_E65489E29A2F836589C36204CF02C963.jpg

thumbnail_551486_06_02 - Adjust phone numbers and SS numbers for consistency_1_12D7D4D0B2512AEEB1011BE56D946E1.jpg

thumbnail_551486_06_01 - Fill in missing title information_1_337A098D829120A068FC34BE85467A79.jpg

thumbnail_551486_05_05 - Use Flash Fill for faster combining and splitting_1_ED85B211E360B33CEA62C5704F2F792F.jpg

thumbnail_551486_05_03 - Combine data via concatenation_1_451C58A5ABC25F3CE65885E940C854DA.jpg

thumbnail_551486_05_04 - Split data into columns with the Text to Columns feature_1_6C933C50404F093A4C43C72C6C.jpg

thumbnail_551486_05_02 - Use the CONCAT and TEXTJOIN functions to combine data_1_92FDA5788DE11F764EE7747A90476.jpg

thumbnail_551486_05_01 - Use text functions_1_B9290EDD53CEA037A11F7D446BECA4B7.jpg

thumbnail_551486_04_02 - Add leading zeroes_ Zip codes, other numerical codes, and text codes_1_BDFAE8BDB0C074.jpg

thumbnail_551486_04_01 - Convert text data to values_1_5760A39B819D4DD3314727845BA4B17C.jpg

thumbnail_551486_03_05 - Convert to and from Julian dates_1_E1FA4F029E7D438AE215ECBB756C9BC9.jpg

thumbnail_551486_03_04 - Convert between time units_ Day_hour, year_day, etc._1_3CACB56127FF4556F7FF5263B7ABCCED.jpg

thumbnail_551486_03_03 - Use the DATEVALUE and TIMEVALUE functions_1_B2CEDC14F8106CB6A99B3FFB8A6D3FDD.jpg

thumbnail_551486_03_02 - Use a Text to Column option for selected date formats_1_73DA5C58A8AB07F43098849E4D87B.jpg

thumbnail_551486_03_01 - Split unusual date formats into columns_1_33A97A091CAC21D7683DEF1E0C37CB8C.jpg

thumbnail_551486_02_04 - Remove trailing minus signs while converting data to negative_1_7AF65DECC73394759C127.jpg

thumbnail_551486_02_03 - Remove leading single quotes_1_37756CF5A8FB8BA75213E97446F25FD8.jpg

thumbnail_551486_02_02 - Deal with special characters, wildcards, and REPLACE function_1_27B6D7040A06FE3F4C2C0.jpg

thumbnail_551486_02_01 - Replace data with the Replace command and SUBSTITUTE function_1_E6386E30B214FF08902AD.jpg

thumbnail_551486_01_03 - Use Sort to eliminate empty rows and columns_1_DB83CD37BAD43A9F05CD37BF0A0D3EE6.jpg

thumbnail_551486_01_02 - Transpose row_column into column_row layouts_1_B119F7FEDC8EBDCBF61441AF979285A6.jpg

thumbnail_551486_01_01 - Move and insert rows and columns of data with a simple drag_1_454D8638E4DF194D8DDB383.jpg

thumbnail_551486_00_01 - Welcome_1_318A153722F09EC60DF70D66F03B058F.jpg

thumbnail_551486_07_01 - Next steps_1_3E32DDC8B497E9A2E8A7DD5288B8F0C4.jpg

Total files 75