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.

Categorize the status of each apartment

Categorize the status of each apartment - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Categorize the status of each apartment

“

- [Instructor] You and I help manage an apartment complex and the owner has asked us to categorize each apartment based on the number of days until their lease expires. And we see the categories in column I, Immediate through Future2. The reason we'd wanna do this, we need time to schedule painters. We'd like to send somebody some flowers for just signing the lease if that's the case. with the status. And use a formula, don't type this stuff out. And then, finally, insert a slicer for that status column. Pause the video, fill this in, come back, and I'll show you a solution. Okay, you're back. Let's dive in. First, in order to use a slicer, we have to put this into a table. So, from the Home tab, we're gonna Format as Table. And let's use orange. Now I wanna double-click to open everything up so we can see. So in order to do our statuses, we need to set ourselves up to do a Vlookup using True. So we're gonna set…

Contents