Advanced Filter in excel in Hindi - Advanced Excel Tutorial in Hindi - Auto VS Advanced filter

  Рет қаралды 301,607

Deepak EduWorld

Deepak EduWorld

Күн бұрын

advanced filter in excel in Hindi MS EXCEL 2007 2010 2016 & 2013 - ADVANCED FILTER की मदद से Data को Filter करना with 5 Different examples - Filter and Advanced filter में क्या फर्क है auto filter vs advanced filter - how to use filter the list in place and copy to another location features of advanced filter detailed explanation. advanced excel.
The #advancedfilter feature in MS Excel helps the user analyze worksheet data based on multiple criteria using a 'criteria' range. Advanced filter in Excel can also help display only unique values. Filtered data can be displayed in-place or in other rows and columns of the worksheet. #deepakeduworld #excelinhindi
Sort and Filter In Excel in Hindi - How to filter data in excel Hindi Watch This video • Sort & Filter Data In ...
Sort and Filter In Excel in Hindi - sort data in excel by value , cell color or font color in Hindi • Sort and Filter In Exc...
ADVANCED FILTER VIDEOS SERIES:
1. Advanced Filter in excel in Hindi - Auto VS Advanced filter
• Advanced Filter in exc...
2. Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
• Filter Data To Another...
3. How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi
• How To Filter Data For...
4. Advanced filter unique records only in hindi
• Advanced Filter In Exc...
5. Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet
• How To Make ADVANCED F...
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld KZbin Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Tags : advanced filter in excel 2010 in hindi,how to use advanced filter in excel 2007 in hindi,advanced filter in ms excel in hindi,advanced filter ms excel hindi,hindi,excel,advanced filter,advance excel,filter in excel,microsoft excel,excel in urdu,excel in hindi,use filters in excel hindi,advanced,filter,in excel,urdu,auto filter,filter function,internet,deepakeduworld,deepak eduworld,unique record

Пікірлер: 404
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
@muzaffarraza2435
@muzaffarraza2435 5 жыл бұрын
Bahut achha apka ye video dekh kr ...total samjh gye
@amitnigam3781
@amitnigam3781 3 жыл бұрын
बहुत ही अच्छी तरीके से समझाया है आपने, आपके समझाने का तरीका अति उत्तम है गुरूजी। आपका धन्यवाद 🙏
@Prana560
@Prana560 Жыл бұрын
Your teaching way is easy to understand.
@anjalisiwach8814
@anjalisiwach8814 2 жыл бұрын
Thank you very much sir,,you solved all my problems with ease..😊🥰
@soumenkumarmaji2938
@soumenkumarmaji2938 3 жыл бұрын
Aap jayse samjhate hai, bahat easy hota hai samajhna
@farhakhan470
@farhakhan470 6 жыл бұрын
Sir, Filter & advance Filter me kya Different hai...sir y hm only Filter me bi to kr skte hai...plzz Sir ap btay Advance Filter me hi kiyo ?
@purushottamjha3925
@purushottamjha3925 2 жыл бұрын
Very Helpful Video.
@TheAsifansariable
@TheAsifansariable 6 жыл бұрын
Hi Deepak... Appreciate your work ...fabulous.... I have one question , I was apply advanced filter and trying to copy to another sheet but every times error shows , is this mean we are bound to copy only on active sheet ?
@nikkap25
@nikkap25 2 жыл бұрын
Sir aap best tarike se sikhate ho. ❤️kya aap bata sakte hai ki horizontal filter possible hai?? 🌹
@surendkurrey4377
@surendkurrey4377 6 ай бұрын
Bhaiya apka video sabse best hai❤❤❤❤
@deepakbarua8087
@deepakbarua8087 2 жыл бұрын
You teach in a very simple way its really very easy to understand. Wow Sir keep it up. God bless you
@niteeshkumarkushwaha6871
@niteeshkumarkushwaha6871 2 жыл бұрын
Very good supporting video
@thakuryogesh9744
@thakuryogesh9744 3 жыл бұрын
Sir ji namaskar trick was wonderful and intresting.
@ashokmirasi9550
@ashokmirasi9550 Жыл бұрын
Thank you so much ❤️ brother
@humanbeingpritam4771
@humanbeingpritam4771 3 жыл бұрын
Deepak sir by seeing your videos i have cleared my office interview can u suggest more what should i done for sales coordinator profile
@krishnamurthy-jf3kp
@krishnamurthy-jf3kp 4 жыл бұрын
Sir very nice video, I have a question can I use multiple criteria in same column? Example: Both A & B should be filtered out of 20 alphabets is it possible
@MANUMANU-wl8vj
@MANUMANU-wl8vj 3 жыл бұрын
Very nice video sir
@golucreation2544
@golucreation2544 Жыл бұрын
Bahut acha laga sir 👌
@shaukatsamad2510
@shaukatsamad2510 6 жыл бұрын
Thx, very much to disclose the latest advance filter I have learn much more , I hope u ll teach us to enable to work further.... I appreciate.....
@GAMINGPLAZA100
@GAMINGPLAZA100 2 жыл бұрын
Love you bhaiya 🤗🤗
@mamtajaiswal7465
@mamtajaiswal7465 2 жыл бұрын
Deepak ji your videos are very nice .but your typing cell is blur ,plz clear this , i don't understand ,what type you on sheet..plz clear showing
@israrmohammad362
@israrmohammad362 2 жыл бұрын
Appreciate your efforts sir🙏🙏🙏
@kiranwadhwa245
@kiranwadhwa245 6 жыл бұрын
Very interesting thanku sir
@ashutoshkumarsrivastava8426
@ashutoshkumarsrivastava8426 4 ай бұрын
This class is best
@harshalmore1169
@harshalmore1169 4 жыл бұрын
This is very amazing sir...
@shrutibarik6792
@shrutibarik6792 6 жыл бұрын
Bhaut achha laga sir
@yingkionglab8143
@yingkionglab8143 3 жыл бұрын
👍👍👌👌🙏🙏 Excllent Sir....
@vinay103
@vinay103 6 жыл бұрын
Very nice and helpful for me. Thanks
@Parul10aug
@Parul10aug Жыл бұрын
Good explanation. Easy to understand.
@dushyantkumarsahu7474
@dushyantkumarsahu7474 5 жыл бұрын
Hi, Agr advance filter dusri sheet me use karta hu, to obviously particular filtered data source sheet se dusri sheet me copy ho jata h, Agar mai source sheet me bad me update karta hu, to updated data dusri sheet me automatically copy nhi hota, Same process dobara karna padta hai Is there any solution ki bad me update hone wali data bhi automatically copy ho jaye Please comment
@MuhammadRamzan-zj8sv
@MuhammadRamzan-zj8sv 2 жыл бұрын
Brother I have a question please help me. This is a daily out gate items to patties sometimes items name are same and models and color are different. But I want sum quantity of items from this table of particular party with same model and color please brother give me some advice. I have a sheet which having 6 main columns as it is Dates, Party name, Item name, model, color and quantity. But I want sum quantity of items from this table of particular party with same model and color that are repeating during a time duration.
@venkat_1956
@venkat_1956 5 жыл бұрын
Bahuth accha
@gamingtycoon1540
@gamingtycoon1540 5 жыл бұрын
very nice deepak bhai. but can you please tell us about range and criteria range easy?
@subashchander9137
@subashchander9137 3 жыл бұрын
Excellent dear brother
@vinitagupta4905
@vinitagupta4905 4 жыл бұрын
May you. Move ahead in life
@jgvaja2117
@jgvaja2117 4 жыл бұрын
Very nice guidance on advance filter.. thanks
@mukeshkumarjain4346
@mukeshkumarjain4346 4 жыл бұрын
Very nice sir g... 🙏🙏🙏
@anileducation1809
@anileducation1809 4 жыл бұрын
Bahut achha sir
@javedahmed8343
@javedahmed8343 8 ай бұрын
You should have mentioned the two or more conditions based on the same column.
@ritikasingh6948
@ritikasingh6948 2 жыл бұрын
Bhot achha
@akhileshrajbhar4984
@akhileshrajbhar4984 4 жыл бұрын
Sir , advance filter me jo work kiya jata hai. use pivat table me bhi to kr sakte hai. Ya phir koi antar hai. pls help.
@bijaytanty8434
@bijaytanty8434 11 ай бұрын
Thanks 🙏
@tripathivl
@tripathivl 6 жыл бұрын
Very good
@SurendraSingh-vi2bs
@SurendraSingh-vi2bs 5 жыл бұрын
Deepak ji meine Excel video de dekhi hai aur muche kuche sawal hai tha
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
???
@therestartsingingsangu7143
@therestartsingingsangu7143 2 жыл бұрын
Sir I got some difficulty while doing advanced filters on single condition of total sale >2500 after applying advance filter my results is not showing on the table I can see only the headings not the table ... Pls solve my queries
@Anshu-wz3hv
@Anshu-wz3hv 8 ай бұрын
Excellent sir
@n.k.tiwari122
@n.k.tiwari122 4 жыл бұрын
Excellent sir.
@hanumantsinghrana9244
@hanumantsinghrana9244 6 жыл бұрын
kya hum apne PC ko internet server bana sakte he only for personal use.
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Ys.. Well i will publish a video on this intresting topic shortly
@kalikali5243
@kalikali5243 Жыл бұрын
Deepak bhai i am not having filter function showing but filter xml is showing please help me
@LovepreetKaur-ms9yq
@LovepreetKaur-ms9yq 5 жыл бұрын
Kya app hame advance excel ke excellent short cut keys ke bare me bata sakte hai all short keys
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
G blkill.. I ll publish video as soon as possible
@hibye4075
@hibye4075 5 жыл бұрын
thank you sir very much
@poojachoubey758
@poojachoubey758 6 жыл бұрын
And this feature is superb...
@saydurrahmanmukul7850
@saydurrahmanmukul7850 6 жыл бұрын
Just subscribed.. liked the way you explain.. can you show us by zooming the options and formula you use.. thanks :-)
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
in my next videos i'll remember it... Thanks
@prateekgupta7703
@prateekgupta7703 5 жыл бұрын
Sir g alag alag colum m 1 hi value k ek sath record filter hoke Kaise copy honge
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
Please watch another video on this topic.. Link is given in description of this video
@Jairohit
@Jairohit 4 жыл бұрын
Sir ye ram ke sath raman b dikha raha he unique records only karne k baad bhi
@ChandanKumar-lb7lh
@ChandanKumar-lb7lh 5 жыл бұрын
Sir advance filter se milavat filter kar sakte hai.
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
🤣🤣🤣🤣
@aliakhan2680
@aliakhan2680 6 жыл бұрын
EXCELLENT
@mahikohli4167
@mahikohli4167 2 жыл бұрын
Thank you sir🙏
@waseemalam9649
@waseemalam9649 3 жыл бұрын
thank you so much bro
@officialimmu9447
@officialimmu9447 2 жыл бұрын
Good sir
@basantkumarchandola2897
@basantkumarchandola2897 3 жыл бұрын
धन्यवाद।बहुत सुन्दर video है।मैंने भी same table बनाई है।सब कुछ ठीक है ,परन्तु टेबल के अंत में add करने पर drop down list में show नही हो रहा है। कृपया मदद करें।उम्मीद है कि आप रिप्लाई जरूर करेंगे।
@ramveersingh8833
@ramveersingh8833 5 жыл бұрын
Very nice sir
@ajaynamdev7544
@ajaynamdev7544 Ай бұрын
Excellent
@kiransati3508
@kiransati3508 4 жыл бұрын
Thanks sir.....
@sprasadmohapatra2897
@sprasadmohapatra2897 3 жыл бұрын
Sir when l fillter a data in exc so how can recovery my data his original position in excl
@rijwansaifi7305
@rijwansaifi7305 6 жыл бұрын
vry nice i like it
@biren09safety
@biren09safety 6 жыл бұрын
100% extremely excellent
@arafatkhan3868
@arafatkhan3868 6 жыл бұрын
Excellent brthr
@samiabhatti9238
@samiabhatti9238 3 жыл бұрын
Very informative. How can I get this excel sheet, it just would be easy to practice on the same excel and do not have to type in excel to make one?
@nazim9681
@nazim9681 Жыл бұрын
Thanks alot
@MrSagarsahni
@MrSagarsahni 5 ай бұрын
Very nice
@SHORTMOVIES-bc7jy
@SHORTMOVIES-bc7jy Жыл бұрын
Thankyou sir
@dadwalnaresh1697
@dadwalnaresh1697 6 жыл бұрын
Bhai bhut bdiya , bt thoda sa short cut keys Ko B sath lekr chlo Bhai,
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
G
@alpeshlpatelpatel7735
@alpeshlpatelpatel7735 Жыл бұрын
Good
@rahulram7273
@rahulram7273 6 жыл бұрын
I liked the method
@GAMINGPLAZA100
@GAMINGPLAZA100 2 жыл бұрын
Mene to Puri vdo dekhi
@GaganSaraon
@GaganSaraon 11 ай бұрын
Sir aapki ms access ki video nahi mil rahi hai.
@renumalandiya7259
@renumalandiya7259 3 жыл бұрын
Nice bro👍😊
@bakshiABC
@bakshiABC 6 жыл бұрын
I really appreciate it
@mohammadkasim8351
@mohammadkasim8351 6 жыл бұрын
Sir agar mai advance filter se dusri jaagh paste karta hu aur mai Kuch main sheet per edit karta hu to kya automatic update Hoga pasted sheet.... Plzzzz reply.......
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
No.. Update nhi hoga..
@manikpasalkar2190
@manikpasalkar2190 4 жыл бұрын
अगर किसी कौलममे कंमेंट लिखी हो उसी सबके (सिर्फ कंमेंट किये हुए रेकॉर्ड ) रेकॉर्ड कैसे फिल्टर कर सकते हैं?
@hadessshareef3700
@hadessshareef3700 5 жыл бұрын
Mujay sort and filter samjna ha ya wali sort and filter ki vedio ha Kya agr ya wali sort and filter ki vedio nahi ha to mujay link send kardain kon si vedio ha plz sir
@yashprajapati9981
@yashprajapati9981 6 жыл бұрын
Super sir
@nilimasahu3026
@nilimasahu3026 2 жыл бұрын
Sir thank u
@atulyadav-re8tn
@atulyadav-re8tn 6 жыл бұрын
Sir Apni DSR daily banate hai lekin billing monthly krte hai to koi aisa tarika hai ki auto filter hokr client ka bill automatically maintain hota rahe DSR se separate sheet pr Please help
@ddhamecha
@ddhamecha 6 жыл бұрын
I required one help. If there is a data in which I have list of sales persons. How can I create the same data with individual sales in different sheets.
@AbhishekKumar-yf8hi
@AbhishekKumar-yf8hi 6 жыл бұрын
Go with pivot table
@tejindersingh5581
@tejindersingh5581 3 жыл бұрын
Sir, mene is ko hindi font mein use kiya tha bt isme koi result ni aw rha ha....?? Sir, plz explained..
@bikramaggarwal4900
@bikramaggarwal4900 5 жыл бұрын
i have 8 sheets in same workbook. its classwise sheets i. e. I, II, III, IV, V, VI, VII, VIII. in all sheets there is some EWS STUDENTS. How i can club all the EWS students list on one sheet with advance filter
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
🤔 Good question... I ll try it. How is that possible.. 👍👍👍 I will publish video as soon as possible
@chandan7908
@chandan7908 6 жыл бұрын
Thanks
@VishalKumar-fj7qm
@VishalKumar-fj7qm 2 жыл бұрын
practice file download krni hai
@raman9932
@raman9932 6 жыл бұрын
sir l have a problem,i want to use sercheable drop-down list in the invoice description column.it is not working when data validation is required. please solve my problems.
@ManpreetSingh-cp2wd
@ManpreetSingh-cp2wd 4 жыл бұрын
Sir ji alag file m ja sakte h kya
@dwijendralalbhowal3984
@dwijendralalbhowal3984 2 жыл бұрын
Sir mujhe यह Bata dijiye की Hum IF function का condition fulfill होने की इसकी condition के bare mai agar हमारे values 0show karti है तो kya value condition fulfill नहीं होती अऔर condition false होती है.
@vishwa3448
@vishwa3448 3 жыл бұрын
Sir ji Share workbook with micro karta hu to advance filter micro kam karna band kar deta hai koi solution hai to bataiye pl
@salauddinkhokon5596
@salauddinkhokon5596 4 жыл бұрын
Hello Mr dipaak sir, mayne apka bohat tutorial Dekha, or bohat kus Shikha . magar apka jo invoice back up tutorial he usme apne pura invoice ke back up lane ki tecknick nahi dikhaya. Jo bhi Ho hamna hamara apni buddhi sa pura invoice record ki back up Lana MA success hua he . leaking AK Naya samasya khara hua ha, jub hum Naya invoice back up entry lata ha ,Purana entry line sirf ek hi line record show karta ha. is samasya ka samadhan hum kaysa kara sir. koye hall hay Kia, agar up chata ha to hum is problem ki screen short vage na chahta ha.up LA Lia bohat subh kamana ha.
@vivektripathi2439
@vivektripathi2439 2 жыл бұрын
Ms office me 2007 me advances excel h kya plz ya kahan hota h mujhe nhi mil rha h
@altafhusainansari4282
@altafhusainansari4282 Жыл бұрын
Hi, Deepak Jii. Is trip me ap Uniq name Nikalne ka Nahi bataye hai. Kiya Uniq Name Bina Macro k Nikal Sakta hai.. Mecro k sath mene use Kiya hai Par without Mecro Use nahi Kiya hai. Kiya Without macro Advance Filte k use kar k Uniq Name Nikal Sakte hai kiya...
@sujoysarkar5406
@sujoysarkar5406 6 жыл бұрын
Great
@wahidrashid4865
@wahidrashid4865 5 жыл бұрын
sir agar cells merge ho to kiya phir bi ye kaam kry ga
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
No
Как подписать? 😂 #shorts
00:10
Денис Кукояка
Рет қаралды 7 МЛН
Worst flight ever
00:55
Adam W
Рет қаралды 26 МЛН
The joker favorite#joker  #shorts
00:15
Untitled Joker
Рет қаралды 30 МЛН
How to Use Macro in Excel in Hindi
15:50
Deepak EduWorld
Рет қаралды 1,5 МЛН
Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
18:04
Beginner to PRO Data Analysis with Excel - FREE Adv. Masterclass in TELUGU
36:04
Chandoo in Telugu (తెలుగులో)
Рет қаралды 254 М.
Как подписать? 😂 #shorts
00:10
Денис Кукояка
Рет қаралды 7 МЛН