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!
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
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
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.
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
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.
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?
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
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!
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?
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
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.
Please view the latest dashboard video which starts from scratch, that will show you how the data source gets set up at the start. ruclips.net/video/IHUMOVm_rLs/видео.html
@@h2e thanks for getting back to me. I have tried troubleshooting as per your suggestion but it isnt working out. I later tried to just use your already created dashboard, removee the date slicer (that was in months and then added it again, it came in days like it was happening with me before)
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.
The data source is just a named range. I have a couple of other dashboard videos that go from start to finish. ruclips.net/video/9_Gc_JweIUc/видео.html ruclips.net/video/IHUMOVm_rLs/видео.html
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
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!
This is one of the greatest learning videos I've seen yet. cant wait to go through your videos
VERY IMPORMATIVE VIDEO! With this, you help me on my task as an intern student. THANK YOU VERY MUCH!
Great explanation as compared to other youtube channels that explain the same concept. You'd make for a great teacher
This is done in most simplistic way to help us learn. Many thanks
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
I have seen so many videos on kpi dashboard, only this video works and so nicely....big thanks
Please are you using a software for KPI? Or strictly excel!
Thank you for taking the time to explain this so patiently.
Just wow & Thanks for explaining us in such a nice & easy way !
You’re absolutely PROFESSIONAL, Thanks 🙏
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
The data is in this post howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html
I don't understand onething..In data sheet, at 0:53 Minutes, where does the Dataset1 comes from???
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.
Beautifully explained and very useful video.Thanks
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
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.
Great job
Very important video I appreciate you
Slicers take a dashboard to another level. I'll need to practice the report connections.
Thank You for making this video. It's a very useful video.
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?
Thank you so much it's very very useful...👍
Fantastic video! Short, precise and elaborative..
This video is really very helpful. Thank you 😊
Very well explained. Thanks for sharing.
Most excellent video thank you so much.
Beautifully explained. Thanks
wonderful delivered and awesome video
Thank you for sharing the video. this video really helped me to prepare a dashboard. thank you so much :)
Thanks for sharing 🙏
Great explanation
Great video! This will help me tremendously. Many thanks and well wishes
That was very helpful
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
How did you set up a named range for your data set?
Thank you so much for this video, it really has been of help for me..Great job
many thanks for sharing the updates on dashboard m please add new video about the updated dashboard of construction project.
Manythanks شكرا جزيلا
very very informative. thanks a lot .
Expecting more more like these.
Thank you been looking to simplify this information ❤
Thanks for this!
So professional you are 👍
Thank you for the great insight.
It's a superb video
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!
How can I update the dashboard on daily / weekly
Ratalya data update kar daily
hey when im pressing the insert pivot table it s shows reference data source is not valid
Make sure u dont empty spaces
Wow thanks for sharing brother
Wow super great job
Very useful video
Great simple to floow through content👌
Great video.. so easy to understand.. thanks man!!!
great video totally worth it
Great and very helpful video. Thank you!
Awesome. Is there a way to do age groups? Need to categorize in 10 year increments
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...
Extremely useful ty
This is great!
Excellent dashboard 👍
Excellent one....
Really awesome .. thxs for sharing 👍
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?
Share me the data set ...to practice
Ur vedio was too good
Excellent 👍
How did you name your data as dataset 1? I don't see that part in the video.
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
@@h2e it still not clear how you name your data as dataset1. Is there a video where I can see the entire process?
I will do an updated dashboard video in the near future that will start from scratch and cover some different visuals.
link for data not working. Can a dashboard consist of more than one data source?
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
I says cant find the page a 404 error to bropbox
@@wayneseymour1 Okay try this one, I've updated the link in the post as well: www.howtoexcel.net/wp-content/Sample.Database.xlsx
@@h2e Ok tat one works THANKS!!!
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
Dataset is being used for every pivot table in your video, but their is no video of assigning the dataset to a data
Please how can i download the sample database?
www.howtoexcel.net/wp-content/Sample.Database.xlsx
Nice
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
Office 365
I can show usefull
That was great, thanks. How would you update this if it was a monthly dashboard?
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
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...
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.
Thank you a lot
its say "Data source reference is not valid" when pivot table selected how to resolve
Please view the latest dashboard video which starts from scratch, that will show you how the data source gets set up at the start. ruclips.net/video/IHUMOVm_rLs/видео.html
I can’t download the dataset
The link for the sample data is here: www.howtoexcel.net/wp-content/Sample.Database.xlsx
Thank you
Thanks a lot.
Thankyou 😇
How did you link the sample data with data, I have rewind a few times but I didn’t see it
It may be helpful to following along with this article howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html
hi, how did you name your range to "Dateset1" please? thanks
Yes, I just selected my data and created a named range, as opposed to referencing specific cells.
how can i get this dataset
www.howtoexcel.net/wp-content/Sample.Database.xlsx
Cant go any furthrt from dataset 1 pivot table,
This is just whatever your data set is. Set it to your data. I just created a named range in my example
wow
I keep on getting date by day when i add the date slicer, what am I doing wrong?
I have group the first pivot table by day, and have matched everything in this video
You should be able to group dates. If you're not able to, check that your dates aren't in text format
@@h2e thanks for getting back to me. I have tried troubleshooting as per your suggestion but it isnt working out.
I later tried to just use your already created dashboard, removee the date slicer (that was in months and then added it again, it came in days like it was happening with me before)
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.
The data source is just a named range. I have a couple of other dashboard videos that go from start to finish.
ruclips.net/video/9_Gc_JweIUc/видео.html
ruclips.net/video/IHUMOVm_rLs/видео.html
Super boss 👍
u r great
The action paln.
0:42 how to do this
Thanks 😊
whre to download data sheet
There's no excel file in the given link.
www.howtoexcel.net/wp-content/Sample.Database.xlsx
thx
please share dataset
oh this is great video teacher please support me how to prepare financial statement wit dash borad
where can i get the data please
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
Can You Kindly Share project file.
Refer to this post howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html
how create the dashboard for hr???
your voice is unclear, little bit diffcult to understand what you say
hi! try to duplicate what your doing in the video, but it says "data source is in valid" :-( it seems you have magic on that procedure...haha
Try following along with this post: howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html