This Power Query Mastery Course will help you clean, combine, and prepare data easily. You will learn how to import data from different sources like Excel, PDFs, and websites. You will also learn to merge, append, and transform data step by step. By the end of this course, you will be able to handle large data sets and automate data tasks like a pro
- Home >
- Mastery Courses >
- Power Query
The Ultimate Power Query Mastery
Course (Basic to Advanced Level)
- 32 Lessons
- 8.4 Hours
- By Satish Dhawale
4.9 out of 5 stars (based on 365 reviews)
Here's What You'll Learn
This course is perfect for beginners, data analysts, accountants, and business professionals who work with large amounts of data. If you want to clean, transform, and automate data tasks using Power Query, this course is for you!
Import Data from Multiple Sources
Learn to bring data from Excel, PDFs, websites, and databases into Power Query with ease. This will help you work with different types of data efficiently.
Clean and Transform Data
Fix messy data by removing duplicates, splitting columns, and formatting it correctly. These skills will help you prepare data for better analysis.
Automate Data Processing
Save time by automating data updates and refreshes. Learn how to schedule data refreshes and eliminate manual work.
Merge and Append Data
Understand how to combine data from multiple sheets, tables, and files. You will learn to merge and append data without errors, making your reports more accurate.
Advanced Power Query Features
Explore pivoting, unpivoting, grouping, and custom columns to automate data tasks. These advanced techniques will make data handling easier.
Real-World Projects & Assignments
Get hands-on experience with real job-based queries and projects. It will make you job-ready and improve your skills.
Detailed Course Curriculum
This course provides a step-by-step guide to mastering Power Query, covering everything from importing data to advanced data transformation techniques. You’ll learn how to clean, merge, append, and manipulate large datasets efficiently using real-world scenarios.
| Lesson 1 : Introduction of Power Query – Solved | 33:13 (Min.) | ||
| Lesson 2 : Import Data from Website | 07:16 (Min.) | ||
| Lesson 3 : Picture, PDF and Excel Workbook | 14:02 (Min.) | ||
| Lesson 4 : Large Data Set Practice File | 18:18 (Min.) | ||
| Lesson 5 : Data for Power BI | 08:02 (Min.) | ||
| Lesson 6 : Getting Data from Multiple Tables | 08:46 (Min.) | ||
| Lesson 7 : Append Data using Power Query | 22:28 (Min.) | ||
| Lesson 8 : Append Data from Sheet | 07:44 (Min.) | ||
| Lesson 9 : Merge Data using Power Query | 12:29 (Min.) | ||
| Lesson 10 : Append Data from PDF | 14:17 (Min.) | ||
| Lesson 11 : Assignment on Merge Data | 12:00 (Min.) | ||
| Lesson 12 : Multiple Column Lookup – Merge Data | 09:10 (Min.) | ||
| Lesson 13 : Assignment Find out Working Days | 14:17 (Min.) | ||
| Lesson 14 : Appending Data from CSV | 10:03 (Min.) | ||
| Lesson 15 : Home Tab Useful Options | 31:29 (Min.) | ||
| Lesson 16 : Group by to Summarize Record | 12:15 (Min.) | ||
| Lesson 17 : Advance Group by Trick.xlsx | 12:17 (Min.) | ||
| Lesson 18 : Assignment on Group by | 10:44 (Min.) | ||
| Lesson 19 : Pivot and Unpivot Columns | 05:19 (Min.) | ||
| Lesson 20 : Work with JSON File | 07:58 (Min.) | ||
| Lesson 21 : Transform Tab in Power Query | 16:15 (Min.) | ||
| Lesson 22 : Statistics, Standard and Scientific Options | 11:43 (Min.) | ||
| Lesson 23 : Work on Date and Time in Power Query | 13:29 (Min.) | ||
| Lesson 24 : Column From Example | 11:41 (Min.) | ||
| Lesson 25 : Assignment on Column from Example | 06:14 (Min.) | ||
| Lesson 26 : Conditional Column in Power Query | 07:13 (Min.) | ||
| Lesson 27 : Interview Question on Conditional Column | 10:26 (Min.) | ||
| Lesson 28 : CDR Real Job Query | 23:55 (Min.) | ||
| Lesson 29 : Real Job Query – Data Transforming | 09:51 (Min.) | ||
| Lesson 30 : Real Job Query using Custom Column | 11:00 (Min.) | ||
| Lesson 31 : Real Job Query of Appending Data | 11:03 (Min.) | ||
| Lesson 32 : Appending CSV by Removing Junk Rows | 24:04 (Min.) | ||
| Project 1 : Append Data of Excel Workbooks from Gmail Attachment | 38:25 (Min.) | ||
| Project 2 : Append Data of Excel Workbooks from Microsoft Email Account | 27:29 (Min.) | ||
Your Questions, Our Answers
Find answers to frequently asked questions about the course below. If you have any other questions, feel free to contact our support team at info@satishdhawale.com
This course is for anyone who wants to learn Excel. Whether you’re a student, a professional, or a beginner, it will help you build skills step by step.
No, you don’t need any prior knowledge. This course starts from the basics and takes you to advanced topics gradually.
Yes, every topic includes examples and assignments so you can practice and learn by doing.
You can complete the course at your own speed, but most people finish it in 30 to 45 days by studying a little each day.
Yes, we provide support to help you with any questions or doubts you may have during the course.
Absolutely! You’ll learn skills like data analysis, reporting, and advanced formulas, which are very useful in many jobs and industries.
Yes, you will receive an ISO Certificate after completing this course. You just need to pass an exam with a minimum score of 40% to get the certificate. You can also verify your certificate on our website.
Yes, we have 7-days refund policy. If you are not satisfied with this course. We will refund your money. You read the refund policy here => skillcourse.in/refund-policy/
No, you can see the course price very affordable. So we have no EMI option. You can pay using your credit card and convert it into EMIs from your end.
You will get lifetime course access or updates.
Reviews from, Our Learners
4.9 out of 5 stars (based on 365 reviews)
Thank you so much Satish sir for creating this Excel course.
Verified
best teaching with very high level material in excel , I like this job and god bless you sir , i love you my heart but i am a male
Verified
Best
Verified
Excellent
Verified
Bahut badiya course hai. mujhe bahut kuch sikhane mila hai specially aapne job preparation ke liye interview question bhi explain kiye wo bahut aacha laga satish sir.
Verified