Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introducing: Get & Transform
Course Prerequisites
General Requirements
Excel 2010/2013 Users
Excel 2016 Users
Are You Ready For This?
Get and Transform: Connecting To Data
General Course Introduction (5:05)
Accessing Local Data through Get & Transform (6:31)
Common External Data Sources (8:18)
Connecting to Data Quiz and Exercise Walkthrough (4:13)
Get and Transform: Linking and Organizing Data Together
Special Chapter Notes
Standard Organizational Commands (8:33)
Connecting Data Together - The Append Command (6:28)
The Append Command - Practice Set
Linking Datasets Together - The Merge Command (9:26)
The Merge Command - Practice Set
Calculating Aggregations Across Fields - The Group By Command (10:55)
The Group By Command - Practice Set
Expand and Contract Data - Column Pivots (10:22)
Pivot Columns - Practice Set
Exercise 2 Solution (13:20)
Get and Transform: Data Transformations
Introduction to Data Types (11:27)
Introduction to Data Types - Practice Set
Text Data Types (9:16)
Text Data Types - Practice Set
Number Data Types (8:20)
Number Data Types - Practice Set
Date/Time Data Types (11:57)
Date/Time and Duration Data Types - Practice Set
Get and Transform: Custom Calculation Definitions
Adding New Columns (6:37)
Adding New Columns - Practice Set
Creating Conditional Columns (4:28)
Creating Conditional Columns - Practice Set
Creating Custom Columns (7:22)
Creating Custom Columns - Practice Set
Custom Column Formula Functions (6:02)
Creating Custom Formula - Practice Set
Get and Transform: Practical Application
Practical Application: Data Cleansing and Preparation
Practical Application: Merging, Linking, and Grouping Data
Practical Application: Producing a Report
Practical Application: Solution from Start to Finish (17:20)
Course Conclusion
Conclusion (3:51)
Standard Organizational Commands
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock