Тёмный

Filter vs Slicer | Pivot Table Slicer and Timeline | Using Excel Slicers to Filter Data 

Innozant
Подписаться 149 тыс.
Просмотров 84 тыс.
50% 1

Learn and know the difference between Normal Range, Table and Pivot Table data
1. Filter vs Slicer in excel
2. Difference between Normal Range ,Table to make the data dynamic
3, Use of Slicer on Table and Pivot Table
4. Use of Slicers and Timeline for Date to make daily report , weekly report , monthly report , Quarterly report and yearly repot
Download the Practice Workbook Direct Link
drive.google.com/file/d/1hwjq...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#slicerinexcel #pivottable#Innozant #timelineinexcel #slicerandtimelineexcel

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

 

23 сен 2020

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 189   
@pushkarsinghbishtuk437
@pushkarsinghbishtuk437 9 месяцев назад
Thank you so much sir. You are spreading very amazing your best knowledge 👏👏👏
@anirbansarkar6306
@anirbansarkar6306 Год назад
These are really great-quality videos. Cleared my doubts. Thank you so much
@Innozant
@Innozant Год назад
Thanks Anirban
@AMITKUMAR-vo8bz
@AMITKUMAR-vo8bz 2 года назад
Superb Superb use of Slicer, timeline, pivot & table
@dharmendrakushwah968
@dharmendrakushwah968 2 месяца назад
बेहतरीन उदाहरण के साथ समझाया गया है
@user-rm4cg2zn6x
@user-rm4cg2zn6x 3 месяца назад
Good morning Sir, kya karishma dekhya bahut khubsurat hai, Excel Pivot Table Course. Very Nice.
@newsee2540
@newsee2540 5 месяцев назад
No words Sir to explain the method!
@SonurajUK
@SonurajUK 9 месяцев назад
Extremely Thanks 🙏 for uploading this valuable vedio
@bsatish2007
@bsatish2007 2 года назад
Thank u for videos with simple explanation & Indian language…It’s awesome keep rocking…
@Innozant
@Innozant 2 года назад
Thanks Satish Ji❤️
@Zaid1869
@Zaid1869 15 дней назад
Great Explanation sir.
@shrikantbadge3978
@shrikantbadge3978 3 года назад
Hello Dipak Sir. Just had a casual talk with my manager. Being a team lead I have made my colleagues subscribe your channel first and then commence working because we are gonna need a lot of excel knowledge which can be found at one place and that is The Innozant Channel. Special thanks Sir for previous videos. Because the way you have taught excel cannot be found anywhere on you tube. 🙏 Grateful. In my life, the excel learning credit goes to you only.
@Innozant
@Innozant 3 года назад
Srikant i am very grateful for this moment it seems like you are very much impressed with my work which means a lot to me although i might have a chance to believe in fate after seeing your responses 😀 now after seeing all you respo ses i feel like i am doing a very good job thanks srikant i love you all for being by my side
@devangmehta7087
@devangmehta7087 2 года назад
Superb Amazing Topic Very Useful your RU-vid video Thank you so much sir
@Innozant
@Innozant 2 года назад
Thanks dear ❤️
@piyushdutta553
@piyushdutta553 3 года назад
Sir thanks is video ke liye its so usefull and sabse aacha apka samajne ka tarika
@Innozant
@Innozant 3 года назад
Thanks Piyush ji .Happy learning dear
@harishpandey168
@harishpandey168 3 года назад
You are superb sir... I m feeling great career with your videos🤗🤗
@Innozant
@Innozant 3 года назад
Thanks Pandey ji..Happy learning dear ❤🙏
@user-mz1bg6qv3r
@user-mz1bg6qv3r Год назад
i am going to ask my colleagues to subscribe to this channel. very informatiive. would appreciate if you could answer the below question
@brijeshshah1348
@brijeshshah1348 3 года назад
Superb !! Thanks a lot for the shared knowledge. 🙏😊
@Innozant
@Innozant 3 года назад
Thanks Brijesh ji
@sandeepaswal8944
@sandeepaswal8944 3 года назад
Sir Wow Excellent You are the Best You always. You also have a very nice voice! I think the content is good, too, I give you the thumbs up for your visual representation.
@Innozant
@Innozant 3 года назад
Thanks dear Sandeep for lovely appreciation.♥️🙏🙂
@nawazsharif5085
@nawazsharif5085 Год назад
Supreme knowledge 🙏💕
@ajendratiwari2039
@ajendratiwari2039 Год назад
Sir fantastic explanation
@user-hz7qx2ns5w
@user-hz7qx2ns5w 2 года назад
amazing video sir your video is very Knowledgeable 👍👍👍👍👍
@Innozant
@Innozant 2 года назад
Thanks dear ❤️
@ractonfire2030
@ractonfire2030 2 года назад
Sir your teaching style is awesome
@Innozant
@Innozant 2 года назад
Thanks Vivek Ji MmGod bless You
@pramodbhavsar4488
@pramodbhavsar4488 3 года назад
Sir very nice use of slicer & timeline in excel thank you
@Innozant
@Innozant 3 года назад
Thanks Pramod ji,Hope you like the video.Have a nice day.tc
@amitdhiman7307
@amitdhiman7307 2 года назад
You are awesome sir 👍👍
@ifbreports2860
@ifbreports2860 2 года назад
Hello Sir! I have a question here by using single timeline slicer can we check the week wise comparative sales of two different year of a same month. in s single pivot
@balmikiparasdgupta614
@balmikiparasdgupta614 2 года назад
Great sir thank you
@kasafkhanpathan4936
@kasafkhanpathan4936 2 года назад
Keep doing this👍🏼🙏🏻
@Adeeluddin06
@Adeeluddin06 2 года назад
He has great knowledge.
@Innozant
@Innozant 2 года назад
Thanks dear ❤️
@user-mz1bg6qv3r
@user-mz1bg6qv3r Год назад
Thanks, what do i need to do in order to add the week in the timeline slicer?
@shiashots110
@shiashots110 3 года назад
Thank you!
@bhoopendraraghav9781
@bhoopendraraghav9781 3 года назад
What an energy hat's of u sir...
@Innozant
@Innozant 3 года назад
Thanks Bhoopi..God bless you dear🙂
@sevaknikunj233
@sevaknikunj233 2 года назад
I learned from your vedios on excel, jay ho
@Innozant
@Innozant 2 года назад
👍❤️
@tahimahmed7436
@tahimahmed7436 3 года назад
Wonderful presentation.
@Innozant
@Innozant 3 года назад
Thanks Tahim❤️🙏
@devokedevtech2750
@devokedevtech2750 3 года назад
Very helpful video ☺️👍
@Innozant
@Innozant 3 года назад
Thnks Dheeraj.Good Morning.Hv a nice day
@learningNewIdea
@learningNewIdea 3 года назад
Super se bhi uper thanks for information 😘😘😘
@Innozant
@Innozant 3 года назад
Thanks dear Dhananjay ji🙏❤️
@stressfreerelaxation3841
@stressfreerelaxation3841 2 года назад
I was thinking of same. Thanks
@Innozant
@Innozant 2 года назад
Ok..Thats good 👍❤️
@headtakergamerz1394
@headtakergamerz1394 3 года назад
All the video is very good sir
@Innozant
@Innozant 3 года назад
Thanks Manish Ji for such a valuable feedback..Happy Learning dear.
@rammanohar1289
@rammanohar1289 2 года назад
sir mujhe 1500 ke karib isssued material calculate karni hai ha to kya use hoga, jaise mere pas 1500 material h ek saath unke name wise total
@saritabisht8707
@saritabisht8707 2 года назад
Kay timeline slicer ko 1-apr-2021 ko ist qtr se start kar sakte hai
@rumiurmi4863
@rumiurmi4863 2 года назад
Thanks for guiding us but I am facing one problem after updating data values are not able to change in pivot table plz guide me
@kinghundred
@kinghundred 3 года назад
very useful sir
@joybanerjee5168
@joybanerjee5168 2 года назад
Awesome superb
@banikinkardas8974
@banikinkardas8974 Год назад
good tutorial
@BankerWriterMosharaf
@BankerWriterMosharaf Год назад
Subscribed Bro.....One question: Is it possible to keep the slicer static while scrolling down on the data?
@ArshadAli07.kapilvastu
@ArshadAli07.kapilvastu 3 года назад
Great job Bhaiya
@Innozant
@Innozant 3 года назад
Thanks Arshad Sahab🙏♥️
@nalinas2715
@nalinas2715 2 года назад
sir u r ultimate
@Innozant
@Innozant 2 года назад
Thanks Nalina..God bless you dear❤️
@meditationmusic6482
@meditationmusic6482 3 года назад
Sir ji very good video.
@Innozant
@Innozant 3 года назад
Thanks sanoj❤️🙏
@neelamchand5743
@neelamchand5743 2 года назад
Very nice video sir
@Innozant
@Innozant 2 года назад
Thanks Neelam..Keep learning ❤️
@TheSphooljaan
@TheSphooljaan 2 года назад
Excellent
@jeshingvadher2053
@jeshingvadher2053 Год назад
greatful.
@Altaf_Alam
@Altaf_Alam Год назад
Good morning sir 😊
@hemgandhi8087
@hemgandhi8087 2 года назад
Thankx🙏
@yogeshpimple2860
@yogeshpimple2860 Год назад
Outstanding
@rajeshjoshi8895
@rajeshjoshi8895 11 месяцев назад
Thanks sir
@Ashutosh1986
@Ashutosh1986 2 года назад
Awesome! your videos are best Excel videos on RU-vid. The reason is that even a kid can learn Excel very easily by watching your videos...keep spreading your knowledge bro and a big salute to you..:)
@Innozant
@Innozant 2 года назад
Thanks dear for being part of Innozant family.Hope these videos are helpful.Happy learning
@rakeshranjan7525
@rakeshranjan7525 3 года назад
Nice, sir thank you🙏
@Innozant
@Innozant 3 года назад
🙏❤️❤️
@gauravsemwal2246
@gauravsemwal2246 Год назад
SIR Showing data connection error while APPLYING the time line FILTER please help sir to resolve this issue.
@truepearl9334
@truepearl9334 Год назад
Amazing
@sunitijha1107
@sunitijha1107 Год назад
Superb
@sawaimalhi8439
@sawaimalhi8439 3 года назад
very nice sir and happy holi
@Innozant
@Innozant 3 года назад
Thanks dear
@RohitKumar-cc7zi
@RohitKumar-cc7zi 3 года назад
I give you five star out of five, Brilient
@Innozant
@Innozant 3 года назад
Thanks Rohit..Really means a lot to me
@swapnilshukla7735
@swapnilshukla7735 2 года назад
Dear Sir, How to apply in pivot table filter area by copying a list ? Please Suggest Solution. Thanks swapnil
@siyarullah2944
@siyarullah2944 10 месяцев назад
Salaam Sir in Design there is no slicer option what to do?
@bishtlokesh1297
@bishtlokesh1297 3 года назад
Very well sir ji🙏
@Innozant
@Innozant 3 года назад
Thanks Lokesh
@rashidabbasi679
@rashidabbasi679 Год назад
but not filter for week wise report week wise report not showing sir
@tourandentertainment6847
@tourandentertainment6847 2 года назад
How to get data with select perticular or all data in slicer
@sumantabhuin7433
@sumantabhuin7433 Год назад
sirji pivot table main vertical line kaise add kar sakte hai ? kuch solution bataiye pls
@surajrawat3485
@surajrawat3485 2 года назад
Thanku sir 💗
@Innozant
@Innozant 2 года назад
Thanks Suraj
@SURENDER872
@SURENDER872 10 месяцев назад
Sir mere Excel me slicer hide kisliye hote he
@anilnahar6292
@anilnahar6292 3 года назад
Nice presentation
@Innozant
@Innozant 3 года назад
Thanks dear
@mudasserjunaid8060
@mudasserjunaid8060 Год назад
bhai hmen tou apka smiley face k sth smjana psnd 🙂
@Innozant
@Innozant Год назад
Thanks dear😊❤️
@narayanlohar204
@narayanlohar204 3 года назад
Great 👌 sir g
@Innozant
@Innozant 3 года назад
Thanks Narayan,Hope you like and learn from there
@LifestyleCanvas15
@LifestyleCanvas15 Год назад
Sir, the channel and your labour is awesome . Please help me, I want to learn PIVOT table from the beginning.
@Innozant
@Innozant Год назад
Thanks.Kindly find pivot table playlist.in sequence video are there
@jotarojoestar23
@jotarojoestar23 5 дней назад
At 7:06 slicer wax chosen for Central and two Agents. Branch data is not shwing Central.
@AmitVerma-uy3uo
@AmitVerma-uy3uo 27 дней назад
Sir 1 small Issues:- in Timeline How to change the Quarter No. From Calendar year to FY year
@ajaynirmal3150
@ajaynirmal3150 Год назад
Dear sir, Please tell how to make financial year timeline instead of calendar year. 🙏
@meriawaazhindi5217
@meriawaazhindi5217 Год назад
❤️❤️❤️❤️
@manjit.sarania
@manjit.sarania 6 месяцев назад
Ok sir
@rajeshrawat5172
@rajeshrawat5172 3 года назад
Bhut khub sir
@Innozant
@Innozant 3 года назад
Thanls Rajesh Rawat sahab.Happy Learning dear..
@rajeshrawat5172
@rajeshrawat5172 3 года назад
@@Innozant yes sir
@rajeshrawat5172
@rajeshrawat5172 3 года назад
sir ek question h ap se sir agar hum word se koi data excel mein lejate h to wo na to colum mein puri trh ata h na hi row menin puri trh to kese ho payega plz reply me sir thank
@jaiKumar-sx9xv
@jaiKumar-sx9xv Год назад
🙏🙏
@RAJKUMAR-dv6pf
@RAJKUMAR-dv6pf 3 года назад
Sir, Ham jab pivot table banate hey aur Quarterly report banate hey to pivot table me data First qtr Jan to Mar deta hey lekin hame April to June First Qtr chahiye hota hey to sir kaise hoga
@Innozant
@Innozant 3 года назад
Custom list me jake pehle list create kar lijiye april to march..table me ek extra column add kijiye month as helper column ab whana formula =month(datecolumnfield) aut data sort based on custom list created.now make pivot as per your requirement Ek baar aap custom sort ka video dekh lijiye sorting playlist me se
@TrendingMuzic25
@TrendingMuzic25 Год назад
Filter connection kaiseenable kare filter main
@kpandu1980
@kpandu1980 3 года назад
Excellent video, in time line can we use customized date instead of calendar date
@Innozant
@Innozant 3 года назад
Customized date like.?daily momthly quarterly and yeay report are there but in case of customized date like weekwise report or 15 days report we need to group the dataset first .
@rjraviraftarup7553
@rjraviraftarup7553 3 года назад
👍👍👍👍👍👍 ⭐⭐⭐⭐⭐⭐
@satishojha6240
@satishojha6240 3 года назад
Nice video sir. kal kaha they aap video nahi ayaa tha kal.I wish aap thik hogaye.Good night sir
@Innozant
@Innozant 3 года назад
Good Morning Satish ji,Internet issuetbhi upload nhi kr paye the.Thanms for your concern dear.
@aakashshah5733
@aakashshah5733 3 года назад
Mere table me date he and format bhi date ka hi he.. Fir bhi mujhe error de raha he ki " Field formatted as date nahi he". Meine format bhi kar k dekha date ko.. So kya reason ho sakta he timeline nahi create hone ka sir??
@Innozant
@Innozant 3 года назад
Dear date gormat hi galag hai..aap custon me jaake date format krke dekhiye .saath hi kahin aaka date text format me the nhi hai .checi it again. Wrong date h thats why this eeror. Numbervalue function pass krke dekhiye us date ke liye kya wo datevalue ban ra hai ya nahi .if not format your date
@gargibhattacheryya4386
@gargibhattacheryya4386 Год назад
Can we get live data to practice
@Innozant
@Innozant Год назад
Yes ..kindly find link to download the practice file in video description
@shrikantbadge3978
@shrikantbadge3978 6 месяцев назад
सर इस साल प्लीज कुच हटके सिरीज बनाईये. Like जटाजी
@tourandentertainment6847
@tourandentertainment6847 2 года назад
Example HR and Admin Department count in single Tab. HR Admin Both
@Innozant
@Innozant 2 года назад
Didnte get your query
@tourandentertainment6847
@tourandentertainment6847 2 года назад
I have 4 zone i can show data by each zone using of slicer. How can I get all zone total in one click Example North, East, West, South & All Zone Total
@GoQuick100
@GoQuick100 2 года назад
गुरुजी मेरा windows 7 क्या उसमे MS OFFICE 365 अथवा MS OFFICE 2019 सपोर्ट होगा कृपया करके जल्द से जल्द उत्तर देने की आशा करता हुं ।🙏
@Innozant
@Innozant 2 года назад
Nhi Suraj office 365 subscription based office version hai
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Good
@Innozant
@Innozant 3 года назад
Thanks Gaurav...♥️👍🙏
@artiverma2357
@artiverma2357 3 года назад
Apko kese aata hai ye sb SQL shikhna ho to sir .?
@tarjitmalka3978
@tarjitmalka3978 3 года назад
⭐⭐⭐⭐⭐
@VedPrakash-bh7vw
@VedPrakash-bh7vw 3 года назад
Sir, Mere me slicer hilight nhi ho raha please guide
@Innozant
@Innozant 3 года назад
Kaunsa version use kar re h
@surajithyit
@surajithyit Год назад
Weekly mey timeline karke dikhaiye..
@rjraviraftarup7553
@rjraviraftarup7553 3 года назад
Mast hai 👌👌
@shubhi1694
@shubhi1694 3 года назад
Sir Slicer kon si Window mein hai?? ...main Window 7 use karti hun....per usmein Slicer nahi hai...
@Innozant
@Innozant 3 года назад
Hi Shubhi,Slicer is available in latwst version of excel dear e.g office 2013 ,16 etc.. why not you update with latest version as there are lots of new functions are there
@shubhi1694
@shubhi1694 3 года назад
@@Innozant Ok Sir ..thankyou Sir 2010 mein hoga????
@Innozant
@Innozant 3 года назад
Lates version install kar lijiye tention free phir❤👍
@SaurabhSharma-ry8iz
@SaurabhSharma-ry8iz 2 года назад
Awesome video sir But sir excel 2007 me ho jayega kya Please reply soon....
@Innozant
@Innozant 2 года назад
Update kriye ab tum excel new version 🙂Thanks ..Attempt karke dekhiye usme
@SaurabhSharma-ry8iz
@SaurabhSharma-ry8iz 2 года назад
Ok sir
@nishikantanayak372
@nishikantanayak372 3 года назад
Sir clicer show nehi ho raha hai laptop main
@Innozant
@Innozant 3 года назад
Pivot table jo create kiya hai uske upar active cursor rakhiye phir analize tab me dekhiye..slicer aur timeline mil jayega apkoo wahin
@shortsshorts4719
@shortsshorts4719 3 года назад
6:44 sir data main branch center to show hi nhi ho rahi data main...
@Innozant
@Innozant 3 года назад
kya issue dear..acha dekhta hu kya miss hua .
@shortsshorts4719
@shortsshorts4719 3 года назад
@@Innozant sir seriously apki video ki baat hi alag h next level explain karte ho aap 🙏🙏🔥
@sameerwagh409
@sameerwagh409 2 года назад
I want to send email with slicer how it possible
@Innozant
@Innozant 2 года назад
@innozantofficial telegram id par send kriye query
@tarjitmalka3978
@tarjitmalka3978 3 года назад
sir ek vedio items nd field ki bna do jisme hm bina colums k colm add kr skte hai.
@Innozant
@Innozant 3 года назад
Tarjit sahab wo next video aayega..field item and sets
Далее
СДЕЛАЛА БРЕКЕТЫ ДОМА
01:01
Просмотров 1,3 млн
This is how I ACTUALLY analyze data using Excel
24:05
MS Excel - Pivot Table Slice
9:38
Просмотров 399 тыс.
СДЕЛАЛА БРЕКЕТЫ ДОМА
01:01
Просмотров 1,3 млн