Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Power Query Foundations
Welcome
Welcome to Power Query Foundations (1:13)
🔻DOWNLOAD Files & How to Use Them
The Power of Power Query
Analyze Large Data Quickly! Pivot Table or Power Query? (5:41)
Power Query Overview: Import Large Data from Another File (12:14)
Power Query Editor & Basic Transformation (9:43)
Quick Insights on Data Quality & Distribution (Hidden Feature) (6:04)
Formula Bar, Applied Steps & M Code (6:58)
Close & Load Destinations (How to Change Them) (5:50)
Refresh Data & PQ Refresh Options (4:21)
Import CSV File & Extract Text Based on Pattern (7:18)
Merge Data with Another File (Pivot Table from Multiple Files) (7:56)
Old School Method: What if There Was NO Power Query? (4:14)
Activity: Get Familiar with PQ
Important Power Query Tips & Tricks
Uploading Data From Excel (8:17)
The Hidden Table Method (Hidden Feature) (4:23)
Handling Changes to Source (10:14)
Data Types (2:39)
Data Types vs. Formatting & Null Values (4:21)
Power Query Navigation Shortcuts (Become Pro) (3:49)
Finding & Correcting Errors in Data (5:01)
More Data Views: Duplicate OR Reference Query? (6:22)
Keeping an Eye on Query Dependencies (1:41)
Delete, Manage, Copy Queries & Backup Results (Become Pro) (4:04)
💪 CHALLENGE - Find and Correct the Mistake
🤔 QUIZ - Power Query Tips & Tricks
Helpful Power Query Settings
What's Next
Next Steps (1:52)
Continue with the Full Course
Close & Load Destinations (How to Change Them)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock