From the course: Automate Boring Excel Tasks with Power Query

Unlock this course with a free trial

Join today to access over 25,400 courses taught by industry experts.

Challenge: Data cleaning with Power Query

Challenge: Data cleaning with Power Query - Microsoft Excel Tutorial

From the course: Automate Boring Excel Tasks with Power Query

Start my 1-month free trial Buy for my team

Challenge: Data cleaning with Power Query

“

Now, it's your turn. In this challenge, you're going to take this messy lab sample file and turn it into a clean, refreshable table using Power Query. You'll find instructions and some tips on the first sheet. I recommend taking a screenshot or copying them to another app, so you can reference them as you work. Because once you open the query editor, it takes over the screen and you can't reference the Excel workbook until you close it. In the next video, I'll step through the solution.

Contents