Use of Filter in Excel Explained in Detail || Filter in Excel || Use of Filter in Excel

Guy's in this video I have explained the data filter option in detail for my excel basic learners if you find this video is useful you know what you are going to do for it....of-course hit the like button.
* Filter in excel
* Data tab filter option
#BasicExcel
#FilterInExcel
#UseOfFilterInHindi
------------------------------------------------------------------------------------------------------------------------------
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 (Condensor 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
Watch other Videos :
Excel Basic to Advance Series : • Excel tutorial || Exce...
Excel Amazing Features - • समय बचाना है तो सीखो य...
Excel Advance 100 Videos - • Excel Introduction In ...
Excel VBA Series in Hindi- • What is VBA in Excel? ...
Excel MIS Videos - • ये सीखने के बाद एक्सेल...
AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
Technology Videos - • Interview Preparation ...
Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
Tags - Use of Filter in Excel, How to use filter?, filter in excel, excel filter in hindi, Filter options in excel, Data tab filter, filter data in excel, how to filter data in excel, excel filter data

Пікірлер: 165

  • @Learn_More_Pro
    @Learn_More_Pro2 жыл бұрын

    Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Course 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/

  • @suraiyabano9316

    @suraiyabano9316

    Жыл бұрын

    Excellent bhaiya ji ap bahut acha batate

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

    Very helpful In these video i learn new think Thanku so much sir

  • @danishtechonline9696
    @danishtechonline96965 жыл бұрын

    बहुत अच्छे सर। nice video पीछे हरा पर्दा नज़र आ रहा है।😊

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    HA TODASA PROPER NAHI AA RAHA HAI BUT TRYING HARD

  • @khanhassan738
    @khanhassan7383 жыл бұрын

    very good i learn much things from this video

  • @khalidalisubhanallah2947
    @khalidalisubhanallah29475 жыл бұрын

    Very Nice Video Sir Bundle of Thanks

  • @sandipkisan9587
    @sandipkisan95873 жыл бұрын

    Thanku for the basic information 👍👍

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

    Sir, Your technique of teaching is very nice.

  • @vinodlodhi1214
    @vinodlodhi12145 жыл бұрын

    Sir aap kitna easy tarike se samjhate to thanks Sir

  • @Khurafati_balak
    @Khurafati_balak3 жыл бұрын

    Thanku sir, you are the best

  • @Mr.harshaedu
    @Mr.harshaedu3 жыл бұрын

    Thank you so much bhai 😍😘

  • @azeemplans179yt8
    @azeemplans179yt85 жыл бұрын

    very helpful and informative

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks sir for watching this video....

  • @random_short18
    @random_short183 жыл бұрын

    Tnku sirji😄😄

  • @RahulKumar-yg2kf
    @RahulKumar-yg2kf3 жыл бұрын

    Sir thanks esa muje kisine nhi sikhya Kya esay trick he vao

  • @vishal95446
    @vishal954464 жыл бұрын

    thank you sir I have an excel data in which some rows can't be filter from bottom in which some rows automatically hiden please help me

  • @jagadishmohanty4728
    @jagadishmohanty47285 жыл бұрын

    Very useful, thanks

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks bro for watching this video.....

  • @mohitpanwar1865

    @mohitpanwar1865

    2 жыл бұрын

    @@Learn_More_Pro sir how to apply when we want more than one value in text filter contains

  • @mesxyz8755
    @mesxyz87555 жыл бұрын

    Nice one Shatishbhai 👍👍👍🙏🏾🙏🏾🙏🏾

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thank u sir.....

  • @balajimaharajkabhakt1563
    @balajimaharajkabhakt15633 ай бұрын

    Very useful vidio sir😊

  • @539varshasaini4
    @539varshasaini410 ай бұрын

    👍👍

  • @peehujaiswal1468
    @peehujaiswal14683 жыл бұрын

    Waoo sir bhot mst vdo h

  • @anjaneyulukodam9961
    @anjaneyulukodam99615 жыл бұрын

    Thanks. Good morning sir,

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks a lot for watching this video.....

  • @Sadstatus1998
    @Sadstatus19983 жыл бұрын

    Supper boss

  • @dineshpalsinghrawat
    @dineshpalsinghrawat5 жыл бұрын

    Nice Sir, thoda aur details mei batayei jaise text aur numberic saath ho ya date bhi Thanks

  • @avinashnighojkar528
    @avinashnighojkar5289 ай бұрын

    Thanks.

  • @jayrajkushwaha
    @jayrajkushwaha3 жыл бұрын

    Thanks Sir very very thanks

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

    Can filter for two columns as same time

  • @PriyankaSingh-hy8gb
    @PriyankaSingh-hy8gb4 жыл бұрын

    Bahut achha sir ji

  • @puneetsharma4458
    @puneetsharma44583 жыл бұрын

    Hi, I am using office excel 2007 or 2019 or 2019 365 , I am feeding data in HINDI , while applying filter, the list is not showing in Hindi .

  • @amzadhosain472
    @amzadhosain4724 жыл бұрын

    hello sir my ne Janna sahta ke excel file ko job open karonga tob first sheet open Honda sahye agar se my close karate okt aor koi sheet me ho

  • @gunjanbabu8625
    @gunjanbabu86252 жыл бұрын

    Thank you sir

  • @vishalchandrani2962
    @vishalchandrani29625 жыл бұрын

    In excel how to unhide all the hidden columns together? ...It's opening one by one but can't open all together if any solution kindly help...

  • @s.kofficial2977
    @s.kofficial29773 жыл бұрын

    Beautiful video

  • @rampradhan4947
    @rampradhan49472 жыл бұрын

    Nice explanation sir

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

    Thanks sir

  • @SanviPatil2019
    @SanviPatil20195 жыл бұрын

    Waw amazing

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thank u sir.....

  • @mov4713
    @mov47135 жыл бұрын

    Ek dam bhadiya

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks a lot bro for watching this video.....I hope u will share with ur frnds....

  • @sujeenabanerjee6779
    @sujeenabanerjee67793 жыл бұрын

    You are asowme

  • @amansinghal3926
    @amansinghal39264 жыл бұрын

    filter k option k baad numbers ko auto plus kese kre pls infom

  • @rakeshkumarpagi873
    @rakeshkumarpagi8734 жыл бұрын

    Nice Video BHAI

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

    Satish Sir, Namaskar, Mere excel sheet me text filter k niche jo search box hai naji aa raha hai kya karun. Please guide me.

  • @udaypandit6000
    @udaypandit60003 жыл бұрын

    Thanks

  • @surindermohansharma6279
    @surindermohansharma62793 жыл бұрын

    sir your technique of explaining the basics is quite praise worthy and hope to get the other problems solved in this way. Thanks smsharma

  • @puneetvij8433
    @puneetvij84335 жыл бұрын

    Satish Sir, बहुत बड़िया, एक-एक चीज़ बताई आपने | ऐसे ही पढ़ाते रहीए | ; )

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks a lot sir for appreciating me......

  • @maonojkumarkhilarmuna3748
    @maonojkumarkhilarmuna37485 жыл бұрын

    very nice sir plz tell me how are you showing red colour arrow sign

  • @satyanarayancyclestores9129
    @satyanarayancyclestores91293 жыл бұрын

    NICE EXPLEN.....

  • @WorkVisaProcess
    @WorkVisaProcess5 жыл бұрын

    Super sir

  • @shaikhmoiz8789
    @shaikhmoiz87895 жыл бұрын

    Sir how we may give reference cell data for filter text

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    yes we can coming in next video advance filter will upload soon

  • @MrOPP-Indian
    @MrOPP-Indian4 жыл бұрын

    Very good 👍

  • @allauddinahamed7711
    @allauddinahamed77115 жыл бұрын

    Dear Mr. Satish with due respect I would like to know from from where I can get all excell tutorial video fromn starting? Please let me know

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    ON MY CHANNEL I AM UPLOADING FROM STARTING CHECK PLAYLIST BASIC EXCEL VIDEO

  • @lokeshdandwani7309

    @lokeshdandwani7309

    3 жыл бұрын

    People learn while facing the problem, so even if you watch all the videos, you won't be proficient unless you practice them, I would suggest you to practice on excel, and when you find any problem l, try to find it on KZread. Meanwhile you can also check out this video. kzread.info/dash/bejne/q4metcl_d8-zm8o.html

  • @sonelalshreyans
    @sonelalshreyans8 ай бұрын

    Very good

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

    Sir mere paas 30 excel worksheet he me usme se koi ek ward ki report filter karna chata hu kese hogi

  • @WorkVisaProcess
    @WorkVisaProcess5 жыл бұрын

    Maine ek video me comment kiya tha sir aap ko mila

  • @mohdmohsin8111
    @mohdmohsin81114 жыл бұрын

    Sir im not getting search box in filter drop down plz help

  • @nikhilshahu830
    @nikhilshahu8303 жыл бұрын

    Sir excell me koi sheet bante hai,ek hi party name bar bar repit hota hai,gstn no nhi bar bar taype krana pdta hai ,koi trik batae please,ji se gstn no automatically aa jae

  • @lokeshdandwani7309

    @lokeshdandwani7309

    3 жыл бұрын

    Will surely make a video on that please checkout my channel kzread.info/dash/bejne/q4metcl_d8-zm8o.html

  • @ashvaniupadhyay
    @ashvaniupadhyay4 ай бұрын

    Sir mujhe sales person name add krna Hai filter lga ke vo kaise hoga. Please advise me.

  • @bimalbiswas6121
    @bimalbiswas61215 жыл бұрын

    Sir..nice video

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks a lot sir for watching this video....

  • @shravanrajavath8732
    @shravanrajavath87324 жыл бұрын

    Sir I want 1-100 range in column b when column a number are 1 2, 3 like till 1000

  • @deepurajawat4161
    @deepurajawat41612 жыл бұрын

    Sir Ager sheet mai filter lagaa ho or us sheet mai vlookup se dada laana ho or fir farmule se layaa hua data value mai karna ho to kase kare

  • @arifshaikh2974
    @arifshaikh29742 жыл бұрын

    Sir jab Excel me filter karte h to Gujarati Bhasa h to Gujarati me likha hua nhi aata means k Agar " Amitabh " likha h to filter me Gujarati me Amitabh ki jaga pe usk jo English letter h vo aate h to usk liye kya karna chahiye ???

  • @manojshrivastava8375
    @manojshrivastava83752 жыл бұрын

    Nice

  • @googleatozfist2.4lakh76
    @googleatozfist2.4lakh762 жыл бұрын

    Super

  • @shrivikassaini
    @shrivikassaini5 жыл бұрын

    Please upload video on Google cloud printing

  • @SanviPatil2019

    @SanviPatil2019

    5 жыл бұрын

    My big guide channel pr abhimanyu sir ne videos upload ki hai.. google cloude print ..satish sir ke woh ache friend he woh...

  • @user-ww3ik8uq6p
    @user-ww3ik8uq6p5 жыл бұрын

    Nice 1 Sir g

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks bro for watching this video.....

  • @sunilsharma-ll8wo
    @sunilsharma-ll8wo5 жыл бұрын

    Data button ke ander manage data model ke bare me explain kari

  • @ajayverma-hn3zt
    @ajayverma-hn3zt4 ай бұрын

    Sir 83 rows mei se 15 row different name ki filter krni hai baar baar tick karke select krne mei kafi time lagta hai... Pls koi fast tarika bataye...

  • @seemamalik1729
    @seemamalik17293 жыл бұрын

    good sir

  • @purdhantudu1541
    @purdhantudu15418 ай бұрын

    Number ko filter karke top 10 ten ,bottom ten kaise hota hai , short video bana ke smjha dijiye sir

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

    Sir mere excel m filter formula nahi AA paa raha hai koi video bhi nahi mil Rahi jiski help se m filter formula install kr saku

  • @nilukumarmallick1701
    @nilukumarmallick170110 ай бұрын

    Kese smallest to largest filter removed kese karna hoga, our data jese thaa use rahega , to kese hoga sir

  • @nirmalapowdel3905
    @nirmalapowdel39052 жыл бұрын

    Nice and useful video 🙏🙏 but sr mere sath ak problem hua he me abhi computer Sikh rhi hu or abhi excel Sikh rhi hu to uspe mene marksheet vanaya he or dusre din dekhti hu to waha ka Sara formula age piche hua he jese ki total ka results me he or average ka group me he asa ho gya he to please sr muje bata dijiye na ki esko dubara kese thik kr sakte he

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp5 жыл бұрын

    Excellent

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks sirji for watching this video.....

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

    Sir filture mai Jane file Sev kiya ab wapas back nahi jara pehale file Mai to ky kare

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

    Sir jo text filter ya number filter ke niche search aa rha h vo kaise aata h sab computer Me nhi show krta h kaha se show krega

  • @sandeepmane7223
    @sandeepmane72237 ай бұрын

    Dear sir, How to above 10000 rows do the filter ?

  • @manishrawat1228
    @manishrawat12285 жыл бұрын

    Sar Mera Ek Sawal tha ki filter karne par serial number change ho jata hai To Main Chahta Hoon Ki Mai filter Karun to serial number automatic 1 se shuru ho jaye

  • @vksur5295
    @vksur52954 жыл бұрын

    Filtter data how to cut paste on athoer sheet Jb mai filter kiya hua data ko select krke cut krte hai aur dusre sheet par paste krte hai to jyda data kyu aa jata hai

  • @rajivdey738
    @rajivdey7382 жыл бұрын

    Check box ke upar search likha hua tha bo option kayse ata hain bo dikhane se achha raheta. Search box me name typing karke kayse search hota hain useke upar video banaiyaga

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

    Filter se Selected krne pr jinhe select nhi kiya h bo rows b sow ho rhi h kya solution h

  • @amitdas6499
    @amitdas64995 жыл бұрын

    Protect sheet me filter kaise kaam karega sir Koi solution batao

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    protect sheet me filter use kar sakate protect karte samay niche option raheta allow filter amit ji

  • @rnareda5
    @rnareda59 ай бұрын

    सर इसमे लास्ट row भी शो होती है जो अपने फ़िल्टर क्राईटेरिया में नही है उसको कैसे हटाये

  • @surajmishra9393
    @surajmishra93933 жыл бұрын

    Sir jab mein Excel pe Hindi language mein koi sheet banata hu to uska data filter Karne pe filter mein likhi Hui heading ke word English mein ho jate hai Jo nhi hone chaiye wo heading Hindi mein hi dekhe koi yesi video banao Jo Excel mein sheet banao to wo filter lagane pe uski heading Hindi mein hi dekhe

  • @sunilsharma-ll8wo
    @sunilsharma-ll8wo5 жыл бұрын

    Formulas button ke bare me explain kari satish G - excel

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    ok i will do it in future video

  • @prabhakarpawar573
    @prabhakarpawar5735 жыл бұрын

    Nice video sir

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks sir....

  • @amitkori4623
    @amitkori46233 жыл бұрын

    Sir, 🙏🙏🙏 Excel sheet se auto payslip banane ki trick to h. Lekin mujhe payslip se Excel sheet banana hai. Yadi esa kuch h to please bataiye. Thank you

  • @keharsingh2396
    @keharsingh23965 жыл бұрын

    Nice sir

  • @Learn_More_Pro

    @Learn_More_Pro

    5 жыл бұрын

    Thanks bro for watching this video.....

  • @ashokkankariya5886
    @ashokkankariya58865 жыл бұрын

    Pls make programe in excel like freelottery.net and american roulette

  • @SHYAMKUMAR-wx4tk
    @SHYAMKUMAR-wx4tk3 жыл бұрын

    Sorting in police station case no like 03/2017-18 ?

  • @govindbaheti9199
    @govindbaheti91993 жыл бұрын

    सर without mouse के यूज़ किये फ़िल्टर को कैसे यूज़ करेंगे प्लीज एक्सप्लेन.....

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

    5:10 min --अगर दो surname को Select करना हो तो आपने And/OR का use बताया लेकिन अगर दो से ज्यादा surname हो जैसे कि 10 या 20 तो कैसे करेंगे? क्या ऐसा कोई तरीका है जिसमें हम Surname के बीच में " , " लगाकर एक ही बार में इकट्ठा लिख दे?

  • @motilalpatel9314
    @motilalpatel93144 ай бұрын

    Sir filter me search box nhi aa raha hai kya kre

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

    Sir filtered Data main Formula ko kaise hatya 🙏

  • @rajeshroy9352
    @rajeshroy93522 жыл бұрын

    Sir wo filter cell banta kaise h

  • @tumitshriwas
    @tumitshriwas6 ай бұрын

    filter krne k bad total total sub ek sth ho jaye esa koi option

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

    Sir aap khan se ho

  • @hypernovawizard
    @hypernovawizard5 жыл бұрын

    Good Job Sir Ji👍👍👍👍 Dear Sir, Aapse ek request hai ke Due Date pe ek video banaaye, Main yeha likh raha hu plz aap usko excel pe karke bata dijiye, Shayad poore youtube pe yeh video nahi hai, Dhundte Dhunte thak gaya but nahi mili... ::::::::: Purchase Format :::::::: 1st Purchase Date: 01.08.2018 Invoice Amount: ₹5,00,000/- 2nd Purchase Date: 15.08.2018 Invoice Amount: ₹4,50,000/- 3rd Purchase Date: 25.08.2018 Invoice Amount: ₹6,50,000/- 4th Purchase Date: 20.09.2018 Invoice Amount: ₹10,00,000/- :::::::: Payment Format :::::::: 20.07.2018 ₹1,00,000/- 13.08.2018 ₹5,00,000/- 01.09.2018 ₹3,50,000/- 30.09.2018 ₹7,00,000/- 15.10.2018 ₹2,50,000/- 20.10.2018 ₹1,00,000/- No Payment to date ::Conditions::::: 2% Monthly and Due Days 8 :::::::: ::::::Please solve this matter::::::::🙏

  • @VireshDivyaVlogs
    @VireshDivyaVlogs2 жыл бұрын

    Hello sir keise ek filter use kar rahe hai all a raha ha

  • @kartiikshah
    @kartiikshah4 жыл бұрын

    Sir filter me zitna name aa rha hai usko row me kaise dale

  • @tumitshriwas
    @tumitshriwas5 ай бұрын

    filter usi k bgl m krna ho to copy pura

  • @ACHALJAIN-ym1go
    @ACHALJAIN-ym1go3 ай бұрын

    Subject ko filter kaise karein

  • @NandkisorBrahmbhatt
    @NandkisorBrahmbhatt8 ай бұрын

    Ye filter me search ka jo option aa raha vo kese laye

  • @RajeshKumar-cy2gx
    @RajeshKumar-cy2gx5 жыл бұрын

    Hello Sir Filter मे 50 नाम है, और इसमें से filter के द्वारा 20 नाम ही लेते है, पर सभी 50 नाम पेस्ट हो जाते है ऐसा क्यों, plz solution...

Келесі