Data Manipulation free mini course

By Stephanie Johnson

Use the features in this training session to separate data, join data, and convert data using 4 Excel features. This session contains a video for each features.

Course Content

Separate data1 lesson

Separate data using text to columns.9 min

Change data layout.1 lesson

Transpose data4 min

Join data1 lesson

Join data using the concatenate function9 min

Save time joining and separating inconsistent data using Excel 2016 flash fill!1 lesson

Using flash fill7 min

Your Instructor

👤

Stephanie Johnson

Senior Trainer