From the course: Excel 2016: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Advanced Filter for specialized filters

Using Advanced Filter for specialized filters

From the course: Excel 2016: Managing and Analyzing Data

Start my 1-month free trial

Using Advanced Filter for specialized filters

“

- [Voiceover] On this worksheet called Specialized, I've got a list of about 900 entries, we're talking about transactions, and you can see by viewing any one of the records here what's going on. We've got salespersons selling different products, they can all sell to different regions, by customers, date, but we're trying to find something that we can't get to with the standard filter. Now, if you've seen the previous movie, you know that if you're about to use Advanced Filter, it's best to set up an area above the data, copy the titles. We'll be using the area up here for a criteria range. I'd like to be able to focus on just our Tuesday sales. Whether that's high or low, we don't necessarily know that yet, but how do we isolate data by day of the week? You might or may not be familiar with the function called Weekday. I'm gonna be using this off here to the right just for demonstration purposes. =weekday, the answer we get if we apply the Weekday function to a date is gonna be…

Contents