Complete Introduction to Excel Power Query
Quickly and effectively learn to load, transfor, cleanse and prepare data for Microsoft Excel using Power Query
4.64 (5081 reviews)
14 876
students
2 hours
content
Mar 2025
last update
$74.99
regular price
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
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
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.
Related Topics
1951188
udemy ID
06/10/2018
course created date
21/11/2019
course indexed date
Bot
course submited by