99% Excel users are not using this trick of Excel Advance Filter (हिंदी)
HTML-код
- Опубликовано: 19 авг 2024
- इस वीडियो में एक्सेल के बड़े मियाँ याने Excel Advance Filter का एक और Logic, So excel Advance filter bahot in kam ki Chij hai hai waise Advance filter in Excel hindi me maine pehle bhi video banaya ...par is video ke pehele jo banaya usme ye wala adance filter logic nahi explain kiya tha, so isiliye to iska title hai ..99% Excel users are not using this trick of Excel Advance Filter
#Excel
#ExcelTutorial
#AdvanceFilter
Topic you will learn in this video of Advanced Filter
1 ) Use Advanced filter and Get result according to Criteria
2) Use VBA Code for filter and result of data as soon you type word
Here is Excel file and Code link for Practice :
learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
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 RUclips 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
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/
Bahut acha Pahate ho
Nice teaching👌👌👌👌👌👌👌👌👌👌👌👌
Learning and typing practice is a best part fir all of users.
Sir you are a genius of computer technical of pc masters.
Satish sir aapke samjhane ka tarika bahut accha hai
Very nice way of teaching 😊😊
I already following you in Facebook also. You are a great teacher and I love your teaching style. Thank You Respected Sir 🙏.
Bahut hi achha samjate he app thank you sir ji
Sir,
Maine apki ek video dekhi hai.
Jiska title hai "99_Excel user are not using this trick of Excel Advance Filter"
Jisme apne Bade Miyan Aur Chote Miyan ki misal bhi di hai.
Video bahot achchha laga,
Yakeen maniya mujhe kuch seekhne mila.
Iske liye apka bahot shukr guzar hoo.
Sir ek problem hai is advance filter (Bade Miyan) me,
Maine saare Stores ki quantity ka total kiya 3462 aya.
Aur jab advance filter se sirf Dadar search karta hoo to bhi 3462 hi ata hai.
Sir ek request hai aise kuch VBA codes bataye ke jis se advance filter me jo Store name type kare usi ka hi total bataye.
First of all a lot of best wishes to the new born baby.As always this video is also the best.
Sach a great teacher nd
Amazing explaintion
Sir u are really Awsome
Thanks Satish
Sir 🙏🙏
hamko Free me Padhane ke liye🙏🙏
Vase kon etana time west karke hamko padhyega .apke es kam ko meri tarpse salute🙋🙋👍?🙏🙏👏👏?❤❤❤❤❤❤👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Waoooooooo sir. Very useful video.
Kataiii Jahar H Sir Yee Chotee Miya Or Badeeee Miya
Excellent sir
Wow, maza agya.thanks..agar Heading name fix na hokar,dynamic ho tab kya change hoga code me, please bataiye..
Thanks sir Best teacher 👍
सर जी आप से मेरा निवेदन है कि आप एक video FULL ADVANCE EXCEL पर बनाए तो 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙋🙋🙋
इस कोड का उपयोग google sheets पर भी करके बताएं.🙏
Nice Video Sir Keep It Up Well Done 👍👍👍
very informative
Great sir
Very Nice Sir Ji
Useful video sir
Excellent
Sir...excel ki madat se stock market ka option chain data kaise analyse kar sakte hai....jaise ki kounsa strike price me highest open interest hai....etc etc....is par video banaiye....macro aur v look up ki madat se....i am new to this channel....and learning alot from ur channel....thank u so much sir.
Nice way to explain !!!
Good explanation
Google sheets के लिए भी वीडियो बनाएं.
Tally par complete video banaye
Thanks🙏🙇 for this video!
Hello Satyam,
Abhi channel par Tally ERP9 start Kiya hai aap Basic to Advance Tally Sikh sakte hai.
Thanks in advance 😊
Sir Excel 2007 version me xlookup ka Koi kod hoga to bataiye please
Amazing way you teach.
Lovely.
amazing content
Amazing Thanks a lot
Sir you are great🙏
Nice trick Sir 👌👍
Nice & helpful....thanks..
Happy holi sir
Super Sirrr
Thank u so much
lovely content
Hello
Very useful
GSTR 2A reco by vlookup ke bare me video banaiye
Nice sir
Zabardust sir. If u don't mind u should accept Islam
Thanks sir
Nice video
lovely stuff
Love u Gurujii!
Superb
🌹 सीखते रहो, सिखाते रहो 🌹📖📚🏹🌹🔥 राधे राधे🔥ARK🌹🏹
सदा हंसते रहो, मुस्कुराते रहो
🌹🔥ARK 🏹
kya sir ji ajib type se bol rhe h maza aa gya sun k.
Basic se lekar advanced level tk Ms word video plz sir
Video is under recording
गजब
Sir ji,
Excel me kai logo ke data hai sirial se ek colum me unko word me lana hai usi formet me lekin table na aye aur space bna rahe her para ke bad kaise hoga
Excellent . Very helpful. Can i maintain an excel though which I can send auto Birthday mails using Birthday dates.
Good evening sir`:- mai md abbas ali sir mai apka video dekhta or help full video hota hai apka subscriber v hu, to sir mera kehna hai ki ek video page maker par v banaye sir apka bahu bahut sukriya
In "Data Tab" of excel only the "Get External Data" group is left to learn God knows when you upload a video on this topic. Please do this as soon as possible.
Very easy and amazing, but I couldn't do it😅
Sir koi item h Lakin uske hr sal alg alg rate h to esa konsa formula use kre jis se ki year change krte he us itime k samne itme ki year rate aa jye
Sir bank Cc account ka interest kase nikale aap is par bhi video bnaye please
Sir mujhe colour wise data filter krna hoto kese kru other sheet se mujhe report banani h ...stock ki.. mujhe chhaiye me jo colour ki condition du vo sare colour ke data vha aajaye plzz sir n ye google sheet pr kese hoga
Sar tally me double unit ka video banao
Sir can you make a video on Ms access
Thanks , I want to know this
Yes
Hello sir,
Upka all excel and tally ka all video dekta hum.
Hello brother you are doing very nice work may God bless you
Sir please can you make video on percentage like if my restaurant took order from zomato around 209 rupees but I have to give them 25% how wil apply this formula in excel
#Satish sir its my humble request to u that please shoot 1 video about this 2015,2016,2017,2018 target,achievement,percentage,average,growth,degrowth please explain about it in deeply sir#
Dear sir excell sheet मे sheet 1,2,3,4,5ko यकी सिट मे pivot result karna he kesi karu
Sir, what is the shortcut, if we want to clear filters without disturbing the others filters. For ex: if I am searching the data in h column and I want filter remain but the filter with I had applied in h column should be new one like un filter and filter again
Sir. Pacemaker per video banao plz
Sir Excel main + button per click karne ke baad voo +symbol show nahi ho raha hai
Isko fix kese karo?
Sir typing ke upre ek video banao
Thanks Sir
1 question❓
Agar kisi workbook me kai sheet hai usme se pahli vali main sheet h
Mai chahta hu ki mai jab bhi is workbook ko open karu to pahli vali (main sheet) open honi chahiye please help sir
Osm
Sir if there is any row blank in the middle of the data then will this filter work?
Sir, good morning
Pagemaker me A4 size paper A bhag me bant kar 4shokpatra banane ka video banaei please sir .
How can i make total of filter data in advanced filter?
Code banane ke baad micro enable file me save karna hoga?
I have a students data list but I want to sort according to rank wise on another page and also want to get top 3 ranks with advance filter by using macro.i tried but can't to both at the same time on the same sheet.
Help regarding this plz..
Is video me kounsi branch me highest stock hai...woh nikal sakta hai kiya??....formula use kar ke
Same formula I am applying and same data I have taken, but not getting results
Sir which software you edit the videos, please you tell me And make a full guide video, please sir I request you, thank you for watching my comment, thanks again
how to past data from one sheet to another sheet which have formulas & duly protected.
yes
Sir Plz Ms word pe video bnao🙏🙏
Satish Sir ye jo bade miya yani advance Filter hai isme agar criteria change karte hai to filtered data change nahi ho raha hai. kya kare.
Sir Kya baat h sir gf impress ho gyi sir
छोटा सा नना सा डाईलोग बॉक्स 👍🤣
Namaskar Sir,
Agar main Excel sheet 1 me school result type kar raha hu , jaise roll no.1, Name , pass, roll no. 2, name, fail and so on, lekin automatically sheet 2 me sare pass students aur sheet 3 me sare fail students ke roll no and name type ho jaye, isliye koi formula ho to karke video me batayenge to badi meherbani hogi sir.
Thank you.
sir active sheet ka code yellow ho jaaa raha hai aur debug karne ko bol raha hai aur kaam nahi kar raha
Sir day selection kare 1+ date aaye kaise hoga bata sakte hai
Sir
1 st कॉलम मे- क्विंटल, 2 nd कॉलम मे- किलो 3rd कॉलम मे - ग्रॅम इस तरह अलग अलग कॉलम मे माल का वजन दिया धुवा है तो उसको
अगले कॉलम मे सुरू की शिल्लक इस महिने मे आया हुवा माल इनकी टोटल कैसे करे
क्या इसके बरे मे कोई व्हिएडो बनया हुवा है
Please
aur ha sir tally 9 ka update version 6.6 aa gaya hai to kya aapki taraf se uspe video milega ?
Want to use filter n split screen together how can we do that ??
Hi sir
I have one query. Suppose I have data of college student where in one column there are names of the student and in another column names of the colleges. I want to select only 1 student from each college. If you want i will give you data.
Sir will dynamic filter works on multiple data in a cell