From the course: Excel: Filtering Data for Beginners
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Use Power Query to filter - Microsoft Excel Tutorial
From the course: Excel: Filtering Data for Beginners
Use Power Query to filter
- [Instructor] Sometimes you need to filter out data and put it on another sheet. And you can certainly do that using the power query editor. So for example, I've got all of my data here on this sheet, it's called All Data. But let's say I wanted to filter out Robert's sales and put those on this tab. I can certainly do that, and I'll show you how. First I'm going to go up to the data tab and I'm going to click from table range. Now in some versions of Excel you won't see this button on the data tab. Instead it will be on the power query tab. And if you don't see that tab, then you need to enable it. And if that's the case for you, check out the practice file called Get Power Query and it will walk you through enabling it. But with that said I'm going to click from table range and I'm going to go ahead and click okay. And that's going to create a table out of my data. And then Excel is going to launch the power query editor. Now to follow along with our example, I only want Robert's…
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.