Power Query Basics
90 min7 lessonsComing soon
Lessons
1. Power Query kya hai aur formulas se better kab haiSoon
2. Import: CSV, folder (multiple files ek saath), web tableSoon
3. Core transforms: remove columns, split, change type, replace, fill downSoon
4. Unpivot — wide report ko analysable table me badalnaSoon
5. Merge (joins) vs Append — VLOOKUP ka scalable versionSoon
6. Query dependencies, staging queries, refresh settingsSoon
7. Common gotchas: locale/date errors, hardcoded file paths, type stepsSoon