Data Manipulation in Excel

By Stephanie Johnson

Use the features in this training session to separate data, join data, and convert data using 4 Excel features.

Course Content

Separate data3 lessons

Separate data using text to columns.

Excel Text to Columns9 min

Excel text to columns custom delimeter5 min

Change data layout.1 lesson

Transpose data

Join data2 lessons

Concatenate function

Excel Concatenate - Bonus paste using secret menus4 min

Save time joining and separating inconsistent data using Excel flash fill!2 lessons

Using flash fill8 min

Excel Flash Fill and Shortcut8 min

Power Query2 lessons

Power Query - Split Columns10 min

Power Query - Unpivot Data7 min

PowerPivot2 lessons

Power Pivot - Add Power Pivot Ribbon to Excel4 min

Power Pivot - Adding text data to Power Pivot over 1 million rows21 min

Pivot Tables5 lessons

Excel Convert Data for Pivot Tables9 min

Excel Basic Pivot Table - Create Pivot table from data15 min

Excel Basic Pivot Table - Add new data to a pivot table5 min

Excel Basic Pivot Table - Filter data in a pivot table7 min

Excel Basic Pivot Table - Create a pivot chart3 min

Quick tips and time savers3 lessons

Excel Selecting continous data ctrl and shift arrows2 min

Excel 30 Visible cells only2 min

Excel Navigation shortcuts home and end2 min

Formulas1 lesson

Excel Formula Vlookup7 min

Live Sessions1 lesson

Live Session Data Manipulation

👤

Senior Trainer