Тёмный

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

Excel Tutorial
Подписаться 283 тыс.
Просмотров 97 тыс.
50% 1

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 RU-vid 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

Опубликовано:

 

15 сен 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 128   
@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 RU-vid मैं मैने और nehi पाया। भगवान आपको लम्बी उम्र दें ताकि हम सबको और ज्ञान प्राप्ति हो आपसे। आप जब समझाते हैं तो सीधा mind main save होता हैं। मैं आपका paid member hun sir आपसे मुझको बोहोत ज्ञान प्राप्ति हूई सर Thank you so much sir
@AzeemKhan-jw6mh
@AzeemKhan-jw6mh Год назад
Fantastic. Very informative. God bless you.
@muhammadsadiq8885
@muhammadsadiq8885 4 месяца назад
yes, truly, your videos are for beginners to advanced as you say.
@user-gp6pt5ry8x
@user-gp6pt5ry8x 6 месяцев назад
Very nicely explained especially the auto filter which was not aware to me. In advance filter extacting unique records for any field also available.
@mohammadilyas2260
@mohammadilyas2260 Год назад
Excellent زبردست from Pakistan
@zoyamalik1456
@zoyamalik1456 Год назад
Thnkiu ❤️❤️❤️ sir ap ki video se bhot kuch sikhne ko mila 😘😘
@mofajjalhossain7334
@mofajjalhossain7334 Год назад
Superb class about❣️❣️❣️Filter
@iamsawairah1308
@iamsawairah1308 Месяц назад
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 Месяц назад
Noted
@knowledgeandlearning1293
@knowledgeandlearning1293 15 дней назад
Bahut badhiya dost. Thanks
@Excel_Tutorial
@Excel_Tutorial 14 дней назад
Keep watching the new videos I am uploading.
@satishagrwal4912
@satishagrwal4912 Год назад
Very useful information
@shirishvaidya161
@shirishvaidya161 9 месяцев назад
Very Usefull, Thanks
@arvindnegi5978
@arvindnegi5978 10 месяцев назад
Great 👍🏻
@arunkumarsinghark3024
@arunkumarsinghark3024 Год назад
अति उत्तम सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@rsdhanda38
@rsdhanda38 Год назад
Excellent 👌
@akshaymishrashastri
@akshaymishrashastri Год назад
Wow Nice and most awaited for me Thanks
@Excel_Tutorial
@Excel_Tutorial Год назад
Most welcome 😊
@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.
@rekharawat5463
@rekharawat5463 Год назад
Super sir......I want you make more videos
@somrajbanerjee3500
@somrajbanerjee3500 10 месяцев назад
Excellent 🙏
@abhishekkesarwani554
@abhishekkesarwani554 Год назад
Excellent. Thnk u
@Shubh9898
@Shubh9898 Год назад
Thanks for advance filter sir ... your all videos are veryyy helpful.
@Excel_Tutorial
@Excel_Tutorial Год назад
Thanks and welcome
@universetv7985
@universetv7985 Год назад
ऐसा ही वीडियो खोज रहा था सर जी।
@Kashish_k_
@Kashish_k_ 5 месяцев назад
Thank you sir aapki video se bhot kuch sikhne ko mila ❤❤❤
@Excel_Tutorial
@Excel_Tutorial 5 дней назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@aashishsahu2563
@aashishsahu2563 Год назад
Nice video sir gi
@darshitchavda8264
@darshitchavda8264 Год назад
Amazing
@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?
@bhavikaparmar3699
@bhavikaparmar3699 4 месяца назад
👌👌👌
@s.screation2277
@s.screation2277 Год назад
Nice Satish sir
@vijayprajapati8883
@vijayprajapati8883 Год назад
Tussi grate ho sahab
@ExcelBaba
@ExcelBaba Год назад
Super video
@jamadaralam
@jamadaralam Год назад
Auto filter part is good 👍
@nidhi4774
@nidhi4774 8 месяцев назад
👏
@pinkiharshitphatak2934
@pinkiharshitphatak2934 Год назад
Superb video
@Excel_Tutorial
@Excel_Tutorial Год назад
Thank you so much 😀
@amritathakur2036
@amritathakur2036 Год назад
Wah sir ji thanks sir ji
@gitadevi697
@gitadevi697 Год назад
Waaaao ☺️☺️☺️☺️
@maheshsanghani6380
@maheshsanghani6380 5 месяцев назад
good way to learn !! thanks
@Excel_Tutorial
@Excel_Tutorial 14 дней назад
You are welcome!, Keep watching the new videos I am uploading.
@ahkreactions
@ahkreactions 3 месяца назад
🙌
@mohsinfahim3598
@mohsinfahim3598 4 месяца назад
Best explanation ❤
@Excel_Tutorial
@Excel_Tutorial 7 дней назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@KanchanPatel-jq7rm
@KanchanPatel-jq7rm 7 месяцев назад
Nice
@ananditasharma1
@ananditasharma1 8 месяцев назад
Autofilter is excellent, thanks
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Keep watching
@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
@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
@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
@ashutoshsingh598
@ashutoshsingh598 Год назад
Very nice 👍👍👍👍👍👍👍👍👍👍 video Jay shree
@user-vk3zl3vw7p
@user-vk3zl3vw7p 8 месяцев назад
sir Please provide practice sheet & i also buy your course and downloaded app.
@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
@butanianand7378
@butanianand7378 2 месяца назад
How can apply filter only one column? Please make video about it...
@user-sr3ek4rv6j
@user-sr3ek4rv6j 6 месяцев назад
❤❤❤
@Excel_Tutorial
@Excel_Tutorial 7 дней назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@kanchankumarimishra3738
@kanchankumarimishra3738 3 месяца назад
plz make a vdeo on data hygine
@nadeempathan8909
@nadeempathan8909 Год назад
Good evening sir
@d0minic46
@d0minic46 Год назад
Sir kya ms office or libre office ki all rules,short cuts same hai? Please reply
@vijaybhadrike7962
@vijaybhadrike7962 Год назад
One'of the best teacher on RU-vid ❤️❤️❤️
@ExcelBaba
@ExcelBaba Год назад
Totally agree 👍
@ypainkra
@ypainkra 8 дней назад
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
@jyothisram229
@jyothisram229 3 месяца назад
Can we filter data in one column as the order of other column data
@DEADYBOYS
@DEADYBOYS Год назад
Sir ji ek video aggregate Function ke user bhi banao Dynamic abhi bhi bahut daut hai aggregate Function me
@updalvi
@updalvi 2 месяца назад
I thought you would show how to remove the filter function after finishing the required editing .
@universetv7985
@universetv7985 Год назад
ऐसा ही वीडियो खोज रहा था सर जी।
@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 ?
@mohsinfahim3598
@mohsinfahim3598 4 месяца назад
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?
@vishalvighne3747
@vishalvighne3747 Год назад
Sir aapki offline classes kha hai location...
@shivnama007
@shivnama007 2 месяца назад
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
@tallyeducationplatform1435
@tallyeducationplatform1435 Год назад
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
@anuragshrivstava212
@anuragshrivstava212 Месяц назад
Sir multiple text he hme sirf ek common bs uthana h bo kese uthay
@ynagesh839
@ynagesh839 Год назад
Hi sir, good morning, how to download the practice file
@digitalpranav1824
@digitalpranav1824 2 месяца назад
plz give this Filters Practice File Link here!!! i can't find in the description
@shilpimaheshwari2144
@shilpimaheshwari2144 6 месяцев назад
Any course for chat gpt AI excel
@siyadoll
@siyadoll 11 месяцев назад
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
@sonaligupta7401
@sonaligupta7401 4 месяца назад
Sir agar agar beech beech me blank called bhi hai to filter Kaise lagaye
@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
@PraveenKumar-hn2xt
@PraveenKumar-hn2xt 10 месяцев назад
In Bank statement how filter out interest, dividend, salary etc
@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
@prashantgupta1494
@prashantgupta1494 Месяц назад
If I want to filter above 10 & below -10 than how to do it
@parsoyasanju372
@parsoyasanju372 Год назад
Sir aap ki ofline class chal rhi h kya
@mohansingh2872
@mohansingh2872 Год назад
Sir filter formula do sa Jada conditions pr work nhi kar raha ha Please reply
@atulmittalco1969
@atulmittalco1969 Год назад
Wild character use in filter?
@PAWANKUMARSWAMI
@PAWANKUMARSWAMI Год назад
शानदार
@khalidalisubhanallah2947
@khalidalisubhanallah2947 Год назад
Very knowledgeable video sir. Sheet menu k option ki detail main batain. Thanks
@seemapanchal1693
@seemapanchal1693 Год назад
Advance filter m transpose kase kre
@aakashs3099
@aakashs3099 Год назад
How to download excel practice file?
@amritathakur2036
@amritathakur2036 Год назад
Same problem
@searchknowledge6368
@searchknowledge6368 Год назад
Excel ko auto update web link kaise banaye
@KanhaiyaKumar-rg8xb
@KanhaiyaKumar-rg8xb Год назад
Nice video sir
@anilkumarparmar1784
@anilkumarparmar1784 Год назад
Vlookup formula में टेबल अरे ना पकड़ने का कारण क्या हो सकता है?
@gamehub8068
@gamehub8068 Год назад
सर मेरे कंप्यूटर में फील्डर का साइज छोटा हो गया है जो फिल्टर बॉक्स खुलता है वह छोटा साइज है दम छोटा हो गया मऊ से खींचने पर बड़ा हो जाता है लेकिन उसके बाद दोबारा फिर खोलने पर फिर छोटा ही खुलता है इसको कैसे बड़ा करे
@Sanandiya_family
@Sanandiya_family Год назад
Excel microsoft office qr code create in
@abhisharma8461
@abhisharma8461 Год назад
Sir excel sheet par male and female ko alag alag kaise kare,
@ExcelBaba
@ExcelBaba Год назад
Pyar ke dushman
@abhisharma8461
@abhisharma8461 Год назад
@@ExcelBaba 😄😄 nhi bhai
@ShaibulHoqueMozumder
@ShaibulHoqueMozumder Год назад
prcatice FILE PLEASE
@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
@AnamikaRaghuvanshiunique
@AnamikaRaghuvanshiunique Год назад
Sir pls CCC ka videos bnye
@masroorahmed3462
@masroorahmed3462 Год назад
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
@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
@hornetsubhendu8380
@hornetsubhendu8380 Месяц назад
Prctice file nahi mil rahaha
@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
@LamiyaAnsari001
@LamiyaAnsari001 Год назад
Sir please ccc ka chapter wise tutorial dijiye🥺🥺
@roshannayak3760
@roshannayak3760 2 месяца назад
मेरे लैपटॉपमे नंबर फ़िल्टर नहिंदीखता है
@asadjaved4721
@asadjaved4721 Год назад
Sir excel ka complete all tab ka vedio chahey
@abhishekk545
@abhishekk545 Год назад
🙏🙏🙏🙏🙏👌👌👌👌🇮🇳🇮🇳🇮🇳✍️✍️
@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
@bhimraopatil5169
@bhimraopatil5169 8 месяцев назад
एक सेल मे एक से ज्यादा नाम विखे है. कुछ सेल मे एकही नाम लिखा है. दो हजार सेल है. मराठी भाषा में नाम लिखा है. तो अ से ज्ञ तक नाम साँर्ट करने है कैसै करे. ईसबआरएमए पहिले व्हिडीओ बना है क्या
@masroorahmed3462
@masroorahmed3462 Год назад
kesy lagi shortcut keys reply zaroor dena sir 🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰
@haryanviRagniVideoBypwn
@haryanviRagniVideoBypwn Год назад
Mere pas excel ka database file hai . जिसमें 5 लाख से ज्यादा डाटा रहता है। जब मैं फ़िल्टर लगाता हं तो फिल्टर म not showing all values. Warning dikhata hai. ओर सारी filter values नही दिखता।
Далее
BABYMONSTER - ‘FOREVER’ M/V
03:54
Просмотров 10 млн
Don't use pivot table hence forth, but why?
18:29
Просмотров 10 тыс.
MS Excel - Advanced Filters
7:41
Просмотров 1,4 млн