TorBT - Torrents and Magnet Links Search Engine
Latest Searches: translator, hon och han - och dom andra season 1, hemligheten, proposal%2f, greatness, fake%20taxi%2f, femi, boobsquad, shining+pearl, financial planning

Lynda - Cleaning Up Your Excel 2013 Data

Magnet Download Download Torrent
File Name
Size
01. Introduction/01_01-Welcome.mp4
7.7 MB
01. Introduction/01_02-Using the exercise files.mp4
1.7 MB
02. Readjusting Data Layouts/02_01-Moving and inserting rows and columns of data with a simple drag.mp4
8.2 MB
02. Readjusting Data Layouts/02_02-Transposing row-column layouts into column-row layouts.mp4
10 MB
02. Readjusting Data Layouts/02_03-Using Sort to eliminate empty rows and columns.mp4
30 MB
03. Replacing Data at the Character Level/03_01-Replacing data with the Replace command and SUBSTITUTE function.mp4
8.8 MB
03. Replacing Data at the Character Level/03_02-Dealing with special characters, wildcards, and the REPLACE function.mp4
17 MB
03. Replacing Data at the Character Level/03_03-Removing leading single quotes.mp4
15 MB
03. Replacing Data at the Character Level/03_04-Removing trailing minus signs while converting data to negative values.mp4
4.3 MB
04. Adjusting Date-Like Data/04_01-Splitting unusual date formats into columns.mp4
15 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
04. Adjusting Date-Like Data/04_04-Converting between time units Dayhour, yearday, etc..mp4
11 MB
04. Adjusting Date-Like Data/04_05-Converting to and from Julian dates.mp4
10 MB
05. Working with Number-Text Conversion Issues/05_01-Converting text data to values.mp4
7.2 MB
05. Working with Number-Text Conversion Issues/05_02-Using error-checking options to convert text data to values.mp4
5.8 MB
05. Working with Number-Text Conversion Issues/05_03-Adding leading zeros.mp4
14 MB
06. Using Spell Checker and AutoCorrect/06_01-Correcting multiple misspellings.mp4
9.1 MB
06. Using Spell Checker and AutoCorrect/06_02-Creating data-entry shortcuts via the AutoCorrect feature.mp4
12 MB
07. Using Specialized Techniques/07_01-Using text functions.mp4
16 MB
07. Using Specialized Techniques/07_02-Filling in missing title information.mp4
33 MB
07. Using Specialized Techniques/07_03-Combining data via concatenation and Flash Fill.mp4
22 MB
07. Using Specialized Techniques/07_04-Splitting data into multiple columns with Text to Columns.mp4
21 MB
07. Using Specialized Techniques/07_05-Understanding Text to Columns and Flash Fill differences.mp4
25 MB
08. Conclusion/08_01-Next steps.mp4
1.9 MB
Exercice Files/Ex_Files_Cleanup_Ex2013.zip
1.2 MB