On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

When you're trying to use filtering on multiple columns involving multiple…criteria, the standard filter just doesn't work some of the time.…We need to use an advanced filter.…Suppose in the data here comprised of about 700 rows, we need to see people…from a certain department who are full time and we also want to see people from…another department who are half- time. And you can imagine some other…combinations like that.…What we need to do is set up a criteria range, so let's highlight the first six rows, …put this above the data, insert, and simply copy the top row here, holding…down the Control key drag this upward.…

Let's just pick some departments here, for example ADC. Rather than typing this,…I am just going to copy this up here.…We would like to see out of the ADC department, the full time people. There are…two of them. Once again to save myself some typing here, something with the Ctrl…key I am going to drag this here.…We are also interested in getting and seeing people from the…Engineering/ Maintenance group.…