Data manipulation | Cornerstone Learning Hub

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Pivot table Advanced Course

Pivot tables

Overview of the pivot table environment
Data files for pivot table practice

Preparing data for Pivot tables

Data manipulation (8:15)
Flash fill (14:23)
Text to Columns (13:06)

Creating pivot table reports

Creating a basic pivot table (14:40)
Adding and refreshing data to a pivot table (5:00)
Filtering data in a pivot tables (6:51)

Creating pivot charts

Creating a pivot chart (2:26)

Power Query

Power Query - Unpivot Data (6:18)
Power Query - Split Columns (9:05)

Quick Reference Guides

Excel quick reference guide

Formulas

vLookup (6:25)

Teach online with

Data manipulation

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock