99% Excel users are not using this trick of Excel Advance Filter (हिंदी)

Рет қаралды 134,598

4 жыл бұрын

इस वीडियो में एक्सेल के बड़े मियाँ याने 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.in/Excel-Auto-...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses 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/
------------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
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 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

Пікірлер: 166

@Learn_More_Pro 2 жыл бұрын

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/

@satyamthepassionate5430 4 жыл бұрын

Love u Gurujii!

@somrajbanerjee3500 Жыл бұрын

I already following you in Facebook also. You are a great teacher and I love your teaching style. Thank You Respected Sir 🙏.

@AbhayExcelComputer 4 жыл бұрын

First of all a lot of best wishes to the new born baby.As always this video is also the best.

@dobolsachke1997 4 жыл бұрын

Kataiii Jahar H Sir Yee Chotee Miya Or Badeeee Miya

@im_noushad7 4 жыл бұрын

Amazing way you teach.

@bdrider910 4 жыл бұрын

Bahut hi achha samjate he app thank you sir ji

@uttamanandarout7135 4 жыл бұрын

Amazing Thanks a lot

@bkdeshmukh12 4 жыл бұрын

Thanks sir Best teacher 👍

@vaibhavpawar3509 4 жыл бұрын

Bahut acha Pahate ho Nice teaching👌👌👌👌👌👌👌👌👌👌👌👌

@Tracks777 4 жыл бұрын

lovely stuff

@Tracks777 4 жыл бұрын

amazing content

@ashoksahu9546 4 жыл бұрын

Waoooooooo sir. Very useful video.

@Udaykaujiya 4 жыл бұрын

Satish sir aapke samjhane ka tarika bahut accha hai

@killergaming2.082 Жыл бұрын

Learning and typing practice is a best part fir all of users.

@ta20111996 4 жыл бұрын

Nice & helpful....thanks..

@makarand1985 3 жыл бұрын

Nice way to explain !!!

@ronak--sinyal41119 4 жыл бұрын

Nice Video Sir Keep It Up Well Done 👍👍👍

@killergaming2.082 Жыл бұрын

Sir you are a genius of computer technical of pc masters.

@nagdevmukesh 4 жыл бұрын

Sir you are great🙏

@gamerofficial2.062 Жыл бұрын

Very nice way of teaching 😊😊

@AhmedKhan-gs1uv 4 жыл бұрын

Sir u are really Awsome

@rohanmore2666 Ай бұрын

Amazing explaintion

@bimalbiswas6121 4 жыл бұрын

Useful video sir

@tt_badmash_9560 Жыл бұрын

Excellent sir

@ramnishadkuttuva9306 4 жыл бұрын

Good explanation

@sabir017 2 жыл бұрын

Great sir

@vinitpanchli474 2 жыл бұрын

Sach a great teacher nd

@soumyadeepdhar3618 3 жыл бұрын

Lovely.

@anshikachoudhary2026 2 жыл бұрын

very informative

@k.ravikumar4160 3 жыл бұрын

Thanks , I want to know this

@vinayaktirlotkar3500 3 жыл бұрын

Thank u so much

@shaikhjalil1290 4 жыл бұрын

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.

@arunkumarsinghark3024 4 жыл бұрын

Very Nice Sir Ji

@RABINDRAYADAV-cc3ds 4 жыл бұрын

Nice trick Sir 👌👍

@ramveerpawar5430 4 жыл бұрын

Thanks sir

@satyatathya5176 2 жыл бұрын

Excellent

@subhankar81 4 жыл бұрын

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.

@dobolsachke1997 4 жыл бұрын

Super Sirrr

@Tracks777 4 жыл бұрын

lovely content

@yogeshkumarbaheliyaaliganj2105 3 жыл бұрын

Hello

@vaibhavpawar3509 4 жыл бұрын

Thanks Satish Sir 🙏🙏 hamko Free me Padhane ke liye🙏🙏 Vase kon etana time west karke hamko padhyega .apke es kam ko meri tarpse salute🙋🙋👍?🙏🙏👏👏?❤❤❤❤❤❤👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

@mayankapandit 3 жыл бұрын

Excellent . Very helpful. Can i maintain an excel though which I can send auto Birthday mails using Birthday dates.

@dibyanshyadav281 4 жыл бұрын

Nice sir

@mohammedirfan4301 4 жыл бұрын

Superb

@dibyanshyadav281 4 жыл бұрын

Nice video

@satyamthepassionate5430 4 жыл бұрын

👍💯

@sarvodayaconventvidisha1757 4 жыл бұрын

गजब

@rajendramehra4651 4 жыл бұрын

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

@manishabhagare4954 4 жыл бұрын

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.

@mdiftekhar9129 4 жыл бұрын

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

@sandyshrm1 2 жыл бұрын

Wow, maza agya.thanks..agar Heading name fix na hokar,dynamic ho tab kya change hoga code me, please bataiye..

@estfaali9185 4 жыл бұрын

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

@RahulKumar-ly6ly 4 жыл бұрын

Happy holi sir

@AnujSharma-hv8ji 4 жыл бұрын

kya sir ji ajib type se bol rhe h maza aa gya sun k.

@satyamthepassionate5430 4 жыл бұрын

Tally par complete video banaye Thanks🙏🙇 for this video!

@eModernGuruji 4 жыл бұрын

Hello Satyam, Abhi channel par Tally ERP9 start Kiya hai aap Basic to Advance Tally Sikh sakte hai. Thanks in advance 😊

@afzalahmad6452 4 жыл бұрын

Very useful

@MrASHOKSINGHVI 4 жыл бұрын

GSTR 2A reco by vlookup ke bare me video banaiye

@SachinKumar-cx4th 4 жыл бұрын

Osm

@ShivamRaj-ll1fj 4 жыл бұрын

Yes

@SudhaRani-lx4sb 4 жыл бұрын

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

@arvindchauhanable 4 жыл бұрын

Sir, is it can use with data validation list means when brand name change the data should be update. Pl confirm.

@rajneesh9483 4 жыл бұрын

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

@informationiswealth8123 2 жыл бұрын

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

@vishalchandrani2962 4 жыл бұрын

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

@jhumpapihudas2155 4 жыл бұрын

Sir will dynamic filter works on multiple data in a cell

@sejalpatel7842 3 жыл бұрын

Very easy and amazing, but I couldn't do it😅

@arunkumarsinghark3024 4 жыл бұрын

🌹 सीखते रहो, सिखाते रहो 🌹📖📚🏹🌹🔥 राधे राधे🔥ARK🌹🏹 सदा हंसते रहो, मुस्कुराते रहो 🌹🔥ARK 🏹

@vinodvishwakarma5387 4 жыл бұрын

Google sheets के लिए भी वीडियो बनाएं.

@vinodvishwakarma5387 4 жыл бұрын

इस कोड का उपयोग google sheets पर भी करके बताएं.🙏

@SNDFFGS 4 жыл бұрын

yes

@acieducation6401 4 жыл бұрын

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

@zafarjaved7522 2 жыл бұрын

Sir can you make a video on Ms access

@mahisinghaman5105 4 жыл бұрын

Sir Kya baat h sir gf impress ho gyi sir

@mdiftekhar5223 4 жыл бұрын

Sir typing ke upre ek video banao

@techsolutions533 4 жыл бұрын

Sir. Pacemaker per video banao plz

@tarakadhikary3141 3 жыл бұрын

Sir Excel 2007 version me xlookup ka Koi kod hoga to bataiye please

@powerofsharemarket7801 4 жыл бұрын

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.

@jenishghori9443 4 жыл бұрын

aur ha sir tally 9 ka update version 6.6 aa gaya hai to kya aapki taraf se uspe video milega ?

@amirkhan-to5gf 4 жыл бұрын

Sir bank Cc account ka interest kase nikale aap is par bhi video bnaye please

@ExcelUnleashed 4 жыл бұрын

Want to use filter n split screen together how can we do that ??

@deshireallifevlogs9364 3 жыл бұрын

सर जी आप से मेरा निवेदन है कि आप एक video FULL ADVANCE EXCEL पर बनाए तो 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙋🙋🙋

@jenishghori9443 4 жыл бұрын

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

@surajitmanna2453 4 жыл бұрын

Hello sir, Upka all excel and tally ka all video dekta hum.

@kamaleshsidar8921 4 жыл бұрын

Sir, good morning Pagemaker me A4 size paper A bhag me bant kar 4shokpatra banane ka video banaei please sir .

@shubhampal8789 4 жыл бұрын

Sir Plz Ms word pe video bnao🙏🙏

@satyamthepassionate5430 4 жыл бұрын

😮

@subhankar81 4 жыл бұрын

Is video me kounsi branch me highest stock hai...woh nikal sakta hai kiya??....formula use kar ke

@ceomdistributionpesco7333 4 жыл бұрын

how to past data from one sheet to another sheet which have formulas & duly protected.

@harekrishna7162 2 жыл бұрын

Sir if there is any row blank in the middle of the data then will this filter work?

@rk-abc123 4 жыл бұрын

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.

@rajasolanki9096 4 жыл бұрын

छोटा सा नना सा डाईलोग बॉक्स 👍🤣

@ghanshyamsinhkalusinhrana2032 3 жыл бұрын

How can i make total of filter data in advanced filter?

@pankajmishra7327 4 жыл бұрын

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 .

@prateeksharma277 2 жыл бұрын

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

@rakeshinfotech7296 4 жыл бұрын

Sar tally me double unit ka video banao

@bdrider910 4 жыл бұрын

Sir ap mumbai se ?

@sainilokesh618 4 жыл бұрын

Sir, how can I switch from one sheet to another sheet in excel with key board short cut. Plz tell me.

@ikrarkhan1598 4 жыл бұрын

Ctrl+pageup & pagedown

@sandeepbhargava2714 4 жыл бұрын

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.

@smartstudyeducation3780 4 жыл бұрын

Sir how to type odia language in ms word with out using other software plz sir, I request you plz help me sir

@RakeshSaini-yy7vt 4 жыл бұрын

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.