Bahot acche se bataye sir aapne aapke liye mai kahunga Jodi no. 1 Aapne jo trick bataye usse mujko mumbai aur pune 2 city filter karna hai to kaise karenge
Will it work in any other place other than below the data? It is useless if I have long data. I will scroll down then I will write condition and then filter. Is the condition cell may be any cell?
*Sir aapne "Turn auto save on off wala button kaise add kara customize quick access toolbar mai... meri list mai to search karne pe bhi nhi aa raha auto save wala button. m using ms office 2024 version.*
Sir aagar meri ek se jyada condition hai toh kaise use karenge auto filter jaise mujhe A word se city Mumbai aur jisne ac purchase Kiya hai uska data chahiye toh kaise laenge kyuki yaha ek se jyada condition hai toh kaise use karenge auto filter bataiye
Good afternoon Asif sir Mujhe agar multiple criteria use karna hai using alt 5 to kaise karna chahiye For example if I select bank name and press alt 5 to.mujhe name of deposit holder and perticular bank ka total deposit amount of sum of total deposit kaise screen pay show hoga in a second after pressing alt 5 ? Can you please guide and solve this problem asap Bahut badhiya.magic ho jayega agar one short cut key se Awaiting your reply
I have a doubt in excel 2007 I written Mumbai then after click on autofilter option. This is small size data but what If I have a big size data so this autofilter was working with big size data
Jo cell may BMC bank likha tha us sell me cursor le ja k alt 5press Kiya but automatically filter nahi hota Bulke vo cell flower jaisa symbol show hota hai to kya solution hai iska? Please guide me step by step asap Thanks
आप जब Auto Filter Add कर रहे उस वक़्त Auto Filter कोनसी Position पर आ रहा है वो Check कीजिए उसके बाद Alt के साथ उस Button को Press कीजिए, एक बार आप Video को दोबारा ध्यान से देखिए आ जाएगा।
@@sonvirsingh5791 will you help me about that please ? i want to meet or contact with sir satish dhawala please if you have contact number then send me
आप जब Auto Filter Add कर रहे उस वक़्त Auto Filter कोनसी Position पर आ रहा है वो Check कीजिए उसके बाद Alt के साथ उस Button को Press कीजिए, एक बार आप Video को दोबारा ध्यान से देखिए आ जाएगा।
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
दोनो Xcel शिक्षक को आदर प्रणाम
Sir I also tried first time this short cut key and also done this 😊
Thank you sir
Aise hi new topics aap btaiye mujhe 😊
Keep watching the new videos I am uploading.
India ko upgrade karne ke liye Dil se dhanyawad 🙏🙏🙏🙏🙏🙏🙏
You are most welcome 🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳
चुम्मेश्वरी जानकारी के लिए धन्यवाद 🙏
Leant lots of things from this channel.
Solute sir
So nice of you, Keep watching the new videos I am uploading.
Vah kya khub he .... Bahut hi mast tools he...👌🏻
Kamal Ka Information hai.
Sir aap ne yea video update kare mere kaam ko tho mere liye ek interesting game banadiya.
I'm so happy
वाह सतीश सर बहुत ही खूब ❤
You have acquired soul of mr,satish , action and accent both same while teaching excel .Great 👍
So nice of you
🎉🎉 I already taken this couse.. really wonderful class, thank a lot, Today class is also interesting
I'm glad you like it
Bahot acche se bataye sir aapne aapke liye mai kahunga Jodi no. 1
Aapne jo trick bataye usse mujko mumbai aur pune 2 city filter karna hai to kaise karenge
Ab kya hi comment kru aap ki video par osm hai sir AAP ot aap ki video ❤🎉❤
Please suggest how to use auto filter technique on more than one column at same time in one go
Wah aapne bhi badhiya video banaya
Will it work in any other place other than below the data? It is useless if I have long data. I will scroll down then I will write condition and then filter. Is the condition cell may be any cell?
Sir, whether or not we have to select the data array?
Great work bro, but I learned this trick from Bill Jellen Sir from Mr. Excel
jabar jast he Auto filter sir maja a gaya
इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?
U both are awsome
Is this substitute of pivot table?
Very nice teaching
thanks sir, greate explanation with practical example
Thank You My Big Problem is solved
*Sir aapne "Turn auto save on off wala button kaise add kara customize quick access toolbar mai... meri list mai to search karne pe bhi nhi aa raha auto save wala button. m using ms office 2024 version.*
Filter huye data ko copy ya print ke liye kaise karna hai aasif ji
Your video was helpful for me
Subscribed and liked it too ❤
Thank you sir
Sir POS ke uper video banaye please 🙏
Soon you will get to see the video on the channel
Sir aagar meri ek se jyada condition hai toh kaise use karenge auto filter jaise mujhe A word se city Mumbai aur jisne ac purchase Kiya hai uska data chahiye toh kaise laenge kyuki yaha ek se jyada condition hai toh kaise use karenge auto filter bataiye
Excellent work sir
Many thanks
Superb 👍🏻 sir
Awesome 🎉🎉🎉🎉
hello sir,
I need one excell sheet for list of new admission students and printout as seprate form . is it easy to get?
Wonderful 👍
Sir aap muje yeh kahe ki agar colour wise filter karana ho to kya kare 🙏
Filter Topic पे Detail Video जल्द हे Upload होगा आप ऐसे ही हमारे Videos को देखते रहिए।
Excellent
Thank you so much 😀
सर प्रिंट टाइटल बॉटम में लगाना है बिना फूटर के
Good afternoon Asif sir
Mujhe agar multiple criteria use karna hai using alt 5 to kaise karna chahiye
For example if I select bank name and press alt 5 to.mujhe name of deposit holder and perticular bank ka total deposit amount of sum of total deposit kaise screen pay show hoga in a second after pressing alt 5 ?
Can you please guide and solve this problem asap
Bahut badhiya.magic ho jayega agar one short cut key se
Awaiting your reply
This works only on single criteria, not on multi criteria.
🎉🎉THANK YOU SIR
Excellent
exellant sir ji
Please keep watching the new videos that I am uploading.
I have a doubt in excel 2007 I written Mumbai then after click on autofilter option.
This is small size data but what If I have a big size data so this autofilter was working with big size data
Very informative
Glad you think so!
Nice guruG
Good
Nice vidio👌🏽👌🏽
Thank you
Super🎉
First Comment is mine 😁😁😁😁😁😁💕💕💕💕
From Pakistan
Me also ❤
Buhat acha
Satish I love your presentation.but now a days you are forgetting to invite us for tea.
brilliant
Where is your offline class and how to joined class
Our classes are online, not offline classes.
Great
I am ready
Excellent video and subject
Mr Satish ji do me a favour that please solve my problem as already sent to you by mail
Ready
thx sir
Jo cell may BMC bank likha tha us sell me cursor le ja k alt 5press Kiya but automatically filter nahi hota
Bulke vo cell flower jaisa symbol show hota hai to kya solution hai iska?
Please guide me step by step asap
Thanks
आप जब Auto Filter Add कर रहे उस वक़्त Auto Filter कोनसी Position पर आ रहा है वो Check कीजिए उसके बाद Alt के साथ उस Button को Press कीजिए, एक बार आप Video को दोबारा ध्यान से देखिए आ जाएगा।
Mere kes may 5th position main hai to i have press alt+5 but result is showing
Nice👍👍👍👍👍
Thank you! Cheers!
Amazing sir
Keep watching
Sir 99 course ka payment kiya hai starting kaise hoga
Nice Sir
Keep watching
ready
Hello sir,
Make a video on VBA
As soon as possible
@@Excel_Tutorialmake a free course not a paid 😅
sir satish how can i buy all course ? many times itry but not in wine please reply me i am from pakistan and my name irfan butt
A
😊😊
@@sonvirsingh5791 will you help me about that please ? i want to meet or contact with sir satish dhawala please if you have contact number then send me
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Amazing
Thank you! Cheers!
Ready.
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)
Ready sir
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)
Agar sr pure name me a na ho aise names chahiye tho kese karenge
a
Ye criteria use kr k dekhain
Us k bad *a* ye try kr k dekhain
This will be done from the AutoFilter.
sir I am from pakistan mojy ye 30 days advance course seekna ha
Bomb kiasa bana ya jata hiii ,,,. Ooo tum sikho
@@hembram7492 पाकिस्तानी आप जैसे गंदे लोगों के लिए बम बना रहे हैं और दुनिया भर के सभ्य लोगों तक ज्ञान फैला रहे हैं
Is this auto filter option in wps office
WPS mein DATA Tab mein hai.
@@Excel_Tutorial sir it is not working as you have shown in excel. It is working as simple filter in WPS
Start
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)
Alt 5 press Kiya but expected result is not working or showing
What's the solution?
आप जब Auto Filter Add कर रहे उस वक़्त Auto Filter कोनसी Position पर आ रहा है वो Check कीजिए उसके बाद Alt के साथ उस Button को Press कीजिए, एक बार आप Video को दोबारा ध्यान से देखिए आ जाएगा।
best
Hmara nhi aaya mera 4 position pr tha still mene same process kiya pr nhi aaya
Same
You should press Alt+4
Use office 365
Do it again it is working
*s is not working. What to do next
It will work once you watch the video carefully.
Sir,
Dresses have been interchanged.
रेडी
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)
Excel Mastery: Analyzing Text Lengths with Powerful Functions
th-cam.com/video/gbfMMjHNGKE/w-d-xo.html
sir auto filter not working
You will have to watch the video carefully.
Ready😅
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)
REDY
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)
Reddy
Kam bold kar teach karo
Not working
You will have to watch the video carefully.
Is Asif Sir Muslim ?
Doesn't work
Watch the video carefully and then practice once, it will be done.
@@Excel_Tutorial
My team watched this video but it was not properly working
इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?
thanks sir
Most welcome
Where is your offline class and how to joined class
There are no offline classes.
Ready
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)
ready
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)
Where is your offline class and how to joined class
There are no offline classes.
Where is your offline class and how to joined class
There are no offline classes.
Ready
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)
Ready
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)