Complete Introduction to Excel Power Query

Quickly and effectively learn to load, transfor, cleanse and prepare data for Microsoft Excel using Power Query

4.67 (5175 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video

Lifetime access to course materials and practice activities from an experienced Udemy instructor

Learn how to use Excel Power Query to CONNECT and TRANSFORM data in Excel

Have a COMPREHENSIVE understanding of connecting and transforming data using Excel 2016

Load data into Excel from multiple DIFFERENT SOURCES such as SQL Server, CSV, XML, JSON and SQL Analysis Services

Transform data by filtering, changing data types, removing columns and performing BASIC transformations

Perform ADVANCED transformation such as Merging, Appending, Unpivoting, Grouping and custom calculations

Learn to CLEAN data and LOAD data using parameters

Course Gallery

Complete Introduction to Excel Power Query – Screenshot 1 — Screenshot 1 – Complete Introduction to Excel Power Query

Complete Introduction to Excel Power Query – Screenshot 2 — Screenshot 2 – Complete Introduction to Excel Power Query

Complete Introduction to Excel Power Query – Screenshot 3 — Screenshot 3 – Complete Introduction to Excel Power Query

Complete Introduction to Excel Power Query – Screenshot 4 — Screenshot 4 – Complete Introduction to Excel Power Query

Loading charts...

Comidoc Review

Our Verdict

This comprehensive course by an experienced Udemy instructor offers clear insights into Excel Power Query for connecting, transforming, cleansing, and preparing data within Microsoft Excel. The hands-on exercises provide a solid foundation for learners to explore more advanced features independently. However, users should be prepared for occasional navigation mishaps due to varying interfaces between different Excel versions. With minor course adjustments, this can become an essential tool in modern professionals' skillsets.

What We Liked

The course offers clear and concise step-by-step lessons in transforming and connecting data using Excel Power Query for Microsoft Excel.
Real-world practical exercises help to reinforce understanding of the tools, making it easier to recall and apply features.
Instructor provides a comprehensive understanding of various transformation techniques like Merging, Appending, Grouping, and custom calculations.

Potential Drawbacks

Some lessons move at a fast pace without ample time for learners to practice each step; instructors should consider pauses between steps for better follow-along capabilities.
Instructions could benefit from more clarity in cases where errors are generated in the output; a detailed explanation about how to resolve these issues would enhance user experience.
Course content is compatible with Excel 2016, but there are discrepancies between users' interface and the video. Providing updated screenshots reflecting various Excel versions could improve user experience.