Excel Dashboard Course #21 - Creating a Pivot table Dashboard with Slicers in Excel (in 15 minutes)

In this video, I will show you how to create a Pivot Table dashboard in Excel in 15 minutes. The dashboard includes Pivot Charts and slicers.
✅ Download File - trumpexcel.com...
☕ If you find the videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial

[@vikrantsharma-i3u]

Thanks a lot Sumit for such a nice teaching..

[@allanjuarez4303]

Thanks a lot!

[@Sareeshoponline]

Sir, Where from can I get the design and Analyze tab, I can see only upto view.

[@swiftvin]

Hi how can i contact you on your website?

[@vinaykumar-ci7bj]

Very informative and useful for all, thank you so much for your time and training support ❤

[@vishajoshi3500]

thanks i made a dashboard by following side by side. such well explained video without unnecessary talking. One question , how can i make everything fits in one frame

[@Aura-Essence-p]

In my excel no slicer is there😮

[@PraveenKumar-gn3to]

Can you tell me how the sheets have been created. Please share the link that sagrigation of pivot sheets by one click

[@jimherr152]

I noticed that the title of the graphs don’t change when you select the different slicer buttons. So if I go to print a graph, the graph title does not automatically reflect the parameters from the buttons in the slicers. What is the solution for that?

[@vandanachaudhary8]

Hi, I’m not getting all my tabs when I’m clicking Report Connections, its showing only one pivot table. Plz let me know what to do

[@CaribouDataScience]

What is the correct link for the file?

[@bhavirathi9484]

Download link not working,please help to share to download practice Excel workbook

[@bargains2shop506]

Any excel experts who can work on a project . Need experts only who can showcase work via video

[@anbarasua4576]

The Dashboard course was neatly designed and explained well. It will be really beneficial. This is compelling me to see more from the channel. Could not download data files for practice along with the video.

[@balasubramanianshanmugam3721]

Thank you for posting this video. It is so useful and understandable. keep posting.......

[@rizwanabibi7987]

Thank you sir ❤ Amazing, well explained

[@MrEms333]

Very Nice I hope can make like that one

[@goharsaqlain]

Download link is not working. Please share Download link

[@evernote88]

what if I add a new data entry on data source, shall the pivot table/dashboard updated automatically? so, far I need to refresh it many time everytime I add new information on it. Pls Adv, thanks

[@kashmirshadows8150]

Same question here

[@srinivasumanem4979]

Very good explanation sir. Thank you.

[@sourovajmain2048]

sadly the download link doesn't work. Please solve this

[@manishlalwani]

How to create slicker for only top 5 or top 10 or as per requirement

[@harsohrabsingh8020]

Hey Sumit, big fan of your videos and the simple explanations! Keep them coming. Thanks a lot for all the knowledge!!

[@salaamgroupmediahyderabad2450]

Hi please share the pivot table URL with this course data

[@mrCetus]

Hi thanks for the tutorial. however, i found the combo chart for line keep disappear everytime i change the slicer. do you know the solution ? thanks

[@vedantsutar]

Sir ur awesome ur provide this details free god bless you apko bhagwan jo apko chahiye wo do

[@babakdavoudi1946]

The download link is not working, please help

[@tutsecret499]

When I click on your file link, then I don't find file on my download folder. Can you make available the file? Thanks.

[@maheshmishra7490]

i faced the same issue. The tutorial is great but it would be better to get a hands-on experience

[@sivas9443]

Wonderful Sumit Please give us more Pivot Dashboard tutorials ! Please the ones like HR without Pivot can you do it with Pivot

[@khushal6560]

downloadable file is not opening

[@shrijibhau]

Thank you so much, very effective video. Very helpful. Examples and way of explaining is on point.

[@satyajitbaisakh7353]

Can you shre the file again..its not opening

[@broto8]

Bit OTT for me at this stage but it is so easily done by you ... it is quite impressive

[@thenewdataguy]

Thanks for inspiration, really like it.. Clean and simple in a good way!

[@rajshree4635]

7:30, 9:24 double axis chart 10:42 to 12:10

[@mireillecantrell4638]

Great job! However, on the download file, the bar chart does not change when a single region is selected. So I see you broke the connection to that chart, right? Thanks.

[@mireillecantrell4638]

Great! It now works! Maybe it was my error? You were extremely busy on March 19, 2020!!! LOL

[@Mad1080]

Thanks for sharing this excellent dashboard with us.. well explained.. Kindly help us to download this file.. We are not able to download..

[@omprakashsuman5934]

Download File link is not working

[@FaysalEasyExcel]

Thanks sir very clearly described

[@victorj9320]

It's simple & Neat. Thanks .can you please share the link . Earlier link might have outdated

[@haider121979]

Easy, smart, and practical. God bless you!

[@mdmizanurrahman5527]

But we need how to fixed/lock. Only slicer will active & see result but can't remove dashboard sheet.

[@Vutsman1]

If I link to Access query, and try to create a second pivot table, the create pivot is grayed out. If I create a 2nd pivot table using the same query on a different worksheet, I can't link using the slicer - only one worksheet shows up and not the other. What am I doing wrong?

[@throughmylens04]

Excellent video...Simple,clear and efficient...Very useful video

[@rudesvlogs8263]

Can you share a sample data dump

[@ramonlousberg8003]

Great video i have only 1 issues. When i create slicer is do report connection but i only see 1 pivot instead of multiple. I made 5 sheets with different pivots but only see the pivot on the sheet i create the slicer on. Any ideas? Thank you😊

[@nishantchaudhary3417]

Data file to share kar do brother

[@SrinivasKumar-h7u]

hi sir, the practice file is not available here in the link. The link exits automatically. could you update and fix the issue ?

[@vbreddy4296]

SUMIT SIR AWESOME

[@chetansamdani163]

hi sir, i want to add slucer for % of sales values, like 10%, 20%, 30%, 40% and so on....please help...

[@ellemason2055]

Very easy to follow. Thank you!

[@zubaeralam496]

requesting to check download file. I could not download as it was saying 504 gateway time out.

[@JamesSmith-fj6bp]

When we change the entry on slicer the formatting of char changes like design and fonts.. How to stop that... I'm using excel 2013

[@arunachari2689]

Thank you for your video!! I am not able to download your data file to practice this.

[@rizbfatango]

Thank you you so much, very informative video. My question: Can we combine a dashboard using pivot tables and excel chartings and may be VBA?

[@missadventure7564]

Once everything created, how do you go back to pivot tables for each tab, my pivot tables for each tab disappeard

[@woicewithsagar]

unable to download the file.. link is not working which you shared in discripiton

[@bhattbhaumik3266]

Not able to download the file

[@woicewithsagar]

unable to download the file.. link is not working which you shared in description

[@bollywoodkiharkhabar9262]

Awesome would be really helpful if you make video on Macros VBA

[@sekharispassion]

Sir, Thank you for clearing my doubt on how to change slicer pattern from vertical to horizontal. Also, on links to all pivot tables to control the entire sheet in one click.

[@sangitparajuli1227]

well explained thanks !

[@salehofgalaxy]

Perfect 👌

[@HappyLife30000]

excellent very informative easy to understand explain in very easy way this increase my knowledge

[@aamulhim]

We need the excel file please

[@ManojKumar0101]

Thank you so much for your lovely explanation.. It is really helpful

[@kiyan9]

Hi thanks for the tutorial. however, i found the combo chart for line keep disappear everytime i change the slicer. do you know the solution ? thanks

[@pthdxe]

It is very useful and good presentation. I want to download your file for practice but cannot success. Can you share this file for me, pleaase?

[@sumanghoshal3102]

Unable to download file

[@abusufiyanmansuri5675]

Unable to download file

[@sowmyasankar4471]

Excellent Sumit 👏

[@shoppersdream]

You can't download this file. Can you put a new link for the download file, Please?

[@m.d.shibyshiby7923]

Option tab is not found

[@analyticshub9615]

What software did you use please?

[@trumpexcel]

Software for? The tool I show in the video is Excel, and I've used Camtasia for the recording

[@abdulrashidyusuf2507]

can these dashboards be exported to powerpoint such that i can still use the slicers

[@rajeshnaik7207]

thank you so much very informative and useful infromation

[@NoTorr2000]

VERY useful video. You just kept me from looking ignorant in front of my manager and HIS Manager. Many thanks!

[@Teesriflight]

Good Job! Thank you for this.

[@rebm3028]

Hello, With the slicers of a pivot table, I can't keep the format (example wraps) As soon as I click on another segment, there is no more wrapping and the box is unchecked ...

[@allanamone5171]

The presentation is really easy to understand. I have learnt a lot. Was not able to download the file though.

[@salaamgroupmediahyderabad2450]

I mean Last video

[@sudharani7747]

Can you please make dashboard for recruitments

[@christophfanalways215]

My Report Connections doesn't show the other pivot tables to select. Ideas? In a hurry? This is due soon : (

[@christophfanalways215]

I figured it out, this was so useful thank you so very very much!

[@IshanKumara-r6s]

Sharing knowledge , Educating others are really appreciated ❤

[@1206kendra]

This video was great, thank you!

[@NilanjanJanaofficial]

Very Helpful for Me. Thanks 👍

[@rajeshakkineni5127]

So nice sir... thank you for the creative dashboard s

[@IshanKumara-r6s]

Sharing knowledge , Educating others are really appreciated ❤

[@m.faheemmujtaba7639]

Email me all excel files with data plz

[@vikass5477]

Hi Sumit, Can you please tell me about drawbacks of pivot table that is about dynamic data which you specifically discuss in the above video, I couldn't understand

[@datatalksbyjunaid4292]

Thanks for the simple video

[@sopaayun]

Love it, thank you so much, god bless you

[@hassanmburia8825]

I have created my team dashboard through the slice be blessed

[@muhammadeilyas]

Very Good...Easy to understand,Hat of to you!

[@parikshitbhavsar4076]

Simple and amazing way to create dashboard. This helped me to create interactive dashboard as per need of my client

[@krushnamarshiya3615]

The download file link isn't working

[@jugantaphukan9971]

Link for downloading this file please

[@evernote88]

Learning so much from this channel 🙏🏻

[@theonlynikul2209]

is the data link doesn't work or something?

[@linalai6673]

When I did month slicer, the month shown was 1/20/2020 instead of January, may I know how to edit the month in slicer?