Excel Power Query Beginner To Advanced (Including M) Online Course

Welcome to this article on the best Power Query courses available online. Power Query is a data transformation and manipulation tool that is widely used in various industries. It allows users to extract, transform and load large datasets from various sources such as Excel, CSV and databases. With the increasing demand for data analysis skills, many online courses have emerged offering training on how to use Power Query effectively. This article aims to provide an unbiased review of some of the best Power Query courses available online, highlighting their features, pros and cons, and pricing.

Here’s a look at the Best Power Query Courses and Certifications Online and what they have to offer for you!

Excel Power Query Beginner To Advanced (Including M) Online Course

1. Excel Power Query Crash Course by Andy Lanning (Udemy) (Our Best Pick)

The Excel Power Query Crash Course is a short course that comprises 12 lessons aimed at reviewing the basics of Excel’s newest data clean-up tool, Power Query. The purpose of the course is to provide a base level introduction and a few tips and tricks to embolden learners to explore the new tool. Power Query was first launched in Excel 2010, and it has only gotten better and easier since then. Its role is to perform redundant data clean-up that will then be used in data analysis, charts, and pivot tables. The clean-up steps are set up once-and-for-all, and learners can refresh each time they need it.The course access includes project files, homework exercises, 1-on-1 instructor support, LIFETIME access, and a 60-day money-back guarantee. The course has received excellent reviews on Udemy, and it is one of the top-rated Excel Power Query courses. Students have appreciated the instructor’s excellent teaching style, succinct and clear explanations of key concepts, and engaging delivery. Learners have also noted that the course is fast, with no messing around, and that it provides valuable insights even to advance Power Query users.The course’s content is divided into sections, and it covers various topics related to Power Query, including the basics of Power Query, cleaning up data, merging and appending data, and grouping and aggregating data. The Advanced Editor section is particularly exciting, and several learners have appreciated it. Overall, the Excel Power Query Crash Course is a valuable resource for anyone looking to learn more about Power Query and how to use it to clean up data for analysis, charts, and pivot tables.

2. Complete Introduction to Excel Power Query [2022 Edition] by Ian Littlejohn (Udemy)

This course, titled Complete Introduction to Excel Power Query [2022 Edition], is designed to teach individuals how to transform and prepare data for Microsoft Excel using Power Query. The course promises to simplify and expedite the process of acquiring and preparing data for analysis, saving individuals time and increasing efficiency. The course is updated for 2022 and includes full HD, improved content, and updated information.

The course’s content includes: an introduction to the course, basic data transformations (such as filtering data, changing data types, adding new columns, and removing columns), advanced data transformations (merging data into one table, appending data, grouping data, conditional rules, and custom fields), techniques and skills for data cleansing, and connecting to data sources (accessing data from various data sources like files, databases, web URL, and SQL Analysis Services).

The instructor, Ian Littlejohn, is a top-rated trainer on the Udemy platform and has more than 10 years of experience in training and management consulting. He specializes in data analysis and has over 150,000 students.

Learners who sign up for the course will have access to 2.5 hours of HD quality video, 7 downloadable resources, 7 articles, lifetime access, a money-back guarantee (as per Udemy terms and conditions), and a certificate of completion upon course conclusion.

In addition to this course, Ian Littlejohn offers other data analysis courses, including ones on Excel, Power BI, and Google Data Studio.

The course has received positive feedback from students who appreciated the instructor’s explanations of concepts and the course’s focus and brevity.

3. Microsoft Excel – Data Analytics Power Query and PivotTables by Kyle Pew, Office Newb (Udemy)

This course, titled Microsoft Excel – Data Analytics Power Query and PivotTables, is taught by Kyle Pew and Office Newb. It focuses on using Excel’s Power Query and PivotTable tools to quickly clean, transform, and summarize data. Power Query is available on Excel 2016, 2019, and Office 365 through the GET AND TRANSFORM command on the Data tab. However, it is not available on the MAC release of Excel. Power Query is available on Excel 2010 and 2013 through a free download from Microsoft.

Excel Power Query can save significant time performing repetitive tasks such as finding data, cleaning columns, splitting or joining column values, removing unnecessary characters and extra spaces, formatting data correctly, filtering data, combining multiple datasets, and manipulating the data layout to work with other tools. The course breaks down the process into three easy steps: Get Data, Transform/Clean Data, and Report on Data. The program is designed to remember all the steps taken, allowing for quick updates with the click of a Refresh button.

The course includes over 6 hours of video content, downloadable exercise files, and access to the instructor through the QA section. The content covers an introduction to Excel Power Query, retrieving data with Power Query, transforming and cleaning data with Excel’s Power Query, loading Power Query data to destinations, Excel Power Query – Pivot and Unpivot Column Data, grouping Power Query data, creating custom columns with calculations in Power Query, Excel PivotTables and Power Query Data, working with multiple sources in Power Query, Excel Power Query complex data clean up, Excel Power Query parameters, and Excel table variables and Power Query. Upon completion, the course congratulates students on becoming proficient in Excel Power Query.

4. Advanced Excel Power Query-M language, troubleshoot, Pattern by Abhay Gadiya (Udemy)

The Advanced Excel Power Query course, instructed by Abhay Gadiya, focuses on providing learners with an in-depth understanding of the Power Query M Language, ready-made patterns, advanced real-life case studies, and solutions to Power Query limitations.

The course is divided into four major areas: troubleshooting Power Query errors and providing workarounds, real-life case studies requiring more in-depth knowledge of Power Query, advanced M concepts, and providing ready-made patterns for Power Query.

The troubleshooting section of the course covers common areas where users may face Power Query limitations and errors. This section provides workarounds for issues such as errors encountered with column headings, handling null values in arithmetic calculations, identifying error rows during query creation, and issues with filters.

The real-life case studies section showcases how to apply Power Query to real-world datasets. The section includes case studies such as applying local settings when converting date fields, breaking leave details into separate rows from a single cell, unstacking datasets with uneven details, and combining multiple rows of data back into a single cell.

The advanced M concepts section provides learners with more information related to M Language in Power Query. The section covers topics such as syntax for advanced editor, creating and using parameters, creating custom M functions, troubleshooting custom M functions, organizing queries into separate groups, and using Query Dependency view.

The ready-made patterns section provides learners with Power Query code that they can copy and paste into their files. These patterns are complex and require a lot of effort to create, making them valuable resources for learners.

In order to enroll in the course, learners must have the latest version of Power Query installed and prior knowledge of using Power Query. There are no additional requirements beyond these two.

Overall, the Advanced Excel Power Query course provides learners with an in-depth understanding of Power Query and its capabilities, making it a valuable resource for those looking to improve their Excel skills.

5. The Power Pivot, Power Query in Excel and Power BI Bundle by Simon Sez IT (Udemy)

The Power Pivot, Power Query in Excel and Power BI Bundle Course is a two-course bundle that teaches students how to analyze massive amounts of data in Excel and Power BI. The course is taught by Microsoft experts Simon Sez IT and includes practice exercise files. The first course covers Power Pivot, Power Query, and DAX in Excel, and teaches students how to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. The second course covers Power BI, a self-service Business Intelligence solution from Microsoft. Students learn how to organize and clean data using Power Query, build a Data Model, use DAX in Power BI, and present data using charts and graphs. The course includes 7+ hours of video tutorials, 89 individual video lectures, exercise files, and a certificate of completion. Students have given the course positive reviews for its clear instruction and real-world usability.

6. Excel Power Query Training – Beginners to Advanced level by Abhay Gadiya (Udemy)

The Excel Power Query Training course teaches beginners to advanced users how to use the free Microsoft tool, Power Query, for data modeling in Excel 2010-2016 and PowerBI. Power Query enables users to connect to a variety of data sources and automate ETL tasks needed for data analysis in tools like Power Pivot, Power BI, Tableau, Python, or R. The course is designed to be easily accessible to novice Excel users without prior programming knowledge. The goal of the course is to convert dirty data into clean data that can be used for data analytics or business intelligence. The course includes 12 sections covering topics such as importing data, transforming data, consolidating and appending data, merging queries, and using Power Query objects. Each section includes a case study to apply the concepts learned. The course instructor is Abhay Gadiya. A 30-day money-back guarantee is offered for the course.

7. Power Query and Power View – Excel Power Tools Master Class by Paula Guilfoyle CPA & MVP (Udemy)

The Power Query and Power View – Excel Power Tools Master Class Course, taught by Paula Guilfoyle CPA & MVP, offers a comprehensive learning experience for individuals interested in using Excel’s Power Query and Power View features. Power Query is an Excel add-in that enhances self-service business intelligence (BI) by allowing users to discover, combine, and refine data from various sources such as relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power View, on the other hand, is an interactive data exploration, visualization, and presentation experience that provides intuitive ad-hoc reporting for business users.

The course starts by introducing the basics of Power Query, demonstrating how to set it up and use it to extract data from multiple sources and automate daily tasks. Participants are also taught how to transform data of different types and use Power Query to make data usable for reporting and data analytics. In addition, the course covers more advanced features of Power Query, including the language use, known as M, and how to query not just files but also folders of data. Participants are also taught how to sort bad data and use Power Query for automating recurring tasks.

The course also covers the basics of Power View, demonstrating how to use charts and maps of all types to visualize data and aid business decisions. Participants learn how to set up hierarchies to make visualizations more interactive and to spot trends in data easily using visualization. The course provides sample data and a case study to help participants gain a solid working knowledge of Power Query and Power View.

Microsoft’s Excel, which includes Power Query and Power View, is now part of a self-service BI system. The course is ideal for individuals who want to improve their Excel skills beyond the basic level and bring business analytics and data to their organization. The course is divided into two sections, covering Power Query and Power View separately.

8. Revealed: Excel Power Query One Hour Bootcamp (Great Stuff) by Doug Burke (Udemy)

The Revealed: Excel Power Query One Hour Bootcamp course provides a beginner’s guide to using Power Query in real life. The course instructor, Doug Burke, claims that this is the first in his series of Udemy courses on mastering data cleaning in the age of big data. The course is designed for individuals who have limited time to learn data cleaning but are interested in improving their data career opportunities.

The course aims to teach participants how to create fast, repeatable data transformations that improve Excel analysis and reporting using the Power Query Editor and its many push-button, formula, and multi-query functions. Participants will also learn how to change ‘dirty’ data to ‘clean’ data in a structured and reliable way. The course provides a solid foundation to navigate the ribbons and learn more on their own.

According to student comments, the course is simple, well-structured, and easy to follow. The course offers unique video presentations that transfer the most important knowledge from the instructor to the participants. Additionally, the course includes modules that explain the theory behind the techniques and demonstrate their use.

The course promises to save countless hours and avoid mistakes. It aims to prepare individuals for a career that will evolve as the business world changes rapidly. Learning Power Query is presented as the perfect analytics tool for helping companies manage their data. The course consists of four sections, including Power Query Introduction, Power Query Essentials, Three Levels of Power Query Excellence, and Power Query Bonus Lectures. By the end of the course, participants will be able to spend less time manipulating data and more time analyzing it, thus becoming more valuable professionals.

9. Power-Query M language Programming – Part 1 by ajay parmar (Udemy)

Course Title: Power-Query M language Programming – Part 1This course aims to enhance the understanding and usage of M code in PowerQuery for individuals who are already familiar with the software’s front part. The course provides detailed knowledge on how to use M code or functions in PowerQuery and modify them to ensure efficient data analysis. The course covers Table functions and their basics, along with their real-life use. Moreover, the course addresses list objects – from basic to advanced uses, and records – from basics to advance. Several mixed projects are included for students’ revision at the end, with additional knowledge on M functions. The course’s primary focus is to make students proficient in PowerQuery M code and allow them to go beyond regular user capabilities to change and modify data as they desire. The course content and sections include an introduction to M code in PowerQuery, and detailed information on how to use and modify M code in PowerQuery. Students will learn about Table functions and their basics, list objects, and records. The course concludes with mixed projects for revision and additional knowledge on M functions. The course materials are downloadable, and online help is available to students in case of any doubts or questions.

10. Revealed: Power Query Advanced Tips And Tricks by Doug Burke (Udemy)

This course, titled Revealed: Power Query Advanced Tips and Tricks, is the third in a series of Udemy courses focused on mastering data cleaning for big data. The course is designed to teach students how to use Excel Power Query, Microsoft’s tool for simplifying and streamlining data transformations. The course is suitable for data users of all levels, and includes downloadable exercise files, step-by-step video demonstrations, and a three-part case study assignment to reinforce knowledge. The course covers topics such as custom columns, the Power Query Formula Language (M code), embedded functions, and dozens of tips and tricks focused on Power Query’s best features.

The course is intended to help students develop their data analytics career and prepare for the job market. By taking the course, students will learn how to control their data and use Power Query to solve common data cleansing problems encountered by data analysts. The content of the course includes an introduction, sections on how to get the most from the course, how to use Power Query to do more in fewer steps, how to use conditional and custom columns, how to use manual queries, how to use advanced queries, how to use waterfall queries, and how to take advantage of M code.

Overall, this course is designed to teach students advanced Power Query techniques and help them say Wow, I didn’t know I could do that with Power Query! The course is relevant for companies looking to adopt Excel Power Query for next generation data analysis power, and is essential for anyone looking to develop their data career.