99% Excel users are not using this trick of Excel Advance Filter (हिंदी)
ฝัง
- เผยแพร่เมื่อ 21 ต.ค. 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 TH-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
![CAMPปลิ้น | EP.83[1/2] เปิดแคมป์หลอนต้อนรับ 2 ตัวพ่อแห่งวงการผี!](http://i.ytimg.com/vi/2uPuHYHgwiI/mqdefault.jpg)
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👌👌👌👌👌👌👌👌👌👌👌👌
Satish sir aapke samjhane ka tarika bahut accha hai
Learning and typing practice is a best part fir all of users.
Sir you are a genius of computer technical of pc masters.
I already following you in Facebook also. You are a great teacher and I love your teaching style. Thank You Respected Sir 🙏.
Very nice way of teaching 😊😊
Bahut hi achha samjate he app thank you sir ji
First of all a lot of best wishes to the new born baby.As always this video is also the best.
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.
Thanks Satish
Sir 🙏🙏
hamko Free me Padhane ke liye🙏🙏
Vase kon etana time west karke hamko padhyega .apke es kam ko meri tarpse salute🙋🙋👍?🙏🙏👏👏?❤❤❤❤❤❤👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks sir Best teacher 👍
Waoooooooo sir. Very useful video.
Amazing explaintion
Sach a great teacher nd
Sir u are really Awsome
Wow, maza agya.thanks..agar Heading name fix na hokar,dynamic ho tab kya change hoga code me, please bataiye..
Kataiii Jahar H Sir Yee Chotee Miya Or Badeeee Miya
Very Nice Sir Ji
Nice trick Sir 👌👍
Nice Video Sir Keep It Up Well Done 👍👍👍
Amazing way you teach.
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.
Excellent sir
Nice way to explain !!!
amazing content
Good explanation
Sir you are great🙏
Useful video sir
lovely content
Hello
very informative
Nice & helpful....thanks..
Google sheets के लिए भी वीडियो बनाएं.
Amazing Thanks a lot
lovely stuff
Happy holi sir
Love u Gurujii!
Great sir
इस कोड का उपयोग google sheets पर भी करके बताएं.🙏
Excellent . Very helpful. Can i maintain an excel though which I can send auto Birthday mails using Birthday dates.
Excellent
सर जी आप से मेरा निवेदन है कि आप एक video FULL ADVANCE EXCEL पर बनाए तो 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙋🙋🙋
Sir Excel 2007 version me xlookup ka Koi kod hoga to bataiye please
Super Sirrr
Superb
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 😊
Thank u so much
kya sir ji ajib type se bol rhe h maza aa gya sun k.
Lovely.
Nice sir
Thanks sir
Nice video
गजब
Thanks , I want to know this
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
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
Basic se lekar advanced level tk Ms word video plz sir
Video is under recording
Very easy and amazing, but I couldn't do it😅
sir, kya esa ho sakta hai ki excel workbook ki ek sheet me me form(admission form) wise data enter karu to usi workbook ki dusri sheet me wo data apne aap enter ho jaye wo bhi list form me or wo bhi paheli sheet ma last me submit ka button de ke uspe click karu uske baad hi dusri sheet me data list wise enter ho kya esa ho sakta hai please ans. sir
Sir can you make a video on Ms access
Sir. Pacemaker per video banao plz
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
Hello sir,
Upka all excel and tally ka all video dekta hum.
Is video me kounsi branch me highest stock hai...woh nikal sakta hai kiya??....formula use kar ke
Sir if there is any row blank in the middle of the data then will this filter work?
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
Sir will dynamic filter works on multiple data in a cell
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.
Osm
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 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
aur ha sir tally 9 ka update version 6.6 aa gaya hai to kya aapki taraf se uspe video milega ?
Code banane ke baad micro enable file me save karna hoga?
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
#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#
Sar tally me double unit ka video banao
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..
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 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
Sir, is it can use with data validation list means when brand name change the data should be update. Pl confirm.
how to past data from one sheet to another sheet which have formulas & duly protected.
Want to use filter n split screen together how can we do that ??
Dear sir excell sheet मे sheet 1,2,3,4,5ko यकी सिट मे pivot result karna he kesi karu
🌹 सीखते रहो, सिखाते रहो 🌹📖📚🏹🌹🔥 राधे राधे🔥ARK🌹🏹
सदा हंसते रहो, मुस्कुराते रहो
🌹🔥ARK 🏹
How can i make total of filter data in advanced filter?
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 Plz Ms word pe video bnao🙏🙏
Sir vba code is not copy i mean the content is not select for any action.
छोटा सा नना सा डाईलोग बॉक्स 👍🤣
Zabardust sir. If u don't mind u should accept Islam
Sir, good morning
Pagemaker me A4 size paper A bhag me bant kar 4shokpatra banane ka video banaei please sir .
Yes
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.
Dear Sir, I am really fan of your knowledge and teachings. I am stuck in one of my program. I have a sale data in one sheet e.g. In a row I have Sale of Item1, Item2, Item3 and so on and in a column name of customers. Please note that customer name can appear many times. Now in a another sheet I want to show name of all customers (Only Once) and the total of sale of Item1, Item2, Item3 and so on. Please help me.
Sir Kya baat h sir gf impress ho gyi sir
Sir, how can I switch from one sheet to another sheet in excel with key board short cut. Plz tell me.
Ctrl+pageup & pagedown
Sir....ye Ms Excel 2007 me work nii krta kya🙏
Wps me ms excel ke sare formule work kyon nahi karte hai sir for eg.
Spellnumber formula code ko spreadsheet me past karne ke liye alt+f11 press karne par kuchh bhi nahi open ho raha hai sir.
Please sir spreadsheet par ek full video banaye .