Listed as Free on Udemy when checked on 22 October 2026. No coupon or subscription trial is required for the listed lessons. Enrollment needs a Udemy account; availability can change.
About this course
The creators shepherdd-X – and Only Quality Data focus this course on preparing a table before analysis. Starting from the Excel interface, the lessons bring data into Power Query and develop a repeatable sequence of cleaning and transformation steps.
Examples address missing values, identifiers, conditional columns and extracting pieces of text. The final lesson returns the cleaned result to the workbook and considers refreshing the process when new records arrive.
| Official course | Preparing Data for Analytics with Power Query in Excel |
|---|---|
| Created by | shepherdd-X -; Only Quality Data |
| Platform | Udemy |
| Language | English |
| Level | All Levels — Udemy listing |
| Listed duration | 75 minutes; 8 lectures across 8 sections |
| Certificate | Not included with a new free enrollment |
Skills you’ll gain
- Loading an Excel table into Power Query for transformation
- Recognizing missing values and inconsistent text fields
- Creating derived fields and an index-based identifier
- Understanding the difference between a repeatable query and manual cleanup
A very basic understanding of Excel is requested. The instructor notes that the downloadable practice file differs from the demonstration data, so learners should expect to adapt the method rather than reproduce identical results.
The eight-lecture, 75-minute outline supports a focused data-preparation course. It does not substantiate all the broader Power Pivot and analytics promises in the general description. Excel licensing is separate; Microsoft’s free Power BI Desktop offers Power Query practice on Windows, but its loading destinations and interface differ from the Excel walkthrough. Use sample records instead of confidential employee or customer data.
Microsoft: Power BI Desktop download: A free Windows application for related Power Query practice, not an exact substitute for the Excel workflow.
Related courses for your next step
- Add a related skillData quality and reference data
Focus: Understanding reference data management · Recognizing data-quality measures
Beginner
- Compare another approachData visualization and information design
Focus: Connecting a visual with its intended message · Recognizing a structured visualization process
All Levels
Compare course focus, level and study time
| Course | Level | Focus | Study time |
|---|---|---|---|
| This course — Free Power Query Data Preparation Course: Clean, Transform and Refresh | All Levels | Loading an Excel table into Power Query for transformation · Recognizing missing values and inconsistent text fields · Creating derived fields and an index-based identifier | 75 minutes (Udemy listing) |
| Free Data Quality Course: Understand Reference Data, Rules and Exceptions | Beginner | Understanding reference data management · Recognizing data-quality measures · Following profiling and validation activities | 39 minutes (Udemy listing) |
| Free Data Visualization Course: Information Design and Storytelling | All Levels | Connecting a visual with its intended message · Recognizing a structured visualization process · Exploring chart-selection options | 49 minutes (Udemy listing) |
Frequently asked questions
Will the exercise file match the instructor’s screen exactly?
The instructor explicitly says the supplied data differs from the demonstrated sample to encourage adapting the technique.
Is this the entire analytics program described on the page?
The visible course contains eight lessons centered on Power Query preparation. Other analytics topics are not assumed to be included.
Checked on 22 October 2026 using the public course details and syllabus. Coursya has not watched every lesson or tested full playback. New free enrollments do not include a Udemy completion certificate, instructor Q&A or direct messages.
Questions & discussion
Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.