How to use Filter in excel in proper way | Filter formula | Auto Filter |Advanced Filter

How to use Filter in excel in the proper way | Filter formula | Auto Filter |Advanced Filter
In this Tutorial, you will learn How to use Filter from basic to advance. I covered all filter-related topic that helps boost your knowledge in Excel as well as shared practice file so you can practice it & cross-check your knowledge. If this video helps you to gain knowledge so, do hit the like button and Share it with your Friends & office buddies also don't forget to comment down below on what would you like to learn?
#Ms-excel
#Filter
#advancedfilter
---------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
---------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
---------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
---------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
---------------------------------------------------------------------------------------------------------------------------
My KZread Gears :
Best Mic for Recording (Condenser Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

Пікірлер: 133

  • @Excel_Tutorial
    @Excel_Tutorial Жыл бұрын

    Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course ✅ Watch on Desktop : skillcourse.in/

  • @user-bg2jp4nn1g
    @user-bg2jp4nn1g Жыл бұрын

    Thank you sir मैं आपका हर video dekhta hun आपका teaching बोहोत अछा हैं। आपके जैसा teaching KZread मैं मैने और nehi पाया। भगवान आपको लम्बी उम्र दें ताकि हम सबको और ज्ञान प्राप्ति हो आपसे। आप जब समझाते हैं तो सीधा mind main save होता हैं। मैं आपका paid member hun sir आपसे मुझको बोहोत ज्ञान प्राप्ति हूई सर Thank you so much sir

  • @muhammadsadiq8885
    @muhammadsadiq88855 ай бұрын

    yes, truly, your videos are for beginners to advanced as you say.

  • @AzeemKhan-jw6mh
    @AzeemKhan-jw6mh Жыл бұрын

    Fantastic. Very informative. God bless you.

  • @user-gp6pt5ry8x
    @user-gp6pt5ry8x7 ай бұрын

    Very nicely explained especially the auto filter which was not aware to me. In advance filter extacting unique records for any field also available.

  • @zoyamalik1456
    @zoyamalik1456 Жыл бұрын

    Thnkiu ❤️❤️❤️ sir ap ki video se bhot kuch sikhne ko mila 😘😘

  • @mohammadilyas2260
    @mohammadilyas2260 Жыл бұрын

    Excellent زبردست from Pakistan

  • @mofajjalhossain7334
    @mofajjalhossain7334 Жыл бұрын

    Superb class about❣️❣️❣️Filter

  • @satishagrwal4912
    @satishagrwal4912 Жыл бұрын

    Very useful information

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 Жыл бұрын

    अति उत्तम सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

  • @shirishvaidya161
    @shirishvaidya16110 ай бұрын

    Very Usefull, Thanks

  • @arvindnegi5978
    @arvindnegi597811 ай бұрын

    Great 👍🏻

  • @rsdhanda38
    @rsdhanda38 Жыл бұрын

    Excellent 👌

  • @Kashish_k_
    @Kashish_k_6 ай бұрын

    Thank you sir aapki video se bhot kuch sikhne ko mila ❤❤❤

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @akshaymishrashastri
    @akshaymishrashastri Жыл бұрын

    Wow Nice and most awaited for me Thanks

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    Most welcome 😊

  • @iamsawairah1308
    @iamsawairah13082 ай бұрын

    I enrolled in your 30 days Excel course. I have become your fan sir. Please make a video on how to make time table for school

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Noted

  • @rekharawat5463
    @rekharawat5463 Жыл бұрын

    Super sir......I want you make more videos

  • @somrajbanerjee3500
    @somrajbanerjee3500 Жыл бұрын

    Excellent 🙏

  • @abhishekkesarwani554
    @abhishekkesarwani554 Жыл бұрын

    Excellent. Thnk u

  • @knowledgeandlearning1293
    @knowledgeandlearning1293Ай бұрын

    Bahut badhiya dost. Thanks

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.

  • @vijayprajapati8883
    @vijayprajapati8883 Жыл бұрын

    Tussi grate ho sahab

  • @jamadaralam
    @jamadaralam Жыл бұрын

    Auto filter part is good 👍

  • @Shubh9898
    @Shubh9898 Жыл бұрын

    Thanks for advance filter sir ... your all videos are veryyy helpful.

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    Thanks and welcome

  • @universetv7985

    @universetv7985

    Жыл бұрын

    ऐसा ही वीडियो खोज रहा था सर जी।

  • @dayanandbidve5669
    @dayanandbidve566924 күн бұрын

    Sir very useful tutorial. Made another advance course.

  • @aashishsahu2563
    @aashishsahu2563 Жыл бұрын

    Nice video sir gi

  • @darshitchavda8264
    @darshitchavda8264 Жыл бұрын

    Amazing

  • @chhewangtamang4695
    @chhewangtamang4695 Жыл бұрын

    Thank you sir I am a beginner at excel learner. I watch most of your videos. I am learning from your video step by step.

  • @s.screation2277
    @s.screation2277 Жыл бұрын

    Nice Satish sir

  • @masroorahmed3462
    @masroorahmed3462 Жыл бұрын

    shukria sir aapny mujhy zero to expert bana diya shukria sir

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    Thank you share with your friends.

  • @masroorahmed3462

    @masroorahmed3462

    Жыл бұрын

    @@Excel_Tutorial sir no tension me to kisi ka mobile uthata hun to aapka channel sab ke sab channel subscribe kar deta hun haaha 😃😂😂😂

  • @masroorahmed3462

    @masroorahmed3462

    Жыл бұрын

    @@Excel_Tutorial sir meny bacho ko bata diya hai ke yeh satish sir ka channel hai jisi ka b phone uthao to channel ko subscribe kar dety hain aap hi ki tarah jesy aap karty thy

  • @maheshsanghani6380
    @maheshsanghani63806 ай бұрын

    good way to learn !! thanks

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    You are welcome!, Keep watching the new videos I am uploading.

  • @mohsinfahim3598
    @mohsinfahim35985 ай бұрын

    Best explanation ❤

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @Memestopper-812
    @Memestopper-8124 ай бұрын

    🙌

  • @ExcelBaba
    @ExcelBaba Жыл бұрын

    Super video

  • @nidhi4774
    @nidhi47749 ай бұрын

    👏

  • @DEADYBOYS
    @DEADYBOYS Жыл бұрын

    Sir ji isme unique record only ka use kese kre or 1 query sir dproduct fungtion ka alternative kya use kr sakte hai

  • @amritathakur2036
    @amritathakur2036 Жыл бұрын

    Wah sir ji thanks sir ji

  • @pinkiharshitphatak2934
    @pinkiharshitphatak2934 Жыл бұрын

    Superb video

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    Thank you so much 😀

  • @prasadtakarwankar7463
    @prasadtakarwankar7463 Жыл бұрын

    Superb.. Sir, Please make a video where we can apply filter with multiple colors.

  • @ExcelBaba

    @ExcelBaba

    Жыл бұрын

    Mujhe bhi janana hai, VBA me colour index se to ho jata hai, lekin bina VBA?

  • @ananditasharma1
    @ananditasharma19 ай бұрын

    Autofilter is excellent, thanks

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Keep watching

  • @gitadevi697
    @gitadevi697 Жыл бұрын

    Waaaao ☺️☺️☺️☺️

  • @jigyasagarg1935
    @jigyasagarg1935 Жыл бұрын

    Nice

  • @bhavikaparmar3699
    @bhavikaparmar36995 ай бұрын

    👌👌👌

  • @jyothisram229
    @jyothisram2294 ай бұрын

    Can we filter data in one column as the order of other column data

  • @user-vk3zl3vw7p
    @user-vk3zl3vw7p9 ай бұрын

    sir Please provide practice sheet & i also buy your course and downloaded app.

  • @azhadshamim3122
    @azhadshamim312214 күн бұрын

    Good evening from Doha Sir how can use filter farmula to see records from 1 sheet to other sheet through the criteria ? Thank you

  • @ashutoshsingh598
    @ashutoshsingh598 Жыл бұрын

    Very nice 👍👍👍👍👍👍👍👍👍👍 video Jay shree

  • @d0minic46
    @d0minic46 Жыл бұрын

    Sir kya ms office or libre office ki all rules,short cuts same hai? Please reply

  • @jitendratyagi2027
    @jitendratyagi2027 Жыл бұрын

    Satish sir aap mujhe basic excel, advance excel and mis ka link provided kre apne. Channel Playlist me nhi mil rha Hai chapter vise

  • @mohansingh2872
    @mohansingh2872 Жыл бұрын

    Sir I have two questions Kya ham ek worksheet par sirf ek hi bar filter use kr skta ha kya What is the use of sheet view in filter sir

  • @user-sr3ek4rv6j
    @user-sr3ek4rv6j7 ай бұрын

    ❤❤❤

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @nadeempathan8909
    @nadeempathan8909 Жыл бұрын

    Good evening sir

  • @mohsinfahim3598
    @mohsinfahim35985 ай бұрын

    if we have only age duration e.g 23 y 2 m 20 days, than can ve able to determine the date of birth by this duration through excel?

  • @universetv7985
    @universetv7985 Жыл бұрын

    ऐसा ही वीडियो खोज रहा था सर जी।

  • @DEADYBOYS
    @DEADYBOYS Жыл бұрын

    Sir ji ek video aggregate Function ke user bhi banao Dynamic abhi bhi bahut daut hai aggregate Function me

  • @ypainkra
    @ypainkraАй бұрын

    Kya Jo Desh Ka Name Jyada baar ho o Sabse Upar Aur Jo kam Baar ho o Niche aa jaye. yani ki Baar wise Filter ...jaisa rank wise filter me hota hai aisa nai ho sakta kya

  • @kanchankumarimishra3738
    @kanchankumarimishra37385 ай бұрын

    plz make a vdeo on data hygine

  • @butanianand7378
    @butanianand73784 ай бұрын

    How can apply filter only one column? Please make video about it...

  • @vishalvighne3747
    @vishalvighne3747 Жыл бұрын

    Sir aapki offline classes kha hai location...

  • @updalvi
    @updalvi3 ай бұрын

    I thought you would show how to remove the filter function after finishing the required editing .

  • @shivnama007
    @shivnama0073 ай бұрын

    Sir filter me counting krni ho to kese kre Kisi customer me koi saman kisi month me kitni baar buy kiya h uska pta kese lgaye

  • @gameslivestreamlink5130
    @gameslivestreamlink5130 Жыл бұрын

    Sir plzz plzz plzz govt school clerk k tamaaam kaam word excel main jo hote hain plzzz tutorial bara sa bana dain plzzzz

  • @shilpimaheshwari2144
    @shilpimaheshwari21447 ай бұрын

    Any course for chat gpt AI excel

  • @ynagesh839
    @ynagesh839 Жыл бұрын

    Hi sir, good morning, how to download the practice file

  • @N_H12345
    @N_H12345 Жыл бұрын

    Data validation me list banane ke liye agar kisi column me bahut se state ka naam Diya gaya ho to ham chahte ha ki wo column ko selection karte hi unique state name ka drop down list ban jaye agala se unique nahi nikalna pade wo kaise ho ga

  • @siyadoll
    @siyadoll Жыл бұрын

    suno jo =filter likhty hn excel m mera ms office 2019 how simple filter ka function ni deta filterxml bs likha ata hai kya kru

  • @Khan-yw2bg
    @Khan-yw2bg Жыл бұрын

    Sir mujhe apke academy se online excel sikhna h per online course me sirf videos hote Hai practical questions hum nhi kr pate to apke course me practical practices available Hai Kya ?

  • @sonaligupta7401
    @sonaligupta74015 ай бұрын

    Sir agar agar beech beech me blank called bhi hai to filter Kaise lagaye

  • @anuragshrivstava212
    @anuragshrivstava2122 ай бұрын

    Sir multiple text he hme sirf ek common bs uthana h bo kese uthay

  • @digitalpranav1824
    @digitalpranav18243 ай бұрын

    plz give this Filters Practice File Link here!!! i can't find in the description

  • @PraveenKumar-hn2xt
    @PraveenKumar-hn2xt11 ай бұрын

    In Bank statement how filter out interest, dividend, salary etc

  • @parsoyasanju372
    @parsoyasanju372 Жыл бұрын

    Sir aap ki ofline class chal rhi h kya

  • @prashantgupta1494
    @prashantgupta14942 ай бұрын

    If I want to filter above 10 & below -10 than how to do it

  • @vijaybhadrike7962
    @vijaybhadrike7962 Жыл бұрын

    One'of the best teacher on KZread ❤️❤️❤️

  • @ExcelBaba

    @ExcelBaba

    Жыл бұрын

    Totally agree 👍

  • @tenexcrowle5229
    @tenexcrowle52292 күн бұрын

    Sir filter mai search colom nahi mil raha hai

  • @mohansingh2872
    @mohansingh2872 Жыл бұрын

    Sir filter formula do sa Jada conditions pr work nhi kar raha ha Please reply

  • @atulmittalco1969
    @atulmittalco1969 Жыл бұрын

    Wild character use in filter?

  • @jitenderpatil2371
    @jitenderpatil2371 Жыл бұрын

    sir mere data base main A se Az tak collums hain our 50,000 records hai muze kabi B,I , Q, V, AA, AD, AK, AS, aise bohut sare filter lagane padte hain our muje data ko hamesha scoral karna padta hai kya mai jaise filter collum main hote hain vaise hi button laga sakta houn please help me sir

  • @raotechtelugu

    @raotechtelugu

    Жыл бұрын

    "Freeze" option select karna hai

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 Жыл бұрын

    Sir, please Macro पर basic से advance तक पूरी series एक बार फिर से समझाइए, official work मे इसका use easily कैसे कर सकते हैं please guide me sir, pivot table, Vlookup, Xlookup, Power BI, Power Query, Copy data from one workbook to another workbook, copy paste करने पर searchable drop down list work नहीं karta जिससे rows and columns highlighted ho sake, Agreegate function का full series, Subtotal function का full series, Trim formula ka अच्छे से use करना, कुछ जगह पर trim function भी काम नहीं karta, तब उसके जगह पर कौन सा ऐसा function use करे जिससे extra spaces remove ho Jaye, heavy excel file hang हो जाती है हमेसा, उसके लिए क्या कर सकते हैं जिससे वह file proper काम करे, कृपया मार्गदर्शन करे please बहुत आभारी रहूँगा आपका सर, कृपया मार्गदर्शन करे l कभी मेरा भी नाम Query के साथ चैनल पर प्रसारित किजिये सर, दिल को खुशी मिलेगी l इंतज़ार रहेगा आपके Reply आने का 🌷🌷🌷🌷🌷🌷🌷🌷🌷 आपका दोस्त ARUN KUMAR SINGH, Ballia UP 🌹राधे राधे 🌹ARK 🔥🏹 हमेसा हंसते मुस्कुराते रहिये l

  • @aakashs3099
    @aakashs3099 Жыл бұрын

    How to download excel practice file?

  • @amritathakur2036

    @amritathakur2036

    Жыл бұрын

    Same problem

  • @searchknowledge6368
    @searchknowledge6368 Жыл бұрын

    Excel ko auto update web link kaise banaye

  • @seemapanchal1693
    @seemapanchal1693 Жыл бұрын

    Advance filter m transpose kase kre

  • @abhisharma8461
    @abhisharma8461 Жыл бұрын

    Sir excel sheet par male and female ko alag alag kaise kare,

  • @ExcelBaba

    @ExcelBaba

    Жыл бұрын

    Pyar ke dushman

  • @abhisharma8461

    @abhisharma8461

    Жыл бұрын

    @@ExcelBaba 😄😄 nhi bhai

  • @hornetsubhendu8380
    @hornetsubhendu83802 ай бұрын

    Prctice file nahi mil rahaha

  • @Sanandiya_family
    @Sanandiya_family Жыл бұрын

    Excel microsoft office qr code create in

  • @nareshdhiman1536
    @nareshdhiman1536 Жыл бұрын

    unable to get practice file Satish sir in the telegram

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    t.me/learnmoreindia/655

  • @nareshdhiman1536

    @nareshdhiman1536

    Жыл бұрын

    Thanks a lot Sir

  • @PAWANKUMARSWAMI
    @PAWANKUMARSWAMI Жыл бұрын

    शानदार

  • @ShaibulHoqueMozumder
    @ShaibulHoqueMozumder Жыл бұрын

    prcatice FILE PLEASE

  • @gamehub8068
    @gamehub8068 Жыл бұрын

    सर मेरे कंप्यूटर में फील्डर का साइज छोटा हो गया है जो फिल्टर बॉक्स खुलता है वह छोटा साइज है दम छोटा हो गया मऊ से खींचने पर बड़ा हो जाता है लेकिन उसके बाद दोबारा फिर खोलने पर फिर छोटा ही खुलता है इसको कैसे बड़ा करे

  • @khalidalisubhanallah2947
    @khalidalisubhanallah2947 Жыл бұрын

    Very knowledgeable video sir. Sheet menu k option ki detail main batain. Thanks

  • @Funnyment1990
    @Funnyment1990Ай бұрын

    Practice sheet to di nhi keval bol dte ho

  • @KanhaiyaKumar-rg8xb
    @KanhaiyaKumar-rg8xb Жыл бұрын

    Nice video sir

  • @roshannayak3760
    @roshannayak37603 ай бұрын

    मेरे लैपटॉपमे नंबर फ़िल्टर नहिंदीखता है

  • @masroorahmed3462
    @masroorahmed3462 Жыл бұрын

    ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

  • @bhimraopatil5169
    @bhimraopatil51699 ай бұрын

    एक सेल मे एक से ज्यादा नाम विखे है. कुछ सेल मे एकही नाम लिखा है. दो हजार सेल है. मराठी भाषा में नाम लिखा है. तो अ से ज्ञ तक नाम साँर्ट करने है कैसै करे. ईसबआरएमए पहिले व्हिडीओ बना है क्या

  • @haryanviRagniVideoBypwn
    @haryanviRagniVideoBypwn Жыл бұрын

    Data validation wale cell m koi or value chahiye muje. Jo os list m na ho.. wo kaise dalu cell k andar. List p pahle hi password laga ho to

  • @masroorahmed3462
    @masroorahmed3462 Жыл бұрын

    Sir Ms Word, Excel Ki Shortcut Keys Ka Videos Banao Wesy To Mujhy Shortcut Keys Ka Pata Hai Aap Bhi Bana Lo Iska Video Edit Header Ke Liye Alt+V+H Paragraph Dialogue Box Ke Liye Alt+O+P Symbol Dialogue Box Ke Liye Alt+I+S Bookmark Ke Liye Alt+I+K Clipboard Open Karny Ke Liye Alt+E+B Auto Correct Options Ke Liye Alt+T+A General Options Ke Liye Alt+T+O Watermark Ke Liye Alt+O+K+W Ms Word Me Columns Dialogue Box Open Karny Ke Liye Alt+O+C Select All Karny Ke Liya Wesy To Ctrl+A Use Karty Hain Me Ctrl+Num 5 Ka Use Karta Hun Or Alt+E+L

  • @ExcelBaba

    @ExcelBaba

    Жыл бұрын

    Aapko bhi kaafi knowledge hai

  • @uttamkarmakar9701

    @uttamkarmakar9701

    Жыл бұрын

    @@ExcelBaba bhai sab o e dikhane k liye comment kiya hai

  • @AnamikaRaghuvanshiunique
    @AnamikaRaghuvanshiunique Жыл бұрын

    Sir pls CCC ka videos bnye

  • @LamiyaAnsari001
    @LamiyaAnsari001 Жыл бұрын

    Sir please ccc ka chapter wise tutorial dijiye🥺🥺

  • @asadjaved4721
    @asadjaved4721 Жыл бұрын

    Sir excel ka complete all tab ka vedio chahey

  • @masroorahmed3462
    @masroorahmed3462 Жыл бұрын

    Ms Excel Ke Liye Bhi Video Banao Jesy Ke Custom Views Dialogue Box Open Karny Ke Liye Alt+V+V Formula Bar Ko Show/Hide Karny Ke Liye Alt+V+F Scenario Manager Open Karny Ke Liye Alt+T+E Paste Special Dialogue Box Open Karny Ke Liye Wesy To Ctrl+Alt+V Use Karty Hain Ek Or Key Ho Jaye To Kya Khayal Hai Sir Alt+E+S

Келесі