Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Query Essentials: Managing Advanced Data Connections
Section 1: Connecting
Course Welcome (1:47)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Import Multiple Files from a Folder (6:54)
Connect to Data in Another Excel Workbook (8:16)
Get Data from the Web (8:58)
Checking and Managing Data Source Locations (3:53)
Troubleshooting Import Errors (6:42)
Section 2: Loading and Refreshing
Load Options: Table, PivotTable, or Data Model (6:46)
Refreshing Data After Changes (7:40)
Best Practices for Folder Structures (6:52)
Exercise (4:55)
Course Quiz and Certificate of Completion
Course Quiz
Load Options: Table, PivotTable, or Data Model
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock