One keyboard shortcut will make you smart🤓in Microsoft Excel

Рет қаралды 60,799

3 ай бұрын

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 KZfaq 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

Пікірлер: 150

@Excel_Tutorial 5 күн бұрын

Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

@seliajd 2 ай бұрын

Vah kya khub he .... Bahut hi mast tools he...👌🏻

@sidrakhatun 3 ай бұрын

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

@ejazhaq1160 3 ай бұрын

वाह सतीश सर बहुत ही खूब ❤

@JavaCodingwithRaju-kv7xc 3 ай бұрын

thanks sir, greate explanation with practical example

@nityanandbhardwaj8991 3 ай бұрын

You have acquired soul of mr,satish , action and accent both same while teaching excel .Great 👍

@Excel_Tutorial 2 ай бұрын

So nice of you

@dangerdagar9427 3 ай бұрын

Wah aapne bhi badhiya video banaya

@arshadsahil88 3 ай бұрын

🎉🎉 I already taken this couse.. really wonderful class, thank a lot, Today class is also interesting

@Excel_Tutorial 2 ай бұрын

I'm glad you like it

@nikhilgorivle1152 2 ай бұрын

Your video was helpful for me

@patelbhavesh3683 3 ай бұрын

jabar jast he Auto filter sir maja a gaya

@shiprakesarwani547 Ай бұрын

Sir I also tried first time this short cut key and also done this 😊 Thank you sir Aise hi new topics aap btaiye mujhe 😊

@Excel_Tutorial Ай бұрын

Keep watching the new videos I am uploading.

@rajneeshsharma9941 2 ай бұрын

Very nice teaching

@heeralalkumawat2132 3 ай бұрын

Awesome 🎉🎉🎉🎉

@mehmoodurrehman9322 2 ай бұрын

Subscribed and liked it too ❤

@kishornawale5984 22 күн бұрын

U both are awsome

@abidullah6435 Ай бұрын

Leant lots of things from this channel. Solute sir

@Excel_Tutorial Ай бұрын

So nice of you, Keep watching the new videos I am uploading.

@shaikhms2011 3 ай бұрын

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

@kalpanashimpi9320 3 ай бұрын

Nice vidio👌🏽👌🏽

@mehmoodurrehman9322 2 ай бұрын

Wonderful 👍

@sudhirtripta 3 ай бұрын

Excellent

@Jayant0780 2 ай бұрын

Superb 👍🏻 sir

@shamshernawaz7712 3 ай бұрын

🎉🎉THANK YOU SIR

@hemant.rayakwar46 2 ай бұрын

चुम्मेश्वरी जानकारी के लिए धन्यवाद 🙏

@Haris-ub9rz 2 ай бұрын

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?

@PANCHADHATUNEPALMS 3 ай бұрын

Thank you

@atherather7825 2 ай бұрын

Great

@gandhisunil3 2 ай бұрын

Please suggest how to use auto filter technique on more than one column at same time in one go

@h.k.sarsoniya3085 3 ай бұрын

Ab kya hi comment kru aap ki video par osm hai sir AAP ot aap ki video ❤🎉❤

@paplu2729 3 ай бұрын

superb

@bhimmu-uj6lb 2 ай бұрын

brilliant

@SONUKUMAR-rg3bm 2 ай бұрын

Nice guruG

@Anurag-1904 Ай бұрын

Is this substitute of pivot table?

@bijaytanty8434 2 ай бұрын

Good

@user-fp1yh8wd1t Ай бұрын

exellant sir ji

@Excel_Tutorial Ай бұрын

Please keep watching the new videos that I am uploading.

@kaushikkumarvora658 2 ай бұрын

Super🎉

@nirdoshturkar4988 2 ай бұрын

Excellent work sir

@Excel_Tutorial 2 ай бұрын

Many thanks

@amerendrakumarranjan336 2 ай бұрын

Very informative

@Excel_Tutorial 2 ай бұрын

Glad you think so!

@syedasif1101 2 ай бұрын

Sir, whether or not we have to select the data array?

@rustamqadri54 2 ай бұрын

Buhat acha

@rakeshsharma-pn8pn 2 ай бұрын

thanks sir

@Excel_Tutorial 2 ай бұрын

Most welcome

@nikhilgorivle1152 2 ай бұрын

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

@sunilkumarverma4268 2 ай бұрын

thx sir

@pandasnj 2 ай бұрын

Thank You My Big Problem is solved

@umeshray3463 3 ай бұрын

I am ready

@saokhilalkachhi3842 3 ай бұрын

Amazing sir

@Excel_Tutorial 2 ай бұрын

Keep watching

@Azhar_Khan383 2 ай бұрын

Great work bro, but I learned this trick from Bill Jellen Sir from Mr. Excel

@maqsoodahmednagouri3026 3 ай бұрын

hello sir, I need one excell sheet for list of new admission students and printout as seprate form . is it easy to get?

@pratapkeshavpawar9689 Ай бұрын

दोनो Xcel शिक्षक को आदर प्रणाम

@kaifshafique 3 ай бұрын

Amazing

@Excel_Tutorial 2 ай бұрын

Thank you! Cheers!

@sudipacharya133 3 ай бұрын

Ready

@mukeshgamerz7685 2 ай бұрын

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

@dangerdagar9427 3 ай бұрын

Filter huye data ko copy ya print ke liye kaise karna hai aasif ji

@sagarshinde3342 3 ай бұрын

इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?

@nimaydey6466 2 ай бұрын

ready

@atul2047 Ай бұрын

*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.*

@jitendra0150 3 ай бұрын

Nice👍👍👍👍👍

@Excel_Tutorial 2 ай бұрын

Thank you! Cheers!

@nirmlarani7517 2 ай бұрын

Ready.

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@Geography87823 3 ай бұрын

Nice Sir

@Excel_Tutorial 2 ай бұрын

Keep watching

@umeshchandrasankhua6069 2 ай бұрын

Ready sir

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@bidyabhusansunani5972 2 ай бұрын

Sir POS ke uper video banaye please 🙏

@Excel_Tutorial 2 ай бұрын

Soon you will get to see the video on the channel

@lalitsarmah 2 ай бұрын

Satish I love your presentation.but now a days you are forgetting to invite us for tea.

@fragrenceful 3 ай бұрын

Excellent video and subject Mr Satish ji do me a favour that please solve my problem as already sent to you by mail

@AbdulRahman-yp6oy 3 ай бұрын

First Comment is mine 😁😁😁😁😁😁💕💕💕💕 From Pakistan

@shayankhan4103 3 ай бұрын

Me also ❤

@user-jj4mj9oh8n 3 ай бұрын

Where is your offline class and how to joined class

@fragrenceful 2 ай бұрын

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

@Excel_Tutorial Ай бұрын

This works only on single criteria, not on multi criteria.

@lalvanimukesh1211 2 ай бұрын

Sir aap muje yeh kahe ki agar colour wise filter karana ho to kya kare 🙏

@Excel_Tutorial 2 ай бұрын

Filter Topic पे Detail Video जल्द हे Upload होगा आप ऐसे ही हमारे Videos को देखते रहिए।

@pradeepkumarahirwar6619 3 ай бұрын

सर प्रिंट टाइटल बॉटम में लगाना है बिना फूटर के

@syedshuaib3577 3 ай бұрын

Hello sir, Make a video on VBA

@Excel_Tutorial 2 ай бұрын

As soon as possible

@syedshuaib3577 2 ай бұрын

@@Excel_Tutorialmake a free course not a paid 😅

@fragrenceful 2 ай бұрын

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

@Excel_Tutorial 2 ай бұрын

आप जब Auto Filter Add कर रहे उस वक़्त Auto Filter कोनसी Position पर आ रहा है वो Check कीजिए उसके बाद Alt के साथ उस Button को Press कीजिए, एक बार आप Video को दोबारा ध्यान से देखिए आ जाएगा।

@fragrenceful 2 ай бұрын

Mere kes may 5th position main hai to i have press alt+5 but result is showing

@user-xs5fb6nx2m 2 ай бұрын

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

@sonvirsingh5791 2 ай бұрын

A 😊😊

@user-xs5fb6nx2m 2 ай бұрын

@@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

@mohitrajput5069 Ай бұрын

Agar sr pure name me a na ho aise names chahiye tho kese karenge

@pbcpms4365 Ай бұрын

a Ye criteria use kr k dekhain Us k bad *a* ye try kr k dekhain

@Excel_Tutorial Ай бұрын

This will be done from the AutoFilter.

@santoshguptagupta9330 3 ай бұрын

Start

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@ImranKhan-il9me 3 ай бұрын

Is this auto filter option in wps office

@Excel_Tutorial 2 ай бұрын

WPS mein DATA Tab mein hai.

@ImranKhan-il9me 2 ай бұрын

@@Excel_Tutorial sir it is not working as you have shown in excel. It is working as simple filter in WPS

@NaibBtc-cx4ow 3 ай бұрын

Ready😅

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@fragrenceful 2 ай бұрын

Alt 5 press Kiya but expected result is not working or showing What's the solution?

@Excel_Tutorial 2 ай бұрын

@swapnilpachpande1176 3 ай бұрын

Sir 99 course ka payment kiya hai starting kaise hoga

@brcvaso7387 2 ай бұрын

REDY

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@chaudharyawais2306 3 ай бұрын

sir I am from pakistan mojy ye 30 days advance course seekna ha

@hembram7492 3 ай бұрын

Bomb kiasa bana ya jata hiii ,,,. Ooo tum sikho

@nadiaamin6189 3 ай бұрын

@@hembram7492 पाकिस्तानी आप जैसे गंदे लोगों के लिए बम बना रहे हैं और दुनिया भर के सभ्य लोगों तक ज्ञान फैला रहे हैं

@amareshkumarsharma3536 2 ай бұрын

रेडी

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@khuranagee Ай бұрын

*s is not working. What to do next

@Excel_Tutorial Ай бұрын

It will work once you watch the video carefully.

@mithleshmukhiya8574 3 ай бұрын

Reddy

@mehmoodurrehman9322 2 ай бұрын

Sir, Dresses have been interchanged.

@Nature-Travel 2 ай бұрын

Excel Mastery: Analyzing Text Lengths with Powerful Functions kzfaq.info/get/bejne/nciWgLCbrbSre3k.html

@mohinigupta2307 3 ай бұрын

Hmara nhi aaya mera 4 position pr tha still mene same process kiya pr nhi aaya

@shamshernawaz7712 3 ай бұрын

Same

@yashverdhandubey3483 3 ай бұрын

You should press Alt+4

@SWARNAVACREATIONS07 2 ай бұрын

Use office 365

@gillyk3466 2 ай бұрын

Do it again it is working

@alhamtech 2 ай бұрын

sir auto filter not working

@Excel_Tutorial 2 ай бұрын

You will have to watch the video carefully.

@maheshkarle-ut6ol 3 ай бұрын

best

@himanshusharma-te5oe 2 ай бұрын

Kam bold kar teach karo

@gurisidhu6813 2 ай бұрын

Not working

@Excel_Tutorial 2 ай бұрын

You will have to watch the video carefully.

@vinayaksharma4131 2 ай бұрын

Doesn't work

@Excel_Tutorial 2 ай бұрын

Watch the video carefully and then practice once, it will be done.

@vinayaksharma4131 2 ай бұрын

@@Excel_Tutorial My team watched this video but it was not properly working

@AbdulRahman-yp6oy 3 ай бұрын

Is Asif Sir Muslim ?

@sagarshinde3342 3 ай бұрын

इस methad से दो date के बीच का deta फिल्टर कर सकते हैं क्या?

@Exceltry 3 ай бұрын

Ready

@deepakakela3584 3 ай бұрын

ready

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@user-jj4mj9oh8n 3 ай бұрын

Where is your offline class and how to joined class

@abhimanyuSingh-tp7hx 3 ай бұрын

Ready

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@bittusingh-vl1lw 3 ай бұрын

Ready

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@nasermohammadshaikh5759 2 ай бұрын

Ready

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@rameezjod3176 2 ай бұрын

Ready

@Excel_Tutorial Ай бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@user-jj4mj9oh8n 3 ай бұрын

Where is your offline class and how to joined class

@user-jj4mj9oh8n 3 ай бұрын

Where is your offline class and how to joined class

@Excel_Tutorial 2 ай бұрын

Our classes are online, not offline classes.