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

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.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#slicerinexcel #pivottable#Innozant #timelineinexcel #slicerandtimelineexcel

[@anirbansarkar6306]

These are really great-quality videos. Cleared my doubts. Thank you so much

[@Innozant]

Thanks Anirban

[@dharmendrakushwah968]

बेहतरीन उदाहरण के साथ समझाया गया है

[@shrikantbadge3978]

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]

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

[@user-rm4cg2zn6x]

Good morning Sir, kya karishma dekhya bahut khubsurat hai, Excel Pivot Table Course. Very Nice.

[@Zaid1869]

Great Explanation sir.

[@newsee2540]

No words Sir to explain the method!

[@pushkarsinghbishtuk437]

Thank you so much sir. You are spreading very amazing your best knowledge 👏👏👏

[@AMITKUMAR-vo8bz]

Superb Superb use of Slicer, timeline, pivot & table

[@piyushdutta553]

Sir thanks is video ke liye its so usefull and sabse aacha apka samajne ka tarika

[@Innozant]

Thanks Piyush ji .Happy learning dear

[@sevaknikunj233]

I learned from your vedios on excel, jay ho

[@Innozant]

👍❤️

[@bsatish2007]

Thank u for videos with simple explanation & Indian language…It’s awesome keep rocking…

[@Innozant]

Thanks Satish Ji❤️

[@SonurajUK]

Extremely Thanks 🙏 for uploading this valuable vedio

[@devangmehta7087]

Superb Amazing Topic
Very Useful your TH-cam video
Thank you so much sir

[@Innozant]

Thanks dear ❤️

[@ractonfire2030]

Sir your teaching style is awesome

[@Innozant]

Thanks Vivek Ji MmGod bless You

[@harishpandey168]

You are superb sir...
I m feeling great career with your videos🤗🤗

[@Innozant]

Thanks Pandey ji..Happy learning dear ❤🙏

[@sandeepaswal8944]

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]

Thanks dear Sandeep for lovely appreciation.♥️🙏🙂

[@JitendraKumar-gp4do]

Very nice sir❤

[@nawazsharif5085]

Supreme knowledge 🙏💕

[@user-hz7qx2ns5w]

amazing video sir your video is very Knowledgeable 👍👍👍👍👍

[@Innozant]

Thanks dear ❤️

[@headtakergamerz1394]

All the video is very good sir

[@Innozant]

Thanks Manish Ji for such a valuable feedback..Happy Learning dear.

[@Adeeluddin06]

He has great knowledge.

[@Innozant]

Thanks dear ❤️

[@ajendratiwari2039]

Sir fantastic explanation

[@pramodbhavsar4488]

Sir very nice use of slicer & timeline in excel thank you

[@Innozant]

Thanks Pramod ji,Hope you like the video.Have a nice day.tc

[@balmikiparasdgupta614]

Great sir thank you

[@bhoopendraraghav9781]

What an energy hat's of u sir...

[@Innozant]

Thanks Bhoopi..God bless you dear🙂

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

[@mudasserjunaid8060]

bhai hmen tou apka smiley face k sth smjana psnd 🙂

[@Innozant]

Thanks dear😊❤️

[@brijeshshah1348]

Superb !! Thanks a lot for the shared knowledge. 🙏😊

[@Innozant]

Thanks Brijesh ji

[@stressfreerelaxation3841]

I was thinking of same. Thanks

[@Innozant]

Ok..Thats good 👍❤️

[@meditationmusic6482]

Sir ji very good video.

[@Innozant]

Thanks sanoj❤️🙏

[@Altaf_Alam]

Good morning sir 😊

[@amitdhiman7307]

You are awesome sir 👍👍

[@neelamchand5743]

Very nice video sir

[@Innozant]

Thanks Neelam..Keep learning ❤️

[@nalinas2715]

sir u r ultimate

[@Innozant]

Thanks Nalina..God bless you dear❤️

[@learningNewIdea]

Super se bhi uper thanks for information 😘😘😘

[@Innozant]

Thanks dear Dhananjay ji🙏❤️

[@tourandentertainment6847]

Example HR and Admin Department count in single Tab.
HR
Admin
Both

[@Innozant]

Didnte get your query

[@tourandentertainment6847]

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

[@RohitKumar-cc7zi]

I give you five star out of five, Brilient

[@Innozant]

Thanks Rohit..Really means a lot to me

[@joybanerjee5168]

Awesome superb

[@banikinkardas8974]

good tutorial

[@ArshadAli07.kapilvastu]

Great job Bhaiya

[@Innozant]

Thanks Arshad Sahab🙏♥️

[@sawaimalhi8439]

very nice sir and happy holi

[@Innozant]

Thanks dear

[@kasafkhanpathan4936]

Keep doing this👍🏼🙏🏻

[@tahimahmed7436]

Wonderful presentation.

[@Innozant]

Thanks Tahim❤️🙏

[@TheSphooljaan]

Excellent

[@LifestyleCanvas15]

Sir, the channel and your labour is awesome . Please help me, I want to learn PIVOT table from the beginning.

[@Innozant]

Thanks.Kindly find pivot table playlist.in sequence video are there

[@kinghundred]

very useful sir

[@shiashots110]

Thank you!

[@yogeshpimple2860]

Outstanding

[@Ashutosh1986]

Awesome! your videos are best Excel videos on TH-cam. 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]

Thanks dear for being part of Innozant family.Hope these videos are helpful.Happy learning

[@devokedevtech2750]

Very helpful video ☺️👍

[@Innozant]

Thnks Dheeraj.Good Morning.Hv a nice day

[@jeshingvadher2053]

greatful.

[@rajeshrawat5172]

Bhut khub sir

[@Innozant]

Thanls Rajesh Rawat sahab.Happy Learning dear..

[@rajeshrawat5172]

@@Innozant yes sir

[@rajeshrawat5172]

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

[@sunitijha1107]

Superb

[@knplsrinagar6072]

Thanks sir

[@hemgandhi8087]

Thankx🙏

[@siyarullah2944]

Salaam Sir in Design there is no slicer option what to do?

[@bishtlokesh1297]

Very well sir ji🙏

[@Innozant]

Thanks Lokesh

[@jotarojoestar23]

At 7:06 slicer wax chosen for Central and two Agents. Branch data is not shwing Central.

[@satishojha6240]

Nice video sir. kal kaha they aap video nahi ayaa tha kal.I wish aap thik hogaye.Good night sir

[@Innozant]

Good Morning Satish ji,Internet issuetbhi upload nhi kr paye the.Thanms for your concern dear.

[@rakeshranjan7525]

Nice, sir thank you🙏

[@Innozant]

🙏❤️❤️

[@truepearl9334]

Amazing

[@anilnahar6292]

Nice presentation

[@Innozant]

Thanks dear

[@surajrawat3485]

Thanku sir 💗

[@Innozant]

Thanks Suraj

[@gauravsemwal2246]

SIR Showing data connection error while APPLYING the time line FILTER please help sir to resolve this issue.

[@saritabisht8707]

Kay timeline slicer ko 1-apr-2021 ko ist qtr se start kar sakte hai

[@manjit.sarania]

Ok sir

[@AmitVerma-uy3uo]

Sir 1 small Issues:- in Timeline How to change the Quarter No. From Calendar year to FY year

[@narayanlohar204]

Great 👌 sir g

[@Innozant]

Thanks Narayan,Hope you like and learn from there

[@rammanohar1289]

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

[@shrikantbadge3978]

सर इस साल प्लीज कुच हटके सिरीज बनाईये. Like जटाजी

[@rashidabbasi679]

but not filter for week wise report
week wise report not showing sir

[@BankerWriterMosharaf]

Subscribed Bro.....One question: Is it possible to keep the slicer static while scrolling down on the data?

[@rumiurmi4863]

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

[@sumantabhuin7433]

sirji pivot table main vertical line kaise add kar sakte hai ? kuch solution bataiye pls

[@user-mz1bg6qv3r]

Thanks, what do i need to do in order to add the week in the timeline slicer?

[@SaurabhSharma-ry8iz]

Awesome video sir
But sir excel 2007 me ho jayega kya
Please reply soon....

[@Innozant]

Update kriye ab tum excel new version 🙂Thanks ..Attempt karke dekhiye usme

[@SaurabhSharma-ry8iz]

Ok sir

[@tourandentertainment6847]

How to get data with select perticular or all data in slicer

[@RAJKUMAR-dv6pf]

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]

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

[@SURENDER872]

Sir mere Excel me slicer hide kisliye hote he

[@aakashshah5733]

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]

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

[@TrendingMuzic25]

Filter connection kaiseenable kare filter main

[@gauravbhatia7987]

Good

[@Innozant]

Thanks Gaurav...♥️👍🙏

[@surajithyit]

Weekly mey timeline karke dikhaiye..

[@virendernegi7632]

First viewer 👍

[@Innozant]

Thanka Vidender.Happy Learning dear🙂❤

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@ifbreports2860]

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

[@shubhi1694]

Sir Slicer kon si Window mein hai?? ...main Window 7 use karti hun....per usmein Slicer nahi hai...

[@Innozant]

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]

@@Innozant Ok Sir ..thankyou
Sir 2010 mein hoga????

[@Innozant]

Lates version install kar lijiye tention free phir❤👍

[@GoQuick100]

गुरुजी मेरा windows 7 क्या उसमे MS OFFICE 365 अथवा MS OFFICE 2019 सपोर्ट होगा कृपया करके जल्द से जल्द उत्तर देने की आशा करता हुं ।🙏

[@Innozant]

Nhi Suraj office 365 subscription based office version hai

[@ajaynirmal3150]

Dear sir,
Please tell how to make financial year timeline instead of calendar year. 🙏

[@kpandu1980]

Excellent video, in time line can we use customized date instead of calendar date

[@Innozant]

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 .

[@sadashivkage3133]

🙏🙏

[@VedPrakash-bh7vw]

Sir,
Mere me slicer hilight nhi ho raha please guide

[@Innozant]

Kaunsa version use kar re h

[@swapnilshukla7735]

Dear Sir,
How to apply in pivot table filter area by copying a list ? Please Suggest Solution.
Thanks
swapnil

[@gargibhattacheryya4386]

Can we get live data to practice

[@Innozant]

Yes ..kindly find link to download the practice file in video description

[@tarjitmalka3978]

sir ek vedio items nd field ki bna do jisme hm bina colums k colm add kr skte hai.

[@Innozant]

Tarjit sahab wo next video aayega..field item and sets

[@abhishekbhushan1052]

SIR, PLEASE GUIDE ME THAT HOW TO SET FINANCIAL YEAR APRIL TO MARCH IN TIME LINE?

[@iccstudio1106]

Bhai power bi kab sikhao g buth wait kr rhe h apka power bi kaa pls sikhao

[@Innozant]

Jald videos aane lagenge

[@rjraviraftarup7553]

Mast hai 👌👌

[@shortsshorts4719]

6:44 sir data main branch center to show hi nhi ho rahi data main...

[@Innozant]

kya issue dear..acha dekhta hu kya miss hua .

[@shortsshorts4719]

@@Innozant sir seriously apki video ki baat hi alag h next level explain karte ho aap 🙏🙏🔥

[@nishikantanayak372]

Sir clicer show nehi ho raha hai laptop main

[@Innozant]

Pivot table jo create kiya hai uske upar active cursor rakhiye phir analize tab me dekhiye..slicer aur timeline mil jayega apkoo wahin