Lynda - Excel 2016: Cleaning Up Your Data

[xidau123 14]

Lynda - Excel 2016: Cleaning Up Your Data

Size: 445 MB | Duration: 2h 27m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

Imported data isn't always pretty.

 

 

* Moving and inserting rows and columns of data with a simple drag

* Replacing data at the character level

* Converting dates with text functions

* Converting text data to values

* Using the CONCAT and TEXTJOIN functions to combine data

* Splitting data into columns via the Text to Columns feature

* Using Flash Fill for faster combining and splitting

* Checking and correcting spelling mistakes

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.