One keyboard shortcut will make you smart🤓in Microsoft Excel
Вставка
- Опубліковано 18 кві 2024
- One keyboard shortcut will make you smart🤓in Microsoft Excel
In this video you will learn how to use auto filter option to get instant Result . So watch video till the end & share with your office friends.
Join 30-Days Excel Crash Course : courses.skillcourse.in/ecc-og/
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
#autofilter
#exceltricks
#exceltips
------------------------------------------------------------------------------------------------------------------------------
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/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
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_pro
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My UA-cam 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
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Vah kya khub he .... Bahut hi mast tools he...👌🏻
thanks sir, greate explanation with practical example
वाह सतीश सर बहुत ही खूब ❤
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
Very nice teaching
Your video was helpful for me
Wah aapne bhi badhiya video banaya
Excellent
Thank you
Awesome 🎉🎉🎉🎉
Wonderful 👍
🎉🎉THANK YOU SIR
Thank you sir
jabar jast he Auto filter sir maja a gaya
U both are awsome
brilliant
Superb 👍🏻 sir
You have acquired soul of mr,satish , action and accent both same while teaching excel .Great 👍
So nice of you
Super🎉
चुम्मेश्वरी जानकारी के लिए धन्यवाद 🙏
Great
Nice vidio👌🏽👌🏽
🎉🎉 I already taken this couse.. really wonderful class, thank a lot, Today class is also interesting
I'm glad you like it
thx sir
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.
दोनो Xcel शिक्षक को आदर प्रणाम
I am ready
Ab kya hi comment kru aap ki video par osm hai sir AAP ot aap ki video ❤🎉❤
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
Thank You My Big Problem is solved
Good
Leant lots of things from this channel.
Solute sir
So nice of you, Keep watching the new videos I am uploading.
Subscribed and liked it too ❤
Nice guruG
Very informative
Glad you think so!
Ready
Buhat acha
thanks sir
Most welcome
Please suggest how to use auto filter technique on more than one column at same time in one go
Excellent work sir
Many thanks
ready
exellant sir ji
Please keep watching the new videos that I am uploading.
Great work bro, but I learned this trick from Bill Jellen Sir from Mr. Excel
Amazing sir
Keep watching
Amazing
Thank you! Cheers!
Ready.
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Is this substitute of pivot table?
Sir, whether or not we have to select the data array?
Nice👍👍👍👍👍
Thank you! Cheers!
Satish I love your presentation.but now a days you are forgetting to invite us for tea.
Ready sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Nice Sir
Keep watching
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?
Filter huye data ko copy ya print ke liye kaise karna hai aasif ji
इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?
First Comment is mine 😁😁😁😁😁😁💕💕💕💕
From Pakistan
Me also ❤
hello sir,
I need one excell sheet for list of new admission students and printout as seprate form . is it easy to get?
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
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
Where is your offline class and how to joined class
सर प्रिंट टाइटल बॉटम में लगाना है बिना फूटर के
*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 POS ke uper video banaye please 🙏
Soon you will get to see the video on the channel
Excellent video and subject
Mr Satish ji do me a favour that please solve my problem as already sent to you by mail
Start
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Hello sir,
Make a video on VBA
As soon as possible
@@Excel_Tutorialmake a free course not a paid 😅
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.
Sir aap muje yeh kahe ki agar colour wise filter karana ho to kya kare 🙏
Filter Topic पे Detail Video जल्द हे Upload होगा आप ऐसे ही हमारे Videos को देखते रहिए।
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 99 course ka payment kiya hai starting kaise hoga
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
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
Ready😅
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Excel Mastery: Analyzing Text Lengths with Powerful Functions
ua-cam.com/video/gbfMMjHNGKE/v-deo.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 को दोबारा ध्यान से देखिए आ जाएगा।
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
sir I am from pakistan mojy ye 30 days advance course seekna ha
Bomb kiasa bana ya jata hiii ,,,. Ooo tum sikho
@@hembram7492 पाकिस्तानी आप जैसे गंदे लोगों के लिए बम बना रहे हैं और दुनिया भर के सभ्य लोगों तक ज्ञान फैला रहे हैं
Sir,
Dresses have been interchanged.
*s is not working. What to do next
It will work once you watch the video carefully.
REDY
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Reddy
रेडी
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
sir auto filter not working
You will have to watch the video carefully.
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
Kam bold kar teach karo
best
Not working
You will have to watch the video carefully.
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
Is Asif Sir Muslim ?
Ready
ready
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?
Where is your offline class and how to joined class
Ready
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Ready
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Ready
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Ready
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Where is your offline class and how to joined class
Where is your offline class and how to joined class
Our classes are online, not offline classes.