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

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

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@asimkhankolalai9024]

ولساپ نمبر بھیجو بھائی

[@SunilSingh-ee4sc]

Thanks for sharing data also so that learner do practices also.

[@ramkailashyadav1022]

Aapka samjhane ka tarika bhut achha hai sir thanks again please add some macros video or visual basic.

[@s.hazratkazimi5]

That's a very amazing trick Thank you so much Deepak Sir

[@danishtechonline9696]

Super slicer sir. Thank you so much. Ur amazing ideas.

[@uptoten4367]

Thank You Sir.. Very Helpful Video 🙏

[@GulshanKumar-wx4wt]

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.

[@jeetubhatia841]

Wah wah Itna mind Kahan se aata hai Powerful

[@bakbakhappy]

superb video..india's best youtube channel for learn excel and other

[@haryanviincanada7853]

Very helpful vedio sir .🙏🏼🙏🏼 Really it helped me to understand better.🙏🏼thanka again . Keep making this kind of vedios.

[@thakarharish4705]

बहोत उपयोगी वीडियो लाते हैं थैंक्स सर

[@devanghirapara6657]

It will be very helpful for me if it works in Google sheet also...

[@mayannkchandavarckar1024]

You are great Deepak! Thanking you for valuable information!

[@rakibulhasan8592]

thanks for unknown things sharing, when i visit your channel, found interested things. thanks Again

[@rakeshthombre]

Your video always useful to me sir

[@tridib-nagaon]

very informative and helpful video . thanks

[@AnkitPandey-yu1kw]

Very interesting video bhai I have only issue in use of dollar sign 💲 to freeze formula, specifically in vlookup.

[@shivapadul1983]

थँक्यू सो मच मै जो ढूंढ रहा था वो आपके पास बरोबर मिला

[@nikhiltamrakar8076]

AAp se behter koi nahi samjha sakta excel jai ho sir aap ki

[@basharatali9939]

Very useful trick's thanks.

[@mehulmehta9382]

apki teaching jordar he sirji!!!

[@sachithanandamyadav]

Thank you sir it is very helpful for me

[@amjadmkhan3383]

Like aap ki mehnat ke liye.thank

[@refreshingrelaxingkey9889]

Will This slicer work in Google sheet

[@LalGebi]

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]

Yss.. Please wait.. I will another video shortly

[@atulshah4234]

Thanks, God bless you

[@amitrana8147]

Sir bina slicer ke ham dashboard or aise advance pivot table nhi bana skte kya plz reply sir❤️❤️❤️?

[@rizwandanish3308]

This was helpful

[@allaroundme9137]

Nice tutorials

[@pradeepkumarkanhar3128]

Thanks very much sir 🙏

[@tabrezsiddiqui5411]

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]

G sure...

[@henhenika2670]

Very informative 👍

[@vaishnavigandhi2327]

Nice sir God bless you

[@biswajitkaran89]

Amazing. Excellent brother.

[@Mr.SBV_92]

Thanks for sharing it Sir...👌

[@jeetendrasinghrajput5928]

Very good concepts and best ideas of things that

[@Anikvikram]

Superb as always

[@ramnaslai2980]

Great video

[@yashpainter782]

Nice formula keep it 👆 up

[@arunkumarsinghark3024]

Amazing tool sir ji thanks continue

[@ayushsumbhal3064]

Very useful.... Great efforts.... Thank you so much sir

[@venkannagoudkollu9466]

Excellent bro thank you

[@basupallab91]

Awesome! Mind blowing! 😱😱👍👍👌👌

[@salil8880]

भाई साहब बहुत बढ़िया क्या यह एक्सेल 2007 में भी काम करता है

[@DeepakEduWorld]

No

[@banglatechhotspot2235]

Nice tutorial.

[@amyjain97]

Hi Deepak. How do we use Sumifs or countifs in a single slicer with multiple selection in a slicer

[@laxmimodi3252]

Thank you Sir ❤🙏

[@vijaytaneja8667]

Very very nice sir g

[@surajsingh-ns8xn]

Thank you sir, bina filter lagae subtotal formula kaam aega kya??

[@gcr78]

Is this slicer option availability depend on excel version?

[@PuranKumarBhuwanta]

Amazing video sir..

[@jayshah7016]

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

[@Rameezraaz1]

Super cool bro thank you

[@naimshekh6717]

Thanks sir iske liye aapse bat karna tha

[@fpathan8091]

Excellent.

[@dipakparab9048]

Nice very helpful

[@SonuKumar-fj9el]

Under slicer window 7 ya 10 main chal jayega ya nahi

[@asadmahboob1123]

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.

[@jasjeetsingh8861]

Thanks for the useful information.

[@ZahidKhan-gs6xy]

Waaaaa sir g ap best ho

[@SoumyarshiDas]

Your videos are awesome.

[@ahsan29136]

Ye kaam you filter se b hota hai... ✌

[@sheetalkukreja2744]

Pls upload videos for sql..

[@basitbhatti2312]

Dear sir, You applied the slicer on Column,can we apply on the ROW also.

[@SanjaySingh-eh2ln]

Superb video

[@gopalkaushik4974]

Great

[@heerasingh3130]

Hi, can you help me to recover a column which was deleted by mistake from my excel file .

[@toufiqulla4909]

Bro make one video. If we change the data then slicer will update that data automatically

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@abang1101]

Thanks sir ji

[@directmessage4680]

Very well explained

[@AnujSharma-hv8ji]

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]

No

[@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

[@priyanka-hx3lo]

Superb thnx

[@shafkathussain4243]

How to make group of slicer and how to join with the same data table .plz bro

[@pankajverma-sh2hb]

Great deepak

[@abdullavazhayil4868]

Great dear

[@vshddn]

Really Amazing

[@DeepakEduWorld]

😊

[@satishmen11]

Very nice tutorial. One question how do I hide the other items which are not highlighted. I do not want to list all the items.

[@DeepakEduWorld]

Ok dear.. I m publishing another video shortly

[@dipikasarkar3537]

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

[@rahulsingh3176]

Thank you sir

[@arindamdey7035]

Nice video...

[@naatenabi2951]

very informative only small change needed ... spelling of company is wrong

[@supriyabhattacharya5089]

Very good

[@sivasuribabu1471]

Thank you bro..

[@DeepakEduWorld]

😊😊

[@sureshv7724]

Super ji.

[@adnanrana7565]

Wonderful

[@pratikshanimdeokar2462]

Gazabbbbb....

[@sujoydas5151]

Mind-blowing sir

[@acousticlove1986]

nice sir.

[@DeepakEduWorld]

😊

[@teckhindi8291]

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]

Wo toh apne aap hi ho jana hai.. Jab aap row delete hi kr doge toh

[@wasimjahangir9652]

Mr. Deepak Huge data me Bina column index no. Jane. Kaise value nikale?

[@DeepakEduWorld]

Uske liye fir nested formulas lagane padange.. Vlookup index.. Vgera

[@ca.aarchanajain6354]

amazing updates

[@DeepakEduWorld]

😊😊👍

[@jyotishukla1207]

Report connection me 2nd pivot table show nhi ho rahi, what should I do, please help.

[@komalverma9083]

Sir ji aap koun se ye version ka excel use karte ho

[@DeepakEduWorld]

2010 2013

[@shankarh6310]

NICE BHAI

[@anilkumar-pf6vx]

Hello Deepak Ji...Is there any option to salect 2 name (Like INDIA+US) in single slicer?

[@DeepakEduWorld]

Ys .. you can select multiple options in slicers... In country slicer you can click on india and us

[@anilkumar-pf6vx]

@@DeepakEduWorld Thanks for your reply..However request to make a video on Condition formatting where we can highlight coloumn value in accending/decending order ..minimum 7 to 8 value(All value should be in diffrent colour)if the same is already available at your chennal ..pls share the link..

[@Deepakkumar-qs3hg]

thanku sir

[@chiranjitrouth7865]

U r grt sir

[@ajitbaghel1968]

Super