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

[@sentigosedge8510]

when i add data to rows section it doesn't group the items by months it just puts everything over just like that.

[@h2e]

This probably means your dates are entered as text. Double-check your data. A good way to test is to add 1 to the dates and if the formula results in an error, that means they aren't reading as numbers.

[@sentigosedge8510]

@@h2e yes indeed however even after fixing all dates by using text to column. It still wouldn't turn it into months so i manually turned it into groups and now Ima rename them.

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

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

[@analoveskincare1933]

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

[@md.mahmudulalamsymon1216]

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

[@karishmaverma2323]

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

[@FloriJaneReaño]

To the owner,pwede po ba mahingi yung copy or files into if kung pwede for final output lng po nmon🙏

[@gadshoaib2402]

You’re absolutely PROFESSIONAL, Thanks 🙏

[@AhaduBelayAlemayehu]

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

[@jeffwimer3969]

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

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

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

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

[@syedaneesdurez7197]

Beautifully explained and very useful video.Thanks

[@rajubasak7905]

This video is really very helpful. Thank you 😊

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

[@mayurchaudhary2030]

Very well explained. Thanks for sharing.

[@coolberry27]

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

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

[@muhammadjawedadel3054]

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

[@mohamedsheik5522]

Very important video I appreciate you

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

[@sreeraj54]

How can I update the dashboard on daily / weekly

[@fin.free9]

Ratalya data update kar daily

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

[@muhalasimon7257]

wonderful delivered and awesome video

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

[@Naren563]

Fantastic video! Short, precise and elaborative..

[@arUnnaOm]

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

[@err3122]

AMAZING VIDEO TUTORIAL

[@h2e]

Glad you liked it

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

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

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

[@annetim1090]

Most excellent video thank you so much.

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

[@adelekematthewabiola4917]

Please how can i download the sample database?

[@h2e]

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

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

[@Amanda-gt6cc]

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

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

[@Srinivaasam-847]

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

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

[@siyandasigutya8836]

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

[@realestatewith_sabrina]

Thank you been looking to simplify this information ❤

[@vishnujatav6329]

Beautifully explained. Thanks

[@bolawagdy7147]

Great explanation

[@cycleSCUBA]

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

[@aissatoudoudou8851]

That was very helpful

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

[@sothy9478]

Wow thanks for sharing brother

[@energy19831985]

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

[@muhammadmoinud-dinmalik2198]

So professional you are 👍

[@ezraonyinkwa9826]

how can i get this dataset

[@h2e]

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

[@senyak7576]

Great simple to floow through content👌

[@valigsk3250]

Wow super great job

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

[@pustakaekonomi5195]

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

[@Nikhil8146]

great video totally worth it

[@CozBlueOcean]

Great and very helpful video. Thank you!

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

[@mayankbhatia1827]

There's no excel file in the given link.

[@h2e]

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

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

[@okenneth187um]

This is great!

[@raphaelahiekpor6426]

Very useful video

[@TheAdnan69]

Excellent one....

[@rajann4004]

Really awesome .. thxs for sharing 👍

[@kazmi59]

whre to download data sheet

[@HosseAnchoa]

Thanks for this!

[@AdoniasRumoAoTopo]

Great job

[@mensahchristopher3101]

I can’t download the dataset

[@h2e]

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

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

[@anna.yl_kim]

Thanks for sharing 🙏

[@USpilla143]

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

[@Ariungo-k5l]

0:42 how to do this

[@AhmedElsayed-st3cb]

Manythanks شكرا جزيلا

[@shoppersdream]

Nice, thanks!

[@masud380]

Can You Kindly Share project file.

[@h2e]

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

[@divya3321]

Excellent dashboard 👍

[@coutourplusconfidence8302]

Extremely useful ty

[@chinnathambi40]

please share dataset

[@viralparmar365]

Awesome 🎉

[@debjyotikanjilal2610]

Excellent 👍

[@nazarkamal8831]

Nice

[@tadiwosasrat5157]

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

[@tashiwangchen776]

how create the dashboard for hr???

[@adbalukunadora6644]

Thank you a lot

[@NaveenKumar-zx4mp]

Super boss 👍

[@flossyempire]

Lovely

[@tenawyibeltal.888]

Thank you

[@titohassan7328]

u r great

[@naseebzeehan7986]

Thanks a lot.

[@anubhavguria6544]

Thankyou 😇

[@karansinghrajput1708]

Thanks 😊

[@simonzira7581]

The action paln.