Тёмный
No video :(

How To Use 👉 Slicer 👌🔥 Amazing Time Saving Tool In Excel 

Deepak EduWorld
Подписаться 1,2 млн
Просмотров 183 тыс.
50% 1

How To Use Slicer Function in excel 2013 2016 - slicer Amazing Time Saving Tool In Excel which work like filter but its much batter than filter. we can instantly apply multiple filters just in one click on database using excel slicers. this slicer feature is available in excel 2013 or above all versions 2016 and 2019. this slicer function can save your lot of time. slicer is much interesting with subtotal formula, subtotal formula of excel is used to male calculations on filtered data only. all the hidden data is not included in subtotal formula. watch this interesting video of micro soft excel to learn slicer with subtotal function.
#SLICER
#excelmagic
#Excel
Download Training File drive.google.c...
Also Watch these videos :
Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi • Filter Data To Another...
Advanced Filter in excel in Hindi - Advanced Excel Tutorial in hindi - Auto VS Advanced filter • Advanced Filter in exc...
Advanced Filter In Excel - Filter Unique Records Only [ Hindi ] • Advanced Filter In Exc...
How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi • How To Filter Data For...
Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये • Index Formula in Excel...
Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi • Index + Match Function...
How to use IFERROR formula in excel || HINDI • How to use IFERROR for...
IF Logical Function in excel in Hindi • IF Logical Function in...
Excel मे ऐसा If Formula सीख लो 👉 Boss भी चुटकियों मे Impress हो जाएगा • Excel IF Formula - IF...
Hope you will like the video and subscribe Deepak EduWorld. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
________________________________________________
ADVANCED MS EXCEL के लिए ये playlists देखे ► goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे ► goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे ► goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► goo.gl/paZmpn
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Subscribe to my channel ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
**********************************************
Thanks for Watching
Happy Learning
ER DEEPAK NEHRA [ M.Tech. ]
**********************************************
slicer in excel 2007,how to insert slicer in excel without pivot table,how to enable slicer in excel 2010,excel slicer dashboard,excel slicer tricks,slicer in excel 2013,subtotal formula in excel,excel subtotal function,pivot table,slicers in excel,deepak eduworld,vlookup in excel,excel in hindi,excel 2013,excel tutorial,pivot table excel,EXCEL USER,LEARN COMPUTER

Опубликовано:

 

5 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 213   
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
@asimkhankolalai9024
@asimkhankolalai9024 Месяц назад
ولساپ نمبر بھیجو بھائی
@SunilSingh-ee4sc
@SunilSingh-ee4sc 5 лет назад
Thanks for sharing data also so that learner do practices also.
@thakarharish4705
@thakarharish4705 4 года назад
बहोत उपयोगी वीडियो लाते हैं थैंक्स सर
@uptoten4367
@uptoten4367 3 месяца назад
Thank You Sir.. Very Helpful Video 🙏
@tridibju
@tridibju 23 дня назад
very informative and helpful video . thanks
@pradeepkumarkanhar3128
@pradeepkumarkanhar3128 3 месяца назад
Thanks very much sir 🙏
@ramkailashyadav1022
@ramkailashyadav1022 5 лет назад
Aapka samjhane ka tarika bhut achha hai sir thanks again please add some macros video or visual basic.
@jeetubhatia841
@jeetubhatia841 5 лет назад
Wah wah Itna mind Kahan se aata hai Powerful
@s.hazratkazimi9891
@s.hazratkazimi9891 5 лет назад
That's a very amazing trick Thank you so much Deepak Sir
@danishtechonline9696
@danishtechonline9696 5 лет назад
Super slicer sir. Thank you so much. Ur amazing ideas.
@shivapadul1983
@shivapadul1983 Год назад
थँक्यू सो मच मै जो ढूंढ रहा था वो आपके पास बरोबर मिला
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
Amazing tool sir ji thanks continue
@rizwandanish3308
@rizwandanish3308 Год назад
This was helpful
@basharatali9939
@basharatali9939 Год назад
Very useful trick's thanks.
@nikhiltamrakar8076
@nikhiltamrakar8076 7 месяцев назад
AAp se behter koi nahi samjha sakta excel jai ho sir aap ki
@bakbakhappy
@bakbakhappy 3 года назад
superb video..india's best youtube channel for learn excel and other
@rakeshthombre
@rakeshthombre 11 месяцев назад
Your video always useful to me sir
@ramnaslai2980
@ramnaslai2980 3 года назад
Great video
@sachithanandamyadav
@sachithanandamyadav 2 года назад
Thank you sir it is very helpful for me
@mehulmehta9382
@mehulmehta9382 3 года назад
apki teaching jordar he sirji!!!
@allaroundme9137
@allaroundme9137 Год назад
Nice tutorials
@amjadmkhan3383
@amjadmkhan3383 5 лет назад
Like aap ki mehnat ke liye.thank
@haryanviincanada7853
@haryanviincanada7853 3 года назад
Very helpful vedio sir .🙏🏼🙏🏼 Really it helped me to understand better.🙏🏼thanka again . Keep making this kind of vedios.
@devanghirapara6657
@devanghirapara6657 5 лет назад
It will be very helpful for me if it works in Google sheet also...
@amitrana8147
@amitrana8147 3 года назад
Sir bina slicer ke ham dashboard or aise advance pivot table nhi bana skte kya plz reply sir❤️❤️❤️?
@mayannkchandavarckar1024
@mayannkchandavarckar1024 5 лет назад
You are great Deepak! Thanking you for valuable information!
@GulshanKumar-wx4wt
@GulshanKumar-wx4wt 4 года назад
Thank you Deepak sir. I am working on excel from long time but I don't know about slicer. Aapke teaching skills aapko bahut accha teacher bnate hai. 1 query hai mujhe suppose mujhe count of sales person lene hai jese ki qty me liya hai to wo kese le skte hai.
@jayshah7016
@jayshah7016 2 месяца назад
Is it possible that slicer me formula based Filter laga sakte he let's say mere data me ek coloum me ledger balances he aur mujhje use Filter karna he above balances above zero. Negative or zero balance Havana he to kar sakte he kya
@AnkitPandey-yu1kw
@AnkitPandey-yu1kw 3 года назад
Very interesting video bhai I have only issue in use of dollar sign 💲 to freeze formula, specifically in vlookup.
@Mr.SBV_92
@Mr.SBV_92 2 года назад
Thanks for sharing it Sir...👌
@gopalkaushik4974
@gopalkaushik4974 Год назад
Great
@PuranKumarBhuwanta
@PuranKumarBhuwanta 2 года назад
Amazing video sir..
@fpathan8091
@fpathan8091 2 месяца назад
Excellent.
@shafkathussain4243
@shafkathussain4243 3 года назад
How to make group of slicer and how to join with the same data table .plz bro
@vijaytaneja8667
@vijaytaneja8667 5 лет назад
Very very nice sir g
@SanjaySingh-eh2ln
@SanjaySingh-eh2ln 5 лет назад
Superb video
@rakibulhasan8592
@rakibulhasan8592 5 лет назад
thanks for unknown things sharing, when i visit your channel, found interested things. thanks Again
@henhenika2670
@henhenika2670 2 года назад
Very informative 👍
@naatenabi2951
@naatenabi2951 4 года назад
very informative only small change needed ... spelling of company is wrong
@UpcomingFojiJafarkhan
@UpcomingFojiJafarkhan 3 года назад
Thanks so much sir
@jyotishukla1207
@jyotishukla1207 10 месяцев назад
Report connection me 2nd pivot table show nhi ho rahi, what should I do, please help.
@atulshah4234
@atulshah4234 5 лет назад
Thanks, God bless you
@yashpainter782
@yashpainter782 5 лет назад
Nice formula keep it 👆 up
@vaishnavigandhi2327
@vaishnavigandhi2327 5 лет назад
Nice sir God bless you
@TazeenAltafTaniTafi
@TazeenAltafTaniTafi Год назад
But problem ye hai k jo bhi new function or formulae hai wo current version of Excel me hai.. but company ager old version he use kr rhi ho to hum interview me kaise perform krenge or job k baad new function use kr k boss ko kaise represent kre. Kindly answer
@sureshv7724
@sureshv7724 3 года назад
Super ji.
@priyanka-hx3lo
@priyanka-hx3lo 3 года назад
Superb thnx
@pankajverma-sh2hb
@pankajverma-sh2hb 3 года назад
Great deepak
@sidhartk1856
@sidhartk1856 5 лет назад
Wow. Slicer
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
😊
@surajsingh-ns8xn
@surajsingh-ns8xn Год назад
Thank you sir, bina filter lagae subtotal formula kaam aega kya??
@SonuKumar-fj9el
@SonuKumar-fj9el Год назад
Under slicer window 7 ya 10 main chal jayega ya nahi
@Rameezraaz1
@Rameezraaz1 5 лет назад
Super cool bro thank you
@ZahidKhan-gs6xy
@ZahidKhan-gs6xy 5 лет назад
Waaaaa sir g ap best ho
@supriyabhattacharya5089
@supriyabhattacharya5089 Год назад
Very good
@biswajitkaran89
@biswajitkaran89 3 года назад
Amazing. Excellent brother.
@venkannagoudkollu9466
@venkannagoudkollu9466 5 лет назад
Excellent bro thank you
@rahulsingh3176
@rahulsingh3176 2 года назад
Thank you sir
@basupallab91
@basupallab91 5 лет назад
Awesome! Mind blowing! 😱😱👍👍👌👌
@jeetendrasinghrajput5928
@jeetendrasinghrajput5928 5 лет назад
Very good concepts and best ideas of things that
@toufiqulla4909
@toufiqulla4909 2 года назад
Bro make one video. If we change the data then slicer will update that data automatically
@banglatechhotspot2235
@banglatechhotspot2235 5 лет назад
Nice tutorial.
@naimshekh6717
@naimshekh6717 5 лет назад
Thanks sir iske liye aapse bat karna tha
@Anikvikram
@Anikvikram 3 года назад
Superb as always
@acousticlove1986
@acousticlove1986 5 лет назад
nice sir.
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
😊
@adnanrana7565
@adnanrana7565 4 года назад
Wonderful
@heerasingh3130
@heerasingh3130 5 лет назад
Hi, can you help me to recover a column which was deleted by mistake from my excel file .
@gcr78
@gcr78 2 года назад
Is this slicer option availability depend on excel version?
@refreshingrelaxingkey9889
@refreshingrelaxingkey9889 10 месяцев назад
Will This slicer work in Google sheet
@dipakparab9048
@dipakparab9048 5 лет назад
Nice very helpful
@arindamdey7035
@arindamdey7035 5 лет назад
Nice video...
@dipikasarkar3537
@dipikasarkar3537 4 года назад
Filter vi too use Kar sakte hai yeh kaam Karne k lia,, too difference kya hai slicer and filter me..... Extra subidha kya hai slicer me...... Pl tell
@LalGebi
@LalGebi 5 лет назад
Great Bro.. keep it up.. one query.. how to place Slicer in another sheet if table is very large in main sheet ?.. can you please tell me
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
Yss.. Please wait.. I will another video shortly
@umeshchandarana8415
@umeshchandarana8415 3 года назад
Best.
@vshddn
@vshddn 5 лет назад
Really Amazing
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
😊
@AnujSharma-hv8ji
@AnujSharma-hv8ji 5 лет назад
slicer bottom ko hm lock kr skte h kya jisase koi delete na kr ske bs use kr ske pr delete na ho na kahi or move ho.
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
No
@abdullavazhayil4868
@abdullavazhayil4868 5 лет назад
Great dear
@directmessage4680
@directmessage4680 6 месяцев назад
Very well explained
@kalanisdynasty
@kalanisdynasty 3 года назад
Sir How to use slicer in android excell apps ?
@ajitbaghel1968
@ajitbaghel1968 Год назад
Super
@gcr78
@gcr78 2 года назад
How can I download this excel file for practice
@sivasuribabu1471
@sivasuribabu1471 4 года назад
Thank you bro..
@DeepakEduWorld
@DeepakEduWorld 4 года назад
😊😊
@sheetalkukreja2744
@sheetalkukreja2744 5 лет назад
Pls upload videos for sql..
@mohaneducationtech
@mohaneducationtech 5 лет назад
Super trikes
@jasjeetsingh8861
@jasjeetsingh8861 5 лет назад
Thanks for the useful information.
@ayushsumbhal3064
@ayushsumbhal3064 5 лет назад
Very useful.... Great efforts.... Thank you so much sir
@amyjain97
@amyjain97 2 года назад
Hi Deepak. How do we use Sumifs or countifs in a single slicer with multiple selection in a slicer
@Deepakkumar-qs3hg
@Deepakkumar-qs3hg Год назад
thanku sir
@salil8880
@salil8880 5 лет назад
भाई साहब बहुत बढ़िया क्या यह एक्सेल 2007 में भी काम करता है
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
No
@ahsan29136
@ahsan29136 Год назад
Ye kaam you filter se b hota hai... ✌
@ca.aarchanajain6354
@ca.aarchanajain6354 5 лет назад
amazing updates
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
😊😊👍
@abang1101
@abang1101 5 лет назад
Thanks sir ji
@sudhayadav1441
@sudhayadav1441 3 года назад
Good thing
@pratikshanimdeokar2462
@pratikshanimdeokar2462 5 лет назад
Gazabbbbb....
@tabrezsiddiqui5411
@tabrezsiddiqui5411 5 лет назад
Sir maine ab tak ki aap sari video dekhi hai aur bakayada mujhe sab samajh me bhi aya hai lekin sir main ek call center me agent hun pichle 4 saal se lekin ab mujhe team leader ke liye ghar baith kar aapki sari video dekhta hun aur usi video se tayyari kar rha hun main ab tak ki aapki lagbhag excel ki sabhi video dekh li hen lekin aapse ek requst hai ek aap ek video call center me jo kaam hota hai jaise AHT, HOLD, WRAP & ATTRITION etc. wagairah nikalna is par aap ek video bana dijiye taki mein team leader ke interview ke liye ja sakun Shukriya sir ....
@DeepakEduWorld
@DeepakEduWorld 5 лет назад
G sure...
@raviprasad6697
@raviprasad6697 3 года назад
Slicer not available in old version
@shankarh6310
@shankarh6310 5 лет назад
NICE BHAI
@asadmahboob1123
@asadmahboob1123 3 года назад
Hi sir, Thank you for the video. It's very informative, Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked? If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.
@burhansaifi1588
@burhansaifi1588 5 лет назад
Nice
@SoumyarshiDas
@SoumyarshiDas 5 лет назад
Your videos are awesome.
Далее
How to Use Macro in Excel in Hindi
15:50
Просмотров 1,5 млн
🫢 #tiktok #elsarca
00:11
Просмотров 4,4 млн
Паук
01:01
Просмотров 2,8 млн
MS Excel - Pivot Table Slice
9:38
Просмотров 406 тыс.
🫢 #tiktok #elsarca
00:11
Просмотров 4,4 млн