How to Create Dashboards in Excel

[@MuhammadNaeem-e1w6i]

Jaws dropping Dashboard. After so many years finally i get what is means by a "Dynamic Dashboard" I am really thankful to you for this explanation

[@Thunderin11]

8:56 - My revelation moment - How to make the slicers with multiple columns! Wow, I cannot believe I found about it only now after working with slicers for almost 1.5 decades! Thank you for sharing this part!

[@brandonberry9174]

This is one of the greatest learning videos I've seen yet. cant wait to go through your videos

[@larryachiya2475]

Great explanation as compared to other youtube channels that explain the same concept. You'd make for a great teacher

[@sweetannetopacio9078]

VERY IMPORMATIVE VIDEO! With this, you help me on my task as an intern student. THANK YOU VERY MUCH!

[@abbeybello4096]

This is done in most simplistic way to help us learn. Many thanks

[@md.mahmudulalamsymon1216]

Just wow & Thanks for explaining us in such a nice & easy way !

[@samratchadha5867]

Excellent video how easily you did that I saw videos taking atleast 30 mins to make this but this is done in a jiffy and I could even remember the steps you mentioned simply awesome

[@karishmaverma2323]

Thank you for this beautiful content. I have created my first dashboard.

[@analoveskincare1933]

Thank you for taking the time to explain this so patiently.

[@tanvivarshney1275]

I have seen so many videos on kpi dashboard, only this video works and so nicely....big thanks

[@ewerenwadozie4664]

Please are you using a software for KPI? Or strictly excel!

[@Ton_nia]

Thank you so much for this tutorial. Can you please explain what the last chart means and scenarios where i can use that type of chart? Thank you once again

[@h2e]

The last one is a stacked column chart. It effectively shows you two things in one: the total of everything plus how much each individual component makes up the total. You might want to use it when you want to see the different components.

[@mohamedsheik5522]

Very important video I appreciate you

[@coolberry27]

Thank you so much it's very very useful...👍

[@samialqasmee6123]

it's really a great video with a simple explanation, thank you for the great efforts, if you don't mind we need to get a copy of your excel file at least to follow your procedures step by step, and highly appreciated

[@h2e]

The data is in this post howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html

[@rishabhgarg5175]

Thank You for making this video. It's a very useful video.

[@gadshoaib2402]

You’re absolutely PROFESSIONAL, Thanks 🙏

[@mayurchaudhary2030]

Very well explained. Thanks for sharing.

[@AhaduBelayAlemayehu]

How did you set up a named range for your data set?

[@annetim1090]

Most excellent video thank you so much.

[@muhalasimon7257]

wonderful delivered and awesome video

[@richardwilliams9206]

This is a great video, Very informative. I was wondering why Excel did not show a pop up for Existing Connections when you added the slicer? Maybe due to the version?

[@muhammadjawedadel3054]

many thanks for sharing the updates on dashboard m please add new video about the updated dashboard of construction project.

[@rajubasak7905]

This video is really very helpful. Thank you 😊

[@syedaneesdurez7197]

Beautifully explained and very useful video.Thanks

[@sanaldunya7203]

Hallo, wie kann ich doppelte Namen im Zeilenfeld sauber anzeigen z.B. Ömer Toprak, Hasan Toprak, Stefan Toprak. Pivot zeigt mich die Namen Gruppiert an und ich kann anschließend im Wertfeld die Anzahlt der Tore nicht Auf oder absteigend sortieren. Wie komm ich zur Lösung?

[@jeffwimer3969]

Awesome. Is there a way to do age groups? Need to categorize in 10 year increments

[@aissatoudoudou8851]

That was very helpful

[@arUnnaOm]

Thank you for sharing the video. this video really helped me to prepare a dashboard. thank you so much :)

[@rodelineestime2230]

Hello, thank you so much for your video. It helped me tremendously, however when I went to select my pivot tables, I only see pivot table 1 to select. Can you help me figure out why I cant see the others? I created three side-by-side exactly how you have it. Thank you very much for assisting

[@cycleSCUBA]

Slicers take a dashboard to another level. I'll need to practice the report connections.

[@bolawagdy7147]

Great explanation

[@phani34suriya]

I don't understand onething..In data sheet, at 0:53 Minutes, where does the Dataset1 comes from???

[@h2e]

That is a named range I created for my data. Rather than selecting something like A1:G1000, I just created a named range. If you're creating a pivot table, you would select the table or range that relates to your data at that step in the process.

[@AdoniasRumoAoTopo]

Great job

[@sothy9478]

Wow thanks for sharing brother

[@Naren563]

Fantastic video! Short, precise and elaborative..

[@vishnujatav6329]

Beautifully explained. Thanks

[@HosseAnchoa]

Thanks for this!

[@realestatewith_sabrina]

Thank you been looking to simplify this information ❤

[@Mad1080]

Excellent Video and easy way to understand... Can you please help us with excel sheet. I want to download use as per shown in Video...

[@bigchino3647]

I noticed on the downloaded dataset you had the pie graph listed as dollar amount but in the video you changed it to %. Everything on your dashboard tab in the file we downloaded should match the video. That shows consistency...but still a great video!!!! You went through it very fast but better than too slow I guess. Thank you. Great job bro!

[@valigsk3250]

Wow super great job

[@anna.yl_kim]

Thanks for sharing 🙏

[@raphaelahiekpor6426]

Very useful video

[@siyandasigutya8836]

Thank you so much for this video, it really has been of help for me..Great job

[@energy19831985]

Thank you for the great insight. It's a superb video

[@Srinivaasam-847]

very very informative. thanks a lot . Expecting more more like these.

[@Amanda-gt6cc]

Great video! This will help me tremendously. Many thanks and well wishes

[@bootlasravanthi2846]

Sir can you pls say which version of Excel your using and which window version....becz iam unable to use my slicer and some other options

[@h2e]

Office 365

[@jahanzaibkhalil9797]

How can we add dataset, please explain about setting up a dataset.. I have the file and i used all the process but don't know about dataset

[@jahanzaibkhalil9797]

Dataset is being used for every pivot table in your video, but their is no video of assigning the dataset to a data

[@sreeraj54]

How can I update the dashboard on daily / weekly

[@fin.free9]

Ratalya data update kar daily

[@okenneth187um]

This is great!

[@Nikhil8146]

great video totally worth it

[@maryederdelosreyes4938]

hi, how did you name your range to "Dateset1" please? thanks

[@h2e]

Yes, I just selected my data and created a named range, as opposed to referencing specific cells.

[@AhmedElsayed-st3cb]

Manythanks شكرا جزيلا

[@muhammadmoinud-dinmalik2198]

So professional you are 👍

[@senyak7576]

Great simple to floow through content👌

[@dimplethacker2296]

hey when im pressing the insert pivot table it s shows reference data source is not valid

[@muskaankhanuk7790]

Make sure u dont empty spaces

[@shoppersdream]

Nice, thanks!

[@TheAdnan69]

Excellent one....

[@CozBlueOcean]

Great and very helpful video. Thank you!

[@pustakaekonomi5195]

Great video.. so easy to understand.. thanks man!!!

[@rajann4004]

Really awesome .. thxs for sharing 👍

[@nauruakoura2228]

Can you help me what you insert when creating a pivot that automatically take the whole data in the other tab in 0:53 to 0:55 in the video...

[@h2e]

This assumes you have a data set you've already created and assigned a name to it. In this video I've skipped over the step of creating a named range for my data but essentially you just want to reference your data in that step. It doesn't have to be a named range, but that can make it easier to remember it. For example, if your data was in A1:Z100, that's what you would enter in.

[@coutourplusconfidence8302]

Extremely useful ty

[@calvinhammond7172]

How did you name your data as dataset 1? I don't see that part in the video.

[@h2e]

I set up a named range beforehand. Refer to this post on how to do that: howtoexcel.net/2014/01/the-benefits-of-using-named-ranges.html

[@dinamar4402]

@@h2e it still not clear how you name your data as dataset1. Is there a video where I can see the entire process?

[@h2e]

I will do an updated dashboard video in the near future that will start from scratch and cover some different visuals.

[@kampatterson1865]

That was great, thanks. How would you update this if it was a monthly dashboard?

[@h2e]

You can just add to the data. The date slicers would allow you to select which month you want to look at, filtering out what you don't need

[@adelekematthewabiola4917]

Please how can i download the sample database?

[@h2e]

www.howtoexcel.net/wp-content/Sample.Database.xlsx

[@divya3321]

Excellent dashboard 👍

[@_REcon_]

Hey, thanks for the video 😊 Sir, could you please tell us how to set up data source first then doing the pivot table to analyze the rest of the data? Most of us are having this issue yet the article you provided doesn’t address the problem, I read the article and it explains the part of the issue then it goes straightforward to the content of the video.

[@h2e]

The data source is just a named range. I have a couple of other dashboard videos that go from start to finish. kzbin.info/www/bejne/b5CqlJKArMp8i8U kzbin.info/www/bejne/f3m4foKMosSlgtU

[@RisYEG]

How did you link the sample data with data, I have rewind a few times but I didn’t see it

[@h2e]

It may be helpful to following along with this article howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html

[@wayneseymour1]

link for data not working. Can a dashboard consist of more than one data source?

[@h2e]

the link looks to still be working: www.dropbox.com/s/75t9aonn6299zuq/SampleDatabase.xlsx?dl=0 If you want multiple excel workbooks linking into one database or pulling in non-excel sources then you can create a dashboard, but you'll need to use PowerPivot for that

[@wayneseymour1]

I says cant find the page a 404 error to bropbox

[@h2e]

@@wayneseymour1 Okay try this one, I've updated the link in the post as well: www.howtoexcel.net/wp-content/Sample.Database.xlsx

[@wayneseymour1]

@@h2e Ok tat one works THANKS!!!

[@mayankbhatia1827]

There's no excel file in the given link.

[@h2e]

www.howtoexcel.net/wp-content/Sample.Database.xlsx

[@ezraonyinkwa9826]

how can i get this dataset

[@h2e]

www.howtoexcel.net/wp-content/Sample.Database.xlsx

[@mensahchristopher3101]

I can’t download the dataset

[@h2e]

The link for the sample data is here: www.howtoexcel.net/wp-content/Sample.Database.xlsx

[@Ariungo-k5l]

0:42 how to do this

[@Hotvehicles]

its say "Data source reference is not valid" when pivot table selected how to resolve

[@h2e]

Please view the latest dashboard video which starts from scratch, that will show you how the data source gets set up at the start. kzbin.info/www/bejne/f3m4foKMosSlgtU

[@jinlee3229]

Cant go any furthrt from dataset 1 pivot table,

[@h2e]

This is just whatever your data set is. Set it to your data. I just created a named range in my example

[@kazmi59]

whre to download data sheet

[@USpilla143]

Share me the data set ...to practice Ur vedio was too good

[@debjyotikanjilal2610]

Excellent 👍

[@saasjnr2056]

where can i get the data please

[@h2e]

There is a post related to this video, and the data file is available on there. howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html

[@nazarkamal8831]

Nice

[@adbalukunadora6644]

Thank you a lot

[@chinnathambi40]

please share dataset

[@masud380]

Can You Kindly Share project file.

[@h2e]

Refer to this post howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html

[@naseebzeehan7986]

Thanks a lot.

[@anubhavguria6544]

Thankyou 😇

[@tashiwangchen776]

how create the dashboard for hr???

[@flossyempire]

Lovely

[@tenawyibeltal.888]

Thank you

[@NaveenKumar-zx4mp]

Super boss 👍

[@titohassan7328]

u r great

[@tadiwosasrat5157]

oh this is great video teacher please support me how to prepare financial statement wit dash borad

[@papunrock6693]

I can show usefull

[@simonzira7581]

The action paln.

[@karansinghrajput1708]

Thanks 😊

[@samrozch8419]

wow

[@atanoob64]

your voice is unclear, little bit diffcult to understand what you say

[@lauraknott1922]

thx