Free Power Query Course (Hindi) 

Learn how to clean, transform, and analyze data using Power Query in Excel. This free course is designed for beginners and intermediate users who want to automate data preparation and reporting.
 

Watch on Youtube : Link to watch

Chapter 1 – Introduction to Power Query in Excel

• What is Power Query and why it is important

• Differences between Power Query and Excel formulas

• How to access Power Query in Excel

• Real-life examples where Power Query saves time

Chapter 2 – Unpivot Data in Power Query

• What is unpivoting?

• Why unpivoting is useful for data analysis

• Step-by-step demo: Reshaping cross-tab reports into tabular format

• Common mistakes to avoid while unpivoting

Chapter 3 – Split Data in Power Query

• Different ways to split data (by delimiter, number of characters, etc.)

• Splitting first and last names, city codes, and product IDs

• Advanced split techniques with examples

• How splitting improves data quality and analysis

Chapter 4 – Adding Columns and Data Extraction

• Creating custom columns with formulas

• Extracting text, numbers, and dates from columns

• Conditional columns (if-then-else logic)

• Practical examples:

  • Extracting year/month from a date

  • Pulling domain names from email IDs

  • Categorizing data into groups

Chapter 5 – Merging Queries in Power Query

• Difference between Merge and Append in Power Query

• Types of joins (Left, Right, Inner, Full) explained with examples

• Combining multiple datasets into one clean table

• Practical demo:

  • Merging sales data with customer details

  • Combining regional reports into a master report

Bonus: Practical Use Cases of Power Query

• Automating monthly reports

• Cleaning messy data from CSV/Excel/ERP systems

• Creating dashboards-ready data m