BrounStack
Learning›Excel Tutorial›Power Query
CHAPTER 18 · ADVANCED EXCEL

Power Query

Power Query repeatable data-cleaning workflow banata hai. Import, transform aur refresh steps ko save karke manual copy-paste work ko reduce kiya ja sakta hai.

English + Hinglish40 minData preparation

Typical workflow

  1. Get Data se source connect karo.
  2. Headers, data types aur blank rows clean karo.
  3. Columns split/merge/rename karo.
  4. Unwanted records filter karo.
  5. Load to worksheet ya Data Model.

Refresh advantage

Next month same format ka source aaye to transformation steps dobara manually repeat karne ki jagah query refresh ki ja sakti hai.

Append vs Merge

Append similar tables ko rows me stack karta hai. Merge key ke basis par related columns join karta hai.

Hinglish

Power Query ko data-cleaning recipe samjho. Recipe ek baar banao, source update hone par Refresh use karo.

Practice task

Three monthly sales files ko append karke single clean table banao, date type fix karo aur blank rows remove karo.