Excel Lesson - How to Extract Data Using a 2 criteria AND and OR Advanced Filter
Advanced Filters in Excel
Advanced filters will allows you extract or filter data from a dataset based on selected criteria. It works in a different way to filters applied using tables or just adding a filter to a data set.
In this video you will learn how to Extract data using advanced filters in Excel. You will learn how to set up a criteria table for both the AND conditions and OR conditions.
If you have any questions, please do post them in the comments below. Don't forget to like this video and subscribe to my DLive channel
My video is at DLive
if that part I raise my hand, Mrs @paulaq expert about it
This video is an extract from an online course - Basic data analysis in Excel. If you would like to see more of my course material posted on Dlive please do comment below. Also do you think I should set up a different profile on Dlive for my Excel work?
Hi @paulag,..i hear somebody talke about curated league and i am interested to know what is curated league, will you send me a link for more underatstanding?
Oyaa my name is Rizal, i am from Aceh-Indonesia.
Nice to get a warm reply from you.
Hy friend vote
Thankyou @paulag
hi @paulag
I andi satria harahap. my account name is @ andi.satria.hrp,
I am from Indonesia.
I am interested in joining your curated league activities. please register me as a participant.
I will add you to the league :-)
Due to internet connection condition lately, I have been facing problem watching online videos, including the online course I won the other day.
ah that is such a pity
I am using a VPN application and it looks like it's helping a little with text based websites and Discord and Telegram, but not with videos.
Nice and bit sized not to long that it would scare people away. My own excel skills have become so rusty and outdated these days. I really need open up one of the excel books I have and do some relearning.
Does Dlive have video playlists or way to link the similar content? If not I hope they do over time than. That I think would solve things better than making a new profile. Segmentation in trying finding resource like this is also a fear along with it just being lost with a bunch of non-related things.
I would almost think having your own custom tag that then could be searched for along with your name might be better. For finding this kind of content and trying group it all together.
I think viewing from Steemit is the problem. steemit is a back end for all the apps and finding content as we all know is a problem on steemit. Maybe having a second account for my excel stuff would be useful, because at the moment I have other dlive stuff too
Excel is one of the most important and useful application which we use in our office. This tutorial is very useful as filters play a very important role when we have a large database. Thanks for this post.
you are most welcome. I hope to post more