From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Help find our perfect home

Help find our perfect home - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Help find our perfect home

“

- [Instructor] Today is an exciting day. We are ready to buy a house. And here is a list of addresses that are in our budget. But of course, we don't wanna look at all of these. That's where your help is needed. Let's filter this list down for the following criteria: at least three bedrooms, one-level house, has to have a garage. And then finally, sort by square feet, smallest to largest. Pause the video, filter the list, then come back and I'll walk you through a solution. Okay, you're back, and I am eager to go house shopping, so let's dive in. I'm gonna put my cursor inside the data set then convert this to a table. Let's go with this blue here. OK. Now I'm gonna insert slicers. Go to Insert. Slicer, okay, which slicers do I want? So the criteria are Bedrooms, Levels. And then we want Garage (Cars), click that. OK. Now let's put these in a position where they're useful. Slide this a little bit out of the…

Contents