CourseExcelBackPower Query
0 / 5 modules doneQuiz: 0 / 15
Browser syncAll CoursesDashboard
MODULE 01 / 0512 min lesson + drill

Get & Transform Interface and Applied Steps

Load CSV/Table sources into Power Query Editor, understand Applied Steps playback, and fix automatic Change Type traps.

Leila GharaniYouTube ↗ (opens in a new tab)

Key takeaways while you watch

  • Open Power Query from Data -> Get Data -> From Table/Range or From Text/CSV.
  • Every click appends an editable step in Applied Steps — zero raw source cells are altered.
  • Remove unwanted hard-coded column lists from auto-generated Change Type steps when columns change.
COURSE CERTIFICATE · IN PROGRESSCourse Finisher (=COMPLETE())

Power Query | Certificate of Completion

Complete all 5 modules to unlock your personalized 1200×630 PNG certificate and LinkedIn credential link.

Finish 5 modules to unlockScore 100% quizzes toward Quiz Ace (=EXACT())Complete 3 full courses for Path Champion (=EXCEL())
My Badges & Certificates
EXCELBACK CREDENTIAL PREVIEW

Power Query — Certificate of Completion

ExcelBack Certificate Preview

Sample preview shown. Complete all 5 modules to personalize with your account name and download PNG.