Step by Step Instructions for Easy EXCEL Dashboards

[@dougkampe6117]

Your video is very helpful and illustrates how easy dashboards in Excel actually is. Thank you!

[@anthonyyung3387]

Thank you for providing us with such an invaluable lesson on excel dashboard.

[@liselimulala4427]

thank you for the very clear and concise detailed description I am finally able to make my own dashboard after watching 5 other videos, yours was the best and the easiest to follow.

[@Starchildblesseed]

I loved the "list of ingredients" reference. Definitely relatable and THANK YOU!

[@fromelmstreetgames]

Excellent video! Thank you for making this. Now I feel comfortable making (basic) dashboards in Excel.

[@danielrubinstein1211]

Thanks for posting this video......I'm trying to learn more about dashboards, pivot tables, and formulas. This video was very informative

[@melitadsouza3831]

Thank you. This was really simple and easy to follow. I was able to create my dashboard with this tutorial

[@Ukland1]

Thank you so much David, easy and straightforward session. It helps me a lot ending a huge task on my work. Very well done, appreciate your effort!

[@ravimani6674]

Good video. Gave a good overview on the Dashboard and quite useful. Thank you.

[@RaeSue1224]

Thank you this was very helpful to make dashboards and report cards.

[@BigRouch]

02:00 Raw "untainted" data is just so beautiful. Said every DBA... ever... (!) Nice vid.

[@whartley4752]

Thank you, I am just learning all of this and find it fascinating

[@MrTibebe]

Thanks a lot, i really like the way you present the topic, with a nice tonality and ease,please keep it up and up!

[@Saltcoteplace]

Thank you David, that was an excellent well paced and detailed tutorial, I learnt a great deal of useful stuff well done. If you provide details of your website or haw to engage with you I would be happy to pay you for some assistance.

[@abdomansoor6864]

Thank you David, simple, easy to remember

[@herculepoirot6849]

Thanks a lot. Sorry for the delay. This is great. I had requested for the detailed view. :)

[@olivialan4839]

l like the way you talk, very natural , smooth, enjoyable.

[@OsaroOyegun]

Excellent video on creating dashboards!!

[@deciosilva1971]

Excellent video! Thanks for the class.

[@PhoenixInternetFM]

Hallelujah! What an amazing tutorial! You've helped us so much!

[@katyayini1987]

Thank you very much Mr David.its really helpful.Could you please send a link for the raw data for practice.

[@hirenvyas9653]

Great video! Clear and concise information

[@LettuceLearn]

Great video! Clear and concise information.

[@user-cp4cy2tb3b]

Thank you. This was quite helpful. Very well done!

[@laylashaabi]

really quick time with interest point and good speaker thanks

[@tridunghuynh5573]

Hi David, thank you very much for your sharing. I'm new for these beautiful things so there're very enjoyable. But can you upload your data for us for practicing? Thank you again

[@shikhakumar2556]

This was very helpful. Thank you :)

[@JustisministerMyking]

Thanks for this, its perfect! Also, your voice is remarkably similar to Michael Kramer's voice (Who read's The Wheel of Time audiobooks) - which is ment as a compliment! Very suiting.

[@Ankushakush]

Thanks Mr. David, Video is very useful. Can you please share the Raw data for practice.

[@SaifullahTameem]

It helps me a lot, thanks, David.

[@AdeKaryadi]

nice video, thanks

[@roshniriyer]

Thanks for this, David!

[@deadlyslayer3251]

Well done I didn't know I can do that with pivot table

[@ricme1281]

Students are sometimes overwhelmed by tons of assignments and homework. The assignments from the school’s coursework’s may even be a thorn in the foot for the students to even work and live comfortably. If you are a student who is stuck with your homework or assignments, essays, thesis, research proposals and any other, please feel free to hire competent writers from acemywork.com/, which is an online assignments writing page. The experts from Acemywork.com guarantee you quality work free of plagiarism. Make order today and feel free to contact us. We have the best writers to take your #fall semester online classes for you. #fall and summer classes #Essay due #Homework help #Case study #Do my homework #Online class #essaypay #English class #Math #pay assignment #homework #essay write #essay help WhatsApp [phone] Make order at acemywork.com/

[@blesseveryoneiknow]

Clear and concise, thx

[@sajidpoolakamannil2555]

thanks . Great help for excel lovers.

[@joservaldivia123]

Great video sir!!

[@alkadeshmukh2404]

Very useful! Thank you.

[@ranjannayak99]

Thanks for the video.Its a nice vodeo.Pls suggest me how to get the data set used in this video...

[@mijelewashingtone155]

This is wonderful lesson learnt, thank you for this

[@tannertucker22]

Thank you for your informative series. I noticed that one can forego the pivot table slicer connections if all of the pivot tables are stored on the same worksheet. Is that correct please?

[@DavidWettonExcelBI]

Tanner Tucker Not necessarily. Slicers are tied to a specific pivot product. I often create multiple products on a single dashboard that all come from the same workbook in the same file, but I have to connect the slicers. In some cases I have up to ten pivot products on a single dashboard. You don't have to connect all the slicers to all the products, unless you want to. I know there are performance issues if you get too much on a single dashboard but most of my data files aren't all that large. But it may impact how things work if you put the file on a Sharepoint site and access it via the web.

[@tannertucker22]

David Wetton Thank you David. I follow the same configurations that you do. I appreciate your response.

[@bobdown8043]

Very good. Thanks for this.

[@excelkid]

Excellent video! Thanks for sharing!

[@JAA903]

very detailed and informative video but what about graphs how can we interlink these slicers with graphs?

[@X_venturee]

you saved this intern from having to use an excel and dashboard book. thanks

[@Shailen7911]

If in the Raw Data I have some fields which are with formula in the Data sheet. Like I use SUMIF, SUMIFS & Vlookup. Will these fields work accordingly.

[@EventHorizonTV]

In a regular table using sorters, my sorted rows are sorted by position they appear in the able. i.e., row 13 then 42, then 98, then 116...etc. When I use my slicers, my sorted criteria in my slicers can only be ascending or descending order, numerically and alphabetically. This makes my filtered data in the slicers mismatched from slicer to slicer. Can I format the slicer to lock sorting only by position in the table so that sorting criteria can match from slicer to slicer?

[@vahidhosseini8158]

Is it possible to access this dashboard? It seems it is good. Thanks in advance.

[@bverrabbit]

Thank you so much.

[@kamarri114]

Very helpful. Thanks bruh

[@simfinso858]

Thanks for this video.

[@MrDineshbawane]

How to add scroll bar to pivot table? In my case pivot table data is also a part of dash board, and hence it has limited space on it. Please answer.

[@alfredfrancisco7096]

Hi David, where can I download the Excel data file? Thanks.

[@joysrayil5973]

Great! Thanks!

[@Rakeshkumar007]

Hi David, Hope you are doing well.. Thank you for this video which is really very helpful. I would need your help if you could show me how to create dynamic schedule (something like this) If you can just copy paste this text in youtube & click search "Construction Schedule using Excel Template" you will be able to find this template. I need to learn creating something like this.

[@adolfohc78]

Could you provide the raw data? Thanks and great video!

[@DavidWettonExcelBI]

Adolfo Hernandez pub.data.gov.bc.ca/datasets/177244/BC_Guide_to_Ab_Org.xlsx. You can paste this address into Power Query to link directly to this public data source.

[@inspector-tech]

Excellent! Thank you!

[@delinquense]

Congratulations, David! You've managed to confuse a whole lot of people. That is NOT a dashboard that you created. It's a bunch of slicers placed on a single Excel sheet to modify a single data table. It provides little in the way of insight into my data. A dashboard visually tracks, analyzes and displays key performance indicators (KPI), metrics and key data points.

[@danyos777]

Delinquense could you please point out a good video to set-up dashboards the way you suggest? If you happen to know of one. Thanks!

[@pashtofuntuch2878]

excellent to learn

[@derebaolane477]

Thank you

[@hakeemsahzad]

hello david, i need that data file for practicing this video

[@nivpawar22]

its very useful video

[@its_cassiej]

Super helpful!

[@jayb5457]

yes !

[@sugavanasabaripandiyan3424]

Hi David, is there a way we can remove the "blank" from the slicers. thank you.

[@herbat1]

Right mouse button over a slicer >> Slicer settings >> Hide items with no data

[@manh2468]

i am using excel 2013, where can i find insert " name" and define". under what tools ?? i need help

[@DavidWettonExcelBI]

+manh2468 I'm not sure I understand the question. What "Name" field did you want to insert? And "Define" is also not clear. Did you want to add your own Name titles on the dashboard? You can do that under Insert tab using "Text Box". I use that for putting titles or labels into my dashboards. Hope that helped.

[@carltonseymour869]

Nive video David. What software did you use to record this video. Was it Camtasia. thank you

[@DavidWettonExcelBI]

Carlton Seymour I believe I used "Active Presenter". I'm thinking of switching over to Camtasia though as it is a better product (but of course it is more expensive). But if I'm going to do this seriously, I have to invest.

[@carltonseymour869]

Thanks David Yes Camtasia is the best in the industry Carlton

[@DavidWettonExcelBI]

Carlton Seymour I should have bought it when our (canadian) dollar was worth more than a US dollar. Now it's only worth 75 cents so Camtasia is a lot more expensive. Oh well, investing in good equipment is a key to success in any business.

[@bigkkm]

+David Wetton every now and then, Camtasia runs a 50% off special. Look out for it.

[@DavidWettonExcelBI]

Thanks. Maybe a Christmas special.

[@milkbattle]

David any chance I could get a copy of your data. I want to emulate your results as a practice

[@DavidWettonExcelBI]

milkbattle Sure. pub.data.gov.bc.ca/datasets/177244/BC_Guide_to_Ab_Org.xlsx If you copy that link into Power Query "From Web" function on the toolbar it will create a direct link to this file and you can go ahead and build a Pivot table and dashboards without actually having to download the file. This file comes from an open data source in Canada (the province of BC).

[@dcifan4924]

David Wetton Thank you for your help.

[@Vinaykumar-rc5rn]

that link is not open............

[@feelgoodlovesongs3045]

that link is not open.

[@ekjibon]

helpful!

[@Wallst511]

awesome

[@rangariraimusiza4688]

great

[@nareshtalekar1193]

Is this avaliable in excel 2007 ?

[@DavidWettonExcelBI]

Naresh Talekar Most of the BI "Power" tools and dashboards/slicers are only available starting with Office 2010. Power Map is only available in 2013 and above.

[@TheTeaserking]

your all over the place. go in some order so we can follow.

[@SeleTraining]

Get a quick rundown of Excel 2016 tips and tricks: kzbin.info/www/bejne/e5XRcpinrdaXsK8

[@neelalam]

Talks too much