Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel Power Query

Complete Tutorial -PowerQuery Basic to Advance
4.1
☆☆☆☆☆ 4.1/5
(63 reviews)
303 students
Created by
ajay parmar

9.4

Classbaze Grade®

9.9

Freshness

8.4

Popularity

9.4

Material

Detailed Analysis »

Complete Tutorial -PowerQuery Basic to Advance
Go to course »
Platform: Udemy
Price: check current price
Video: 10h 15m
Language: English
Next start: On Demand

Best Power Query classes:

Skillshare_logo_2020
Best Power Query classes on Skillshare »
Coursera Logo
Best Power Query classes on Coursera »
Pluralsight Logo
BestPower Query classes on PluralSight »
Udemy logo
Best Power Query classes on Udemy »
linkedin
Best Power Query classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

9.4 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

9.9 / 10
This course was last updated on 3/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

8.4 / 10
We analyzed factors such as the rating (4.1/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.4 / 10
Video Score: 9.1 / 10
The course includes 10h 15m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 3 hours 53 minutes of 29 Power Query courses on Udemy.
Detail Score: 9.6 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
20 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

•This course covers the Basic and Advance PowerQuery
•From installing the PQ to checking the system requirements and Its definition.
•Covering the PQ ribbon – all features with examples in full detail
•Why it is called ETL Tool – Extract Transform Load
•Benefits of Powerquery over normal Excel spread sheets
•Handling millions and billions rows efficiently
•How to import data from different sources like txt , csv,folders, databases, excel sheets
•Every minute detail about PQ ribbon features with the help of examples
•Know your magnificent Group by feature – Complete tutorial including projects
•Date functions – Very easy and powerful
•Text Functions in extracting the values is discussed, no need to build now excel formulas or VBA
•PQ functions – CSV.Document , Excel.Currentworkbook, excel.workbook are discussed with practical examples
•Transpose feature, UnPivot Feature – where and how they can be used.
•How to use first row as header, how to change data type and why you should know this.
•How to reverse the rows of your table.
•How to use replace value feature and how to use Fill values button in Powerquery under Transform tab
•How to use split, columns from example, edit custom columns.
•How to extract the numbers, texts or num to digit and vice versa
•Several practical projects for you with solutions – Amazing result driven projects for you
•What are the different types of JOINS – Left Join, Right, Full, left anti, Right Anti – All are covered
•How to use IF statements in PQ and how they are beneficial in real time projects
•How to change the source or location of data, What is refresh and refresh all ,Connection only ,close and close and load to options
•How to use website tables data in excel using powerquery- Its called webscraping
•Several advance level projects with quizzes (solution given in lectures)
•Online support 24*7 given by me to address your issues

What can you learn from this course?

✓ How to use PowerQuery in Cleaning and Transforming the complex , unstructured and tidy data mess.
✓ PowerQuery Ribbon features – Each and Every feature is discussed with examples.
✓ How to work with millions of rows coming from external sources or within excel sheets
✓ You will see several complex projects and quizzes with solution to see the real use of powerquery in your office.
✓ Amazing Data cleaning techniques, data mining, making it fit for reports – You shall learn in this.
✓ How to work with websites to get their information

What you need to start the course?

• You should have atleast excel 2010 installed and basic knowledge of Excel is must. No vba is needed.

Who is this course is made for?

• All the students or professionals who do or want to be a data Analyst and shine in this industry should go for this.
• If you work with millions of data or a data which is not properly structured and you do lot of steps to clean it first , before making reports on it.
• if you want to make reports from tidy and unbelievable unstructured data stored in excel spreadsheets you can do it now without VBA.

Are there coupons or discounts for Excel Power Query ? What is the current price?

The course costs $14.99. And currently there is a 40% discount on the original price of the course, which was $24.99. So you save $10 if you enroll the course now.
The average price is $12.9 of 29 Power Query courses. So this course is 16% more expensive than the average Power Query course on Udemy.

Will I be refunded if I'm not satisfied with the Excel Power Query course?

YES, Excel Power Query has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Excel Power Query course, but there is a $10 discount from the original price ($24.99). So the current price is just $14.99.

Who will teach this course? Can I trust ajay parmar?

ajay parmar has created 52 courses that got 841 reviews which are generally positive. ajay parmar has taught 3,255 students and received a 4.5 average review out of 841 reviews. Depending on the information available, we think that ajay parmar is an instructor that you can trust.

Learn everything about

ajay parmar

Instructor – Advance Excel, Excel Vba ,Access, Access Vba
I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Browse all courses by on Classbaze.
ajay parmar's full profile and courses »
Go to class »

9.4

Classbaze Grade®

9.9

Freshness

8.4

Popularity

9.4

Material

Detailed Analysis »

Complete Tutorial -PowerQuery Basic to Advance
Go to course »
Platform: Udemy
Price: check current price
Video: 10h 15m
Language: English
Next start: On Demand

Classbaze recommendations for you

Other courses by ​ajay parmar

Go to class »