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

  Рет қаралды 194,338

Deepak EduWorld

Deepak EduWorld

Күн бұрын

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

Пікірлер: 226
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
@asimkhankolalai9024
@asimkhankolalai9024 6 ай бұрын
ولساپ نمبر بھیجو بھائی
@shivapadul1983
@shivapadul1983 Жыл бұрын
थँक्यू सो मच मै जो ढूंढ रहा था वो आपके पास बरोबर मिला
@thakarharish4705
@thakarharish4705 5 жыл бұрын
बहोत उपयोगी वीडियो लाते हैं थैंक्स सर
@bakbakhappy
@bakbakhappy 4 жыл бұрын
superb video..india's best youtube channel for learn excel and other
@nikhiltamrakar8076
@nikhiltamrakar8076 Жыл бұрын
AAp se behter koi nahi samjha sakta excel jai ho sir aap ki
@mehulmehta9382
@mehulmehta9382 3 жыл бұрын
apki teaching jordar he sirji!!!
@jeetubhatia841
@jeetubhatia841 5 жыл бұрын
Wah wah Itna mind Kahan se aata hai Powerful
@rakeshthombre
@rakeshthombre Жыл бұрын
Your video always useful to me sir
@danishtechonline9696
@danishtechonline9696 5 жыл бұрын
Super slicer sir. Thank you so much. Ur amazing ideas.
@SunilSingh-ee4sc
@SunilSingh-ee4sc 5 жыл бұрын
Thanks for sharing data also so that learner do practices also.
@s.hazratkazimi5
@s.hazratkazimi5 5 жыл бұрын
That's a very amazing trick Thank you so much Deepak Sir
@ramkailashyadav1022
@ramkailashyadav1022 5 жыл бұрын
Aapka samjhane ka tarika bhut achha hai sir thanks again please add some macros video or visual basic.
@amjadmkhan3383
@amjadmkhan3383 5 жыл бұрын
Like aap ki mehnat ke liye.thank
@uptoten4367
@uptoten4367 9 ай бұрын
Thank You Sir.. Very Helpful Video 🙏
@haryanviincanada7853
@haryanviincanada7853 3 жыл бұрын
Very helpful vedio sir .🙏🏼🙏🏼 Really it helped me to understand better.🙏🏼thanka again . Keep making this kind of vedios.
@Anikvikram
@Anikvikram 3 жыл бұрын
Superb as always
@basharatali9939
@basharatali9939 Жыл бұрын
Very useful trick's thanks.
@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.
@tridib-nagaon
@tridib-nagaon 5 ай бұрын
very informative and helpful video . thanks
@vijaytaneja8667
@vijaytaneja8667 5 жыл бұрын
Very very nice sir g
@mayannkchandavarckar1024
@mayannkchandavarckar1024 5 жыл бұрын
You are great Deepak! Thanking you for valuable information!
@sachithanandamyadav
@sachithanandamyadav 2 жыл бұрын
Thank you sir it is very helpful for me
@allaroundme9137
@allaroundme9137 Жыл бұрын
Nice tutorials
@basupallab91
@basupallab91 5 жыл бұрын
Awesome! Mind blowing! 😱😱👍👍👌👌
@Mr.SBV_92
@Mr.SBV_92 3 жыл бұрын
Thanks for sharing it Sir...👌
@ZahidKhan-gs6xy
@ZahidKhan-gs6xy 5 жыл бұрын
Waaaaa sir g ap best ho
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
Amazing tool sir ji thanks continue
@surajsingh-ns8xn
@surajsingh-ns8xn 2 жыл бұрын
Thank you sir, bina filter lagae subtotal formula kaam aega kya??
@ramnaslai2980
@ramnaslai2980 3 жыл бұрын
Great video
@biswajitkaran89
@biswajitkaran89 3 жыл бұрын
Amazing. Excellent brother.
@bheembheem-d2x
@bheembheem-d2x Ай бұрын
Namaste sir ji
@DeepakEduWorld
@DeepakEduWorld Ай бұрын
Namaste g 🙏
@pradeepkumarkanhar3128
@pradeepkumarkanhar3128 8 ай бұрын
Thanks very much sir 🙏
@rakibulhasan8592
@rakibulhasan8592 5 жыл бұрын
thanks for unknown things sharing, when i visit your channel, found interested things. thanks Again
@PuranKumarBhuwanta
@PuranKumarBhuwanta 2 жыл бұрын
Amazing video sir..
@yashpainter782
@yashpainter782 5 жыл бұрын
Nice formula keep it 👆 up
@henhenika2670
@henhenika2670 3 жыл бұрын
Very informative 👍
@jayshah7016
@jayshah7016 7 ай бұрын
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
@atulshah4234
@atulshah4234 5 жыл бұрын
Thanks, God bless you
@SonuKumar-fj9el
@SonuKumar-fj9el Жыл бұрын
Under slicer window 7 ya 10 main chal jayega ya nahi
@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...
@devanghirapara6657
@devanghirapara6657 5 жыл бұрын
It will be very helpful for me if it works in Google sheet also...
@vaishnavigandhi2327
@vaishnavigandhi2327 5 жыл бұрын
Nice sir God bless you
@ahsan29136
@ahsan29136 2 жыл бұрын
Ye kaam you filter se b hota hai... ✌
@naimshekh6717
@naimshekh6717 5 жыл бұрын
Thanks sir iske liye aapse bat karna tha
@venkannagoudkollu9466
@venkannagoudkollu9466 5 жыл бұрын
Excellent bro thank you
@Rameezraaz1
@Rameezraaz1 5 жыл бұрын
Super cool bro thank you
@pankajverma-sh2hb
@pankajverma-sh2hb 3 жыл бұрын
Great deepak
@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
@fpathan8091
@fpathan8091 8 ай бұрын
Excellent.
@SanjaySingh-eh2ln
@SanjaySingh-eh2ln 5 жыл бұрын
Superb video
@jeetendrasinghrajput5928
@jeetendrasinghrajput5928 5 жыл бұрын
Very good concepts and best ideas of things that
@banglatechhotspot2235
@banglatechhotspot2235 5 жыл бұрын
Nice tutorial.
@SoumyarshiDas
@SoumyarshiDas 5 жыл бұрын
Your videos are awesome.
@sureshv7724
@sureshv7724 3 жыл бұрын
Super ji.
@gcr78
@gcr78 2 жыл бұрын
Is this slicer option availability depend on excel version?
@TazeenAltafTaniTafi
@TazeenAltafTaniTafi 2 жыл бұрын
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
@UpcomingFojiJafarkhan
@UpcomingFojiJafarkhan 4 жыл бұрын
Thanks so much sir
@amitrana8147
@amitrana8147 3 жыл бұрын
Sir bina slicer ke ham dashboard or aise advance pivot table nhi bana skte kya plz reply sir❤️❤️❤️?
@dipakparab9048
@dipakparab9048 5 жыл бұрын
Nice very helpful
@ayushsumbhal3064
@ayushsumbhal3064 5 жыл бұрын
Very useful.... Great efforts.... Thank you so much sir
@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
@MeghaAnand0107
@MeghaAnand0107 4 жыл бұрын
Great thanks 👍👍
@english_corner_
@english_corner_ 4 жыл бұрын
Thnku so much
@vshddn
@vshddn 5 жыл бұрын
Really Amazing
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊
@abdullavazhayil4868
@abdullavazhayil4868 5 жыл бұрын
Great dear
@priyanka-hx3lo
@priyanka-hx3lo 3 жыл бұрын
Superb thnx
@sivasuribabu1471
@sivasuribabu1471 5 жыл бұрын
Thank you bro..
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊😊
@arindamdey7035
@arindamdey7035 5 жыл бұрын
Nice video...
@jasjeetsingh8861
@jasjeetsingh8861 5 жыл бұрын
Thanks for the useful information.
@salil8880
@salil8880 5 жыл бұрын
भाई साहब बहुत बढ़िया क्या यह एक्सेल 2007 में भी काम करता है
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
No
@sachintomar7377
@sachintomar7377 2 ай бұрын
gajab
@ca.aarchanajain6354
@ca.aarchanajain6354 5 жыл бұрын
amazing updates
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊😊👍
@AnkitPandey-yu1kw
@AnkitPandey-yu1kw 4 жыл бұрын
Very interesting video bhai I have only issue in use of dollar sign 💲 to freeze formula, specifically in vlookup.
@toufiqulla4909
@toufiqulla4909 2 жыл бұрын
Bro make one video. If we change the data then slicer will update that data automatically
@pratikshanimdeokar2462
@pratikshanimdeokar2462 5 жыл бұрын
Gazabbbbb....
@Deepakkumar-qs3hg
@Deepakkumar-qs3hg Жыл бұрын
thanku sir
@sujoydas5151
@sujoydas5151 5 жыл бұрын
Mind-blowing sir
@abang1101
@abang1101 5 жыл бұрын
Thanks sir ji
@refreshingrelaxingkey9889
@refreshingrelaxingkey9889 Жыл бұрын
Will This slicer work in Google sheet
@acousticlove1986
@acousticlove1986 5 жыл бұрын
nice sir.
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊
@chiranjitrouth7865
@chiranjitrouth7865 5 жыл бұрын
U r grt sir
@shankarh6310
@shankarh6310 5 жыл бұрын
NICE BHAI
@adnanrana7565
@adnanrana7565 4 жыл бұрын
Wonderful
@Brijesh_Bhardwaj_Fitness
@Brijesh_Bhardwaj_Fitness 5 жыл бұрын
Awesome
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊♥️
@Historyofbharatbabulalpareek
@Historyofbharatbabulalpareek 5 жыл бұрын
Nice video Thinks sar
@sidhartk1856
@sidhartk1856 5 жыл бұрын
Wow. Slicer
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
😊
@sindhpunjab778
@sindhpunjab778 4 жыл бұрын
very good
@amyjain97
@amyjain97 3 жыл бұрын
Hi Deepak. How do we use Sumifs or countifs in a single slicer with multiple selection in a slicer
@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
@basitbhatti2312
@basitbhatti2312 2 жыл бұрын
Dear sir, You applied the slicer on Column,can we apply on the ROW also.
@gufranali4562
@gufranali4562 5 жыл бұрын
Sir is me macro kaise lagaye please help
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
Kya karna hai macro se???
@gufranali4562
@gufranali4562 5 жыл бұрын
@@DeepakEduWorld mene ek data banye hai or ek bill jisme se mujko data serial no. Ke hesab se data ko celected cells me data ko Lana hai
@gufranali4562
@gufranali4562 5 жыл бұрын
@@DeepakEduWorld aap apka WhatsApp number send kero me image bhejta Hu please help
@FarahVision
@FarahVision 5 жыл бұрын
Amazing trick
@shafkathussain4243
@shafkathussain4243 3 жыл бұрын
How to make group of slicer and how to join with the same data table .plz bro
@teckhindi8291
@teckhindi8291 5 жыл бұрын
Namaste sir ji Sir ji ...Ek sheet mai school k 100 bachcho k row wise marks k record h...Subject wise... Ab mai ye poochna chahta hu..K kisi ek bachche ka record delete karne per joh marks ka total sum formula laga k show kar rakha tha...Voh automatically adjust kese hoga. matlab jis bachche ka record delete kar diya h..Toh uske marks ....Total marks mai se automatically less ho jaaye... Sum ka formula dubara na lagana pade Kya esa ho sakta h...
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
Wo toh apne aap hi ho jana hai.. Jab aap row delete hi kr doge toh
@heerasingh3130
@heerasingh3130 5 жыл бұрын
Hi, can you help me to recover a column which was deleted by mistake from my excel file .
@dheeraj2713
@dheeraj2713 2 жыл бұрын
Old version me nhi hai kya slicer function
@yasirishaq9968
@yasirishaq9968 5 жыл бұрын
Amazing Bro
@umeshchandarana8415
@umeshchandarana8415 3 жыл бұрын
Best.
@ajitbaghel1968
@ajitbaghel1968 Жыл бұрын
Super
@user-ravi708
@user-ravi708 3 жыл бұрын
Sir slicer hatane ke liye keyboard se kon si key dabani hai
You Don't Know ! Proper Use of PIVOT TABLE in Excel - Pivot Table Tutorial
38:46
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 16 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
Каха и дочка
00:28
К-Media
Рет қаралды 3,4 МЛН
Most Authenticated GATE 2025 Exam Analysis | CS & IT | Key Insights Revealed
3:04:42
🤓 How To Do Office Work in Excel 👉 Work Smarter & Faster || in Hindi
33:01
Advance 🔥 Filter in EXCEL | Excel Interview | MS Excel [Hindi]
12:12
Microsoft Excel Tutorial -  Beginners Level 1
32:49
Teacher's Tech
Рет қаралды 13 МЛН
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,8 МЛН
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН