How to use Filter in excel in proper way | Filter formula | Auto Filter |Advanced Filter
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- 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_c...
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/le...
Check our latest blogs: learnmoreindia...
---------------------------------------------------------------------------------------------------------------------------
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 TH-cam 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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
✅ Watch on Desktop : skillcourse.in/
Thank you sir
मैं आपका हर video dekhta hun
आपका teaching बोहोत अछा हैं।
आपके जैसा teaching TH-cam मैं मैने और nehi पाया।
भगवान आपको लम्बी उम्र दें
ताकि हम सबको और ज्ञान प्राप्ति हो आपसे।
आप जब समझाते हैं तो सीधा mind main save होता हैं।
मैं आपका paid member hun sir
आपसे मुझको बोहोत ज्ञान प्राप्ति हूई सर
Thank you so much sir
yes, truly, your videos are for beginners to advanced as you say.
अति उत्तम सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Thnkiu ❤️❤️❤️ sir ap ki video se bhot kuch sikhne ko mila 😘😘
Excellent زبردست from Pakistan
Very nicely explained especially the auto filter which was not aware to me. In advance filter extacting unique records for any field also available.
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.
Fantastic. Very informative. God bless you.
I don't have any doubts about filters after watching this video
Thank you! Cheers! 🥳
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
Noted
Thank you sir aapki video se bhot kuch sikhne ko mila ❤❤❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)
shukria sir aapny mujhy zero to expert bana diya shukria sir
Thank you share with your friends.
@@Excel_Tutorial sir no tension me to kisi ka mobile uthata hun to aapka channel sab ke sab channel subscribe kar deta hun haaha 😃😂😂😂
@@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
Superb class about❣️❣️❣️Filter
Thanks for advance filter sir ... your all videos are veryyy helpful.
Thanks and welcome
ऐसा ही वीडियो खोज रहा था सर जी।
Super sir......I want you make more videos
Satish sir aap mujhe basic excel, advance excel and mis ka link provided kre apne. Channel Playlist me nhi mil rha Hai chapter vise
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 ?
Hello sir Excel me ek column me text h or number bhi type h to dono ko seperatly filter kaise karenge
Bahut badhiya dost. Thanks
Keep watching the new videos I am uploading.
Good evening from Doha
Sir how can use filter farmula to see records from 1 sheet to other sheet through the criteria ?
Thank you
Sir very useful tutorial. Made another advance course.
Very Usefull, Thanks
Wow
Nice and most awaited for me
Thanks
Most welcome 😊
Superb.. Sir, Please make a video where we can apply filter with multiple colors.
Mujhe bhi janana hai, VBA me colour index se to ho jata hai, lekin bina VBA?
How can apply filter only one column? Please make video about it...
One'of the best teacher on TH-cam ❤️❤️❤️
Totally agree 👍
Very useful information
Sir ji isme unique record only ka use kese kre or 1 query sir dproduct fungtion ka alternative kya use kr sakte hai
Can we filter data in one column as the order of other column data
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
good way to learn !!
thanks
You are welcome!, Keep watching the new videos I am uploading.
I thought you would show how to remove the filter function after finishing the required editing .
Autofilter is excellent, thanks
Keep watching
plz make a vdeo on data hygine
Excellent.
Thnk u
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
Sir ji ek video aggregate Function ke user bhi banao Dynamic abhi bhi bahut daut hai aggregate Function me
Tussi grate ho sahab
Wah sir ji thanks sir ji
Best explanation ❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)
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
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?
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
Good
Sir aapki offline classes kha hai location...
Excellent 🙏
Please share the link of file from where I can download easily
Sir agar agar beech beech me blank called bhi hai to filter Kaise lagaye
sir Please provide practice sheet & i also buy your course and downloaded app.
Very knowledgeable video sir. Sheet menu k option ki detail main batain. Thanks
Very nice 👍👍👍👍👍👍👍👍👍👍 video
Jay shree
Sir kya ms office or libre office ki all rules,short cuts same hai?
Please reply
Excellent 👌
Sir plzz plzz plzz govt school clerk k tamaaam kaam word excel main jo hote hain plzzz tutorial bara sa bana dain plzzzz
Sir multiple text he hme sirf ek common bs uthana h bo kese uthay
Nice video sir gi
Nice Satish sir
In Bank statement how filter out interest, dividend, salary etc
Any course for chat gpt AI excel
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
Superb video
Thank you so much 😀
Sir aap ki ofline class chal rhi h kya
🙌
Sir filter formula do sa Jada conditions pr work nhi kar raha ha
Please reply
Great 👍🏻
Good evening sir
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
"Freeze" option select karna hai
ऐसा ही वीडियो खोज रहा था सर जी।
Super video
Auto filter part is good 👍
❤❤❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)
If I want to filter above 10 & below -10 than how to do it
Waaaao ☺️☺️☺️☺️
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
Wild character use in filter?
Amazing
Sir filter mai search colom nahi mil raha hai
सर मेरे कंप्यूटर में फील्डर का साइज छोटा हो गया है जो फिल्टर बॉक्स खुलता है वह छोटा साइज है दम छोटा हो गया मऊ से खींचने पर बड़ा हो जाता है लेकिन उसके बाद दोबारा फिर खोलने पर फिर छोटा ही खुलता है इसको कैसे बड़ा करे
Nice
👌👌👌
Hi sir, good morning, how to download the practice file
शानदार
Sir excel sheet par male and female ko alag alag kaise kare,
Pyar ke dushman
@@ExcelBaba 😄😄 nhi bhai
How to download excel practice file?
Same problem
Excel ko auto update web link kaise banaye
👏
Advance filter m transpose kase kre
Nice video sir
Sir pls CCC ka videos bnye
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
Sir excel ka complete all tab ka vedio chahey
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
मेरे लैपटॉपमे नंबर फ़िल्टर नहिंदीखता है
Prctice file nahi mil rahaha
Practice sheet to di nhi keval bol dte ho
Excel microsoft office qr code create in
unable to get practice file Satish sir in the telegram
t.me/learnmoreindia/655
Thanks a lot Sir
Sir please ccc ka chapter wise tutorial dijiye🥺🥺
prcatice FILE PLEASE