Filter & advance filter in excel 2019 | MS Excel | BPA Educators - a podcast by BPA Educators

Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set. Advanced Filter in Excel to create a list of unique items, or to extract specific items to a different worksheet. You can also use complex criteria with an Advanced Filter, so it is useful when a simple AutoFilter can't do what you need. 

#excel #autofilter #exceltips #exceluse #howtouseexcel #bpaeducators #bpa  

Here are the steps for setting up your data, and creating an Advanced Filter. 

-- Set up the database -- Set up the Criteria Range (optional) 

-- Set up the Extract Range (optional) 

-- Apply the Excel Advanced Filter  

BPA Educators has been established with a vision to aid students and professionals in achieving their goals. We at BPA Educators understand the aspirations of young students and professionals. Our sole aim is to reduce the hassle that one can encounter while choosing the right career option. We have striven hard for the past 10 years and trained over 1000+ students till date. Our team of counselors is qualified and experienced, consisting of CA’s, CMA’s, CS, LLB, and MBA’s who have exposure to practical training with hands-on experience in the industry, having experience of 10 to 15 years and growing strong with a commitment to transform the career of students with better opportunities among various age groups.  

We provide the best training and counseling for students right from Class XI and counsel for career stream, we also have various accounting, data analytics, CA, CMA, B.com programs. 

Call: +91-8882196405 

Address: F-17 / 175-176 Basement, Sector-8, Rohini, Delhi-110085.  

Website: www.bpaeducators.com  

Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8

Facebook: https://www.facebook.com/bpaeducator  

Twitter: https://twitter.com/bap_educators  

LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/

Further episodes of BPA Educators

Further podcasts by BPA Educators

Website of BPA Educators