Excel Dashboard like you have never seen before (full tutorial + sample files)

[@abhishekupadhyay6938]

Hey Chandoo Sir, Great Video. You thought so much in this one video, that this is must watch for everyone who wants to learn and use the power of excel. Thanks for your effort and generosity.

[@chandoo_]

You are welcome Abhishek 😀

[@silenceofharmony]

Thanks to the day I discovered Chandoo's youtube channel. In just one lesson I learned thousands of Excel figure I have never used or seen before. Promise all my pivots and all my weekly reports to the manager will be changed with those new figures. Thanks Chandooo !!! You are a genius!!!

[@himanshushallya5326]

Hi Chandoo , I'm happy to share that I'm starting a new position as Business Analyst at Oracle. I learnt so many things by this channel. Thanks Chandoo for your support and guidance it's only possible just because of you. You're a true inspiration for aspirants like me.

[@nayanshewkani9858]

give me your number buddy, need some advice from you

[@canirmalchoudhary8173]

🤭 Awesome dashboard 1. Tile in excel 2. Linked pivot table 3. Data model 4. Calculated measure 5. Font across excel 6. Conditional formatting 7. Bubble chart 8. Picture linked index matching and many more nuances learning Thank you 😘

[@chandoo_]

You are welcome Nirmal :)

[@chandanmishra2396]

More than Excel Master, You became a 'soul' inspiration for age agnostic personality.

[@chandoo_]

Thank you Chandan.

[@ebred76]

Wow.I always considered myself to be "good" with Excel. I'm humbled now. lol. In all seriousness, i have always struggled with presenting data in a nice fashion. i dont think that will be a problem anymore. I cant believe the amount of detail in your video. beyond excellent! thank you for the knowledge

[@papnyanamah2748]

From Liberia - West Africa, you’re awesome. Thanks for this amazing work.

[@chandoo_]

Thank you so much for the love Pap

[@p_anjali_codes]

Everytime I watch this, I learn something new.

[@mahmoudmohsen8105]

I'm rewatching this , and It can't get anymore GODLY

[@justinz1467]

Chandoo, you are awesome. Not only do you combine making learning new skills such as SQL, Power BI, Tableau and Excel easy, but you also provide the sample documents needed to work and follow along with you. I know I am not alone, but I learn best by doing, so having access to the data files to manipulate as your video plays is crucial for me to learn these skills. Recently I found how much I love data analytics in order to solve real problems so I am starting a new personal development journey to learn SQL and Interactive Dashboard Programs in order to turn this personal quest into a professional quest. Keep the videos coming so I can keep learning! USA viewer and new subscriber.

[@neelabh2120]

Hi, can you please share the data sheet as I cannot access it?

[@SSPanesar]

I think, this man is crazy about Excel. Amaging work n way of tutorials.

[@chandoo_]

🤣

[@MotiveEdge777]

Hi chandoo sir, I am one of the subscriber from Bangalore. I have been following you since 2 months.. Really a great source of learning. I used your approach in this video for making a call center dashboard at work. this was a 'one stop dashboard' with different dimensions of performance. it has really come out well and a lot of appreciation. All credits to you.its being used for our weekly reviews now.

[@chandoo_]

So nice to hear this success story JL. More power to you. ⚡

[@tonyclinton7588]

okay this background song so intersrting and really encouraging to learn quite honestly

[@siafajohnson]

This was really helpful and interesting, I love how you combined the concepts to create such an amazing interactive dashboard. Kudos to you Mr. Chandoo.

[@akashverma5756]

I have been underestimating excel for my whole life. 😀😀

[@ToThoseWhoVanished]

Sound affects are over the top. Nuisance in a calm video.

[@chandoo_]

Wow, really? I thought they are not too bad and help you see take note of the action in otherwise busy screen.

[@ToThoseWhoVanished]

@@chandoo_ Yes, very busy and knowledgeable video. A fan of your videos, keep them coming 👍👍

[@arvindr2101]

Superb efforts in making us more knowledgeable in our journey learning various facets embedded in Excel. Once again a big Thank you to you.

[@chandoo_]

It is a joy to create beautiful things and share it with the world Arvind.

[@ChewyLampShade]

Your creativity continues to amaze me! Thanks for all of the great, informative content.

[@chandoo_]

My pleasure!

[@mickaell3451]

Awesome as always. So many cool tricks in one place to get something phenomenal. This is art my sir.

[@chandoo_]

Thanks Michael. I had loads of fun building the dashboard.

[@chikachika809]

I love your videos sir, so powerful. Just a beginner in the data analyst journey...and taking notes always while watching your videos.

[@chandoo_]

You are very welcome

[@Jobin.Thomas]

I have only one doubt.. when I will finish watching your videos!! Thanks Chandoo 😊

[@chandoo_]

A good problem to have, I guess.😂

[@arbazahmad7177]

Very good explanation & easy to understand new things. In one word Awesome 👌

[@deepakca2001]

Again a great video and loads to learn.. Thank you Chandoo

[@chandoo_]

Glad you enjoyed it

[@mukesh4490]

Hey Chandoo, its a humble request from an Indian.... Please don't use the distorted map of India. J&K is an integral part of India. Love the excellent work done by you. Big fan

[@chandoo_]

Hi Mukesh... the maps are not pixel perfect representations of each country. They are just approximations. As mentioned in the video, I used github free map resource as drawing them with hand is impossible. You can see that almost all maps are distorted or incomplete. For ex: USA map excludes Alaska, Hawaii etc.

[@Pixceljunkee]

Hello Chandoo. A really great video tutorial. Learned a lot of new things and immediately recreated them. 5 stars for you

[@chandoo_]

Awesome to hear that Ralf.

[@Pixceljunkee]

@@chandoo_ I'm already looking forward to the second part

[@Harisgraphy2019]

You are amazing & rocking every day Cheers & Thanks!

[@chandoo_]

Wow. Thanks for the Super and love MI.

[@elbimboy]

blew my mind! wonderful video!

[@ken_9359]

That's awesome man. Can't wait 'till I get to your skill level.

[@chandoo_]

😎 I am sure you will get there with practice.

[@SyedMuzammilMahasanShahi]

Thanks Chandoo for this beautiful tutorial.

[@chandoo_]

I am glad you enjoyed it Syed.

[@scottjones1474]

Chandoo, where is the 2nd part to this video.. ? I enjoy watching your video's, I learn quite a lot from you

[@chandoo_]

Coming soon

[@bensonmukuria924]

@@chandoo_ did you ever make make part two?

[@dorcasoyibo1141]

Yes, please make part two. I want to complete the dashboard.

[@sthompson2839]

I love that you're using chocolate as the product. 😄

[@sumardjo]

Thanks for sample data ... I have follow video step by step to be learn thanks very much

[@bondnikunj]

i cant believe this video is free. Great work @chandoo. This is your best video

[@maroofsiddiqui]

And here I am struggling with Excel vs Google sheets

[@hodmechanical9707]

Google sheet is taking over Excel

[@vishalbhati912]

@@hodmechanical9707 it can not

[@chandoo_]

We all struggle with things. Give it time and practice enough and soon you will surprise yourself.

[@hodmechanical9707]

@@vishalbhati912 so far my work flow is concerned I use GS

[@alisaeed9095]

@@hodmechanical9707 but gs will never be able to take excel place

[@likhithlicky2947]

Awesome video...your teaching skills are more awesome than any chocolate in the world.....Powerful People Makes Excel More Powerful.....

[@chandoo_]

"Powerful People Makes Excel More Powerful" KGF style. Love it. 😍

[@mohdasadfarooqsiddiqui75]

Had fun making the dashboard Need part 2 fast

[@EahiaKhanFardin]

Hey Chandoo Sir,Great Video.

[@muraliiyer7850]

wonderful and fantastic dashboard.

[@chandoo_]

Thanks Murali.

[@vineshsingh764]

Who needs Payton or Java when Chandon here with excel

[@chrism9037]

Amazing Chandoo!

[@chandoo_]

You are welcome Chris.

[@naveedrandhawa511]

Chandoo sir you are rocks. keep it up

[@chandoo_]

Thank you Naveed.

[@The_1two3]

Hi Chadoo, really great video... one improvement - pl use correct map of India with POK as a part of India... please...

[@PraveenKumar-sj3sg]

HI Chanddo, Great video. that we can learn all types of formula in this video to create dashboard. I have one doubt in this can you please clarify in that. The doubt is that in this video in duration 44:58 you are using short formula yes this is available 365 excel what about the 2016,2015 excel which formula we have to use for this?. you really great in teaching but while using formula in excel 365 please inform us that which formula we can use instead of this .

[@MrAbhinav1982]

Hey Chandoo sir, amazing creation...I want to create a similar kind of Dashboard for Software Integration Testing, wherein I can get the Region-wise performance of - how many Test scripts executed / failed / Passed / In Progress Tester Daily / Weekly performance - Daily / Weekly Execution Run rate - Falling Behind score Defect Analysis - How many raised per day region wise - How many fixed, Retested per day region wise - How many pending to be fixed Overall Daily Script Category-wise Execution status Overall Weekly Script Category-wise Execution status Please help me out ...

[@arnabdey2825]

hello chandoo sir, I am using 2019 excel what are the alternatives to use sort fucntion

[@nitingupta6914]

Same problem face ,please suggest alternative

[@wajahathussain5899]

Dear sir....it's your utter beauty thay whenever you learn newer thing your shared it straight away..and it's your finest quality......I am true admirer of your skillset...and what a humble human being you are. The level of humility in your voice is true ✨ magic... it's been 3rd day of Eid and I can't wait to learn alot from you....🤲🤲🤲

[@chandoo_]

We all have the responsibility to be great, humble and sharing. I am glad you enjoyed this Wajahat.

[@VisuLytics]

Great video Chandoo G. Thanks a lot

[@chandoo_]

You are welcome Data Speaks.

[@kunalsarkar7960]

Hi Chandoo you're doing a great work...thank you so much ..its an amazing learning experience ..may god shower you with prosperity ....i have a small question ....profit% = profit / cost *100 .....then why did you divide profit with sum total cost

[@chandoo_]

You are welcome Kunal. No, you got the definition wrong. Profit % is always against sales.

[@nareshkumar-ug5sw]

Thank you very much..I have forwarded your video to my friends also

[@chandoo_]

Wow. Thanks Naresh.

[@proguysfunnies]

Hey Chandoo Sir, Great Video. I could not use SORT function in my excel. Its an older version so can you help me? which one should i use now?

[@thenewdataguy]

Really fancy, thanks for inspiration!

[@farhanreza9031]

Very nice dear Chandoo Channel, thanks for this powerful excel dashboard. but cant get access the full file of it.

[@chandoo_]

The link for blank file is in the video description. You can unlock completed workbook + in-progress files in my Excel School course.

[@Pixceljunkee]

Danke!

[@chandoo_]

Thanks Ralf for the love and super 😍

[@ajaybotanist7907]

Hi Chandoo sir, correct me if I am wrong, but I guess at 16:18 the formula to calculate profit % should be, total profit/total cost, not total profit/sum of amount

[@denisawhen134]

Wow...its indeed a beauty to behold....what you have done with excel...bravo.. Please I can't find the link to downloading the database used for this project

[@ganiyuyesirat1854]

Thanks Chandoo for this wonderful video again ...you are truly great at what you do. Please how should i go about the date, it's not displaying the hierarchy

[@stevesmith9459]

Excellent thank you for posting!

[@chandoo_]

You are welcome Steve.

[@lawlightplayz4071]

This is an awesome video but request you to make similar video for Ms Power Bi which will be helpful to people like me who are working on Ms Power Bi. Hope this request will be considered

[@imranjaffrey2195]

Great Video! Amazing style if tutorial very easy. Thanks!

[@chandoo_]

Glad you liked it!

[@Alexaurusy]

High class tutorial

[@sahityasoni6504]

Hello sir, Thanks for making these types of videos, But sir you used the India map excluding POK and Aksai Chin, these are integral parts of India, Please do use the correct map of India, Thanks a lot for the informative video Sir🙏🙏🙏

[@archieb1196]

Thank you Chandoo 🎈

[@chandoo_]

You are welcome Archie.

[@taizoondean689]

Sir thank you so much, very useful 🙏🙏

[@chandoo_]

You are welcome TD :)

[@banday78]

If you use power BI for all this, will it be more easy than doing in excel?

[@saliemruli1204]

Hi Chandoo thank you for your great video it is more than helpful and useful! I and majority are using old version of excel so i will be thankful if you can provide formula substitute for SORT function minute 45-47 of your video? I sow your links for ofset but it is bit not clear enough ! Thank you in advance!

[@sanjaygundlavkar3586]

Hello Chandu Sir, Great Video. Urge you to please use complete India Map Logo in your system. The current logo you used is incomplete map of india (See the Top side, Jammu & Kashmir State some part is missing in it. Please, request to rectify it Sir.

[@marinomendonca1859]

even if it is not reflecting Jammu and Kshmir it's still a great replica and a fantastic presentaion

[@szita2000]

This is your biggest concern.

[@sanjaygundlavkar3586]

@@szita2000 Nope. I appreciate Chandu sir's effort and he is really doing a genius works for all the Excel learners like of us who wants to use the power of excel.

[@TheMarketingMan4U]

​@@szita2000 yes coz its new Bharat.

[@amushkamohammed2064]

This is a dashboard tutorial? Why are you bringing up something as irrelevant as that

[@nainilmaladkar987]

Hi, I am using an older version of Excel and am unable to sort the table at 47:20 based on values. Please help out. Thank you for the tutorial

[@silverskyline3214]

It's Awesome Tutorials. Thank you for helping us provide valuable information ☺

[@chandoo_]

My pleasure 😊

[@GoldenSlumber474]

Thanks!

[@chandoo_]

Thanks for the super GS 😎

[@ronygeorge1996]

Can we add this as a project to Linkedin for data analyst jobs?

[@wangsatedja]

Its amazing brother.

[@chandoo_]

Thank you.

[@healthlife6081]

Hello chandoo i dont know if you will see this but if you do can you create a badget dashboard which can also compare either 2 month or a all year?

[@khushbookumari-xx9ue]

thank you so much it's very useful

[@chandoo_]

I am glad you found it useful Khushboo.

[@clivehybart540]

I have to say thank you from Wales for your entertaining and educational videos. I have an issue with the dashboard in that when I change a country graphic to refer to another map location it displays all the graphics in country,maps and when changed again breaks up the graphic so that I cannot select or delete it. Is this a problem you have seen with Office365?

[@chandoo_]

Thanks Clive. I have not noticed that issue. Can you try again by using the approach highlighted in the video or using the ideas presented here - chandoo.org/wp/how-to-use-picture-links/

[@clivehybart540]

@@chandoo_ I realise you can't get bogged down in this issue - just wanted to let you know I used the paste>picture link option but as soon as i changed the cell reference to refer to the named range map.x all i got was a full range of maps squished into one cell.

[@clivehybart540]

Chandoo do you have the completed file available to download by any chance as that may point me to an error I may be making that is not currently visible to me ? Grateful for any help as this is certainly a useful functionality

[@chandoo_]

It looks like a bug to me. The full file is part of my paid course and I can't make it available for free. I hope you understand.

[@clivehybart540]

@@chandoo_ of course. I tried using the graphics from the assts sheet and that resolved some problems but linking them was still an issue but don't worry I'll work on it till I get a resolution! Thanks for even taking the time to reply

[@Paul-b3e]

U did a nice job, but am frustrated, at last final formating of d bubble

[@parulkhurana6888]

Thanks

[@chandoo_]

Thank you so much for your love and super Parul 😍😍😍

[@rash9366]

as usual , great

[@nareshkumar-ug5sw]

Nice explanation...

[@chandoo_]

My pleasure.

[@chintalapalliprakash1493]

I love your work & learning new thinks daily.can you.make excel dash board for stock market thanks in advance

[@mjcharankumar2584]

Hi Chandoo, Sir, I wanted help from you at 27:39. The value of my last cell in the overall column is 1. I also checked the text value; it seems fine, but the value is 1 itself. The formula inscribed is =TEXT(V27, Y27). The course is fantastic, to be honest. Loved it

[@jacksonconnor5204]

i am having the same issue with the overall for the display for Profit %

[@siddhantpawar6583]

Change the cell format in last row of Format code column to Text

[@sriramk3696]

Sir i practice this vedio. I stopped at vedio time 43:40 #SPILL! but its showing #VALUE!. 2nd proublem why Excel 365 not showing at type of fourmula typeing =sort fourmal & =XMATCH. please give solution for futher going this vedio. Thank you very much sir for vedio uploading and sharing your knowledge to all learnes.

[@sumeetbehera1830]

Great sir 👌 I will try it for sure 🙌

[@chandoo_]

Awesome. Do let me know how it goes.

[@sumeetbehera1830]

@@chandoo_ sure 🙌

[@SKSolid479]

Hi Chandoo, Great Vid. Picked up a few formulas I don't normally use. For minute 46:48 you have selected countries and unselected countries pivots sorted the same and then reference the relative cells. However, it seems if any of the countries posted zero sales for any specific product category, you would get a misalignment of your reference data (since you would lose a value off the list, and the "show items with no data" option is not available when you're using pivot from Data model). Would you just use a lookup instead? How do you keep categories with no data from disappearing depending on your slicer selections?

[@chandoo_]

Thanks Seoung. We can use lookups. I think I have enabled the "show row / column labels with no values" option on the pivots to ensure we always get the full list. You can do this by going to Pivot Options.

[@rond9222]

Brilliant!

[@chandoo_]

Thank you Ron.

[@MONEYBASH]

Sir your videos are really awesum. have lernt a another edge of excel with your videos. Just a request if you can share atleast the raw data file with us can help a lot

[@chandoo_]

Hi Neha.. thank you. The blank data file is available for download. Please check video description.

[@MONEYBASH]

@@chandoo_ Thank You Sir

[@HariKrishna-yl9kq]

Super duper dashboard sir

[@chandoo_]

Thanks Hari.

[@iambelle5921]

Hi Chandoo, you have an awesome channel. I have a question in your sort formula =SORT(N63#, ....), what key to hit to have the # key group with cell address? I tried to hit manually the # key and some combination keys to enter but it's not working. This trick is really new to me, I really wanna know how. Thanks.

[@chandoo_]

Hi Belle.. Thank you :) You just type the # manually after the address. For more on this feature, see my spill range video - kzbin.info/www/bejne/oYOZlK2Bjpl5e9k

[@PapaPapa-ls5lo]

Can I make this & use in my portfolio, it give my portfolio strength as a beginner job seeker?

[@chandoo_]

As long as you credit the sources. You don't want a recruiter to findout the other way.

[@PapaPapa-ls5lo]

@@chandoo_ yup😅

[@how2bi344]

Are the values in the blank data file a bit different ? because my total cost, profit etc are different than in the video?

[@chandoo_]

Check again. That said, it shouldn't matter as the numbers and data is all randomly made up.

[@notgivingfvck603]

Halo sir, thank you for your great video. However, I'm struggling with sort function since I just have ms office 2019 and cannot use that function. I have no idea what is formula that similar with sort function. If you don't mind, could you provide a formula which could used to solve my problem?

[@chandoo_]

Hi NF.. SORT etc. are only in Excel 365. For older versions, to sort the data, you can the approach highlighted here - chandoo.org/wp/excel-kpi-dashboard-sort-2/ chandoo.org/wp/sorting-text-in-excel-using-formulas/

[@StockData.in0]

@@chandoo_ Thank you sir

[@shakthiatukorala595]

Great...!👍👍👍

[@chandoo_]

Thank you.

[@ramachandrankunduthody4906]

can you suggest a simple method to display a scrolling Bus timing data on a TV using Excel data?

[@chandoo_]

You can build a simple macro to auto-scroll the page in a loop.

[@Lakshmanan-og2ws]

have you give some tips for app sheet ..

[@rajaman5570]

Hello Chandoo Sir, I am using Excel 2013 for building this Dashboard but Iam unable to use the Measure feature in Pivot table which for creating the Custom Total Shipment .

[@vaischronicles]

awesome

[@shekhargupta8406]

Sir i am MBA final year student can i upload the dashboard on LinkedIn after performing all the steps you have told to us??

[@devika9100]

Hi Chandoo Do you have complete course on Data Analyst.

[@chandoo_]

Yes, I do. Check out my Excel School program - chandoo.org/wp/excel-school-program/

[@angiepresh8755]

Please can I get the data set used in this tutorial 🙏🏾🙏🏾🙏🏾…I’d really appreciate this

[@chandoo_]

Check the video description brother.

[@angiepresh8755]

Thank you!!! Please I’m having difficulty to move on from integrating the slicers. How did you move the slicer to the dashboard? I clicked on the slicer and press ctrl X but still not working and I can’t copy and paste the second pivot table because of it…Please help it urgent

[@angiepresh8755]

From 30-33mins

[@cht10]

Hi Chandoo sir, I am big learner to your videos. I was came up with one problem statement. There are multiple files in 3 folders. Want to compare all 3 folders and get common files in new folder. Any help from excel on this? or can we do same for 3 column data to find and list duplicate cells from all 3 column?? Please provide some help. Cheers!

[@chandoo_]

You are welcome Chaitanya. If I am in a hurry, I just copy paste the files in to one folder. Windows gives you a warning if the pasted file is a duplicate and you can skip such files easily.

[@sivaprasad3172]

Hi Chandoo Sir...when i tried copying the category slicer from calculation sheet to the dashboard sheet, only the MoM % values are changing but not the selected values. Iam stuck at this point. Please help me out with this.