From the course: Excel: Power Query for Beginners
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Filtering and sorting data
From the course: Excel: Power Query for Beginners
Filtering and sorting data
- [Tutor] Often data will come to you with rows that you just don't need. For example, down at row 50, you can see we have some test entry rows here that won't be helpful when we're analyzing this data. And then also down at around row 100 we've got these N/As here. So we're going to use power query and remove these rows. So scroll back up to the top here and you want to make sure the queries pane is open on the right. If it's not open, go ahead and go on over to the data tab, click queries and connections or click show queries if you have an earlier version of Excel. And to clean up this data, I'm going to right click and then choose edit. Okay, great. So let's remove those problematic rows that we don't want to include in the dataset. I'll go ahead and go over here to let's say the contact name and sure enough, there's our NAs. We'll remove those rows and we'll also remove the test entry rows, and that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.