I got an internship a year ago thanks to a dashboard that I created following this video! Thanks random internet stranger, you are doing a lot of good.
Haha that's funny I came across this comment. I'm in my second week of my internship and I'm here because I need to create an Excel sheet and I want to make it look really nice!
@@theofficelab Hey when applying the background my image is tiling, could you pls share the image that you have used? or let me know if the image needs to be a particular size?
Raise your hand if the hardest part of the dashboard was finding the right background :) Thankyou for this Office Lab, it was so well explained and slicers blew my mind!
Created a similar dashboard for weekly and monthly performance for a department meeting, can say managers were impressed. Thank you and amazing guides.
I just entered marketing industry and cant believe that this is not common practice! Thank you so much for helping me to say goodbye to ugly grey reports!
I have always been using those functionalities but I have never thought it could look that good with that little effort. I will definetely upgrade my dashboards! Thanks a lot for the inspiration!
What a smooth tutorial. First I look to the duration and "Man 30 minutes! Should be lot of works". Since I really have no idea at all to create a dashboard I decide to try to watch every single minute of this video and surprisingly I really enjoy it! You explain it calmly yet I can feel your excitement and passion! I feel it, man. That 30 minutes are worth every second of it. Good job!
Thanks, man :) It's awesome to hear that you enjoyed it and that you took the time to give me that overwhelmingly positive feedback. I am currently working on an even more advanced Excel Dashboard and will release a tutorial on that in the near future. I hope you gonna enjoy that just as much. Have a great day!
You people really have to admire this guy's work. Imagine! He's using Excel for Mac and came with such a cool looking design! Side note: Office for Mac is horribly bad, whenever I need office work done, I instantly switch to Windows (Bootcamp) since I can't really stand it
TIMESTAMPS: 1:20 - Data 2:12 - Pivot Tables & Charts 8:15 - Dashboard Structure 15:40 - Dashboard Charts 22:43 - Dashboard Filters NOTES: 1. DATA - Insert data in a separate spreadsheet. Any data of your interest will do. 2. PIVOT TABLES & CHARTS • Insert Tab > Pivot Table > Range > Customize > Highlight Pivot Table Made > Choose a Chart - Date: Check if there's quarterly & delete if needed. - Maps: Copy the values/table for the regions/states from the pivot tableb; paste in a separate cell; delete numeric values in the pasted cell then create a reference to the pivot table. - Revenue: Sort your pivot table to sum of revenue. NOTE: Create a separate spreadsheet for each pivot table if needed. 3. DASHBOARD STRUCTURE - Customize by inserting text box, line (to separate the header), and tile design (rectangle; no line; adjust transparency). - To add background, go to Page Layout > Background. - While naming each charts, insert icons. 4. DASHBOARD CHARTS - Copy & Paste the charts from different spreadsheets to the dashboard. - Customize by deleting lines and title, and adjusting to no fill, shade/colors, font size/style, and numeric values to no decimal. 5. DASHBOARD FILTERS • Click Chart > Insert Slicer > Choose Filters • Right-click Slicer > Report Connections > Choose Pivot Table/s > Let me know in the reply section if there's anything I'd miss. Let's help each other :))
Great Tutorial, thank you for this nice design! One thing to your "horizontal" line: Just press the shift button while drawing the line and it will be perfectly horizontal (or vertical or 45~, as you wish) ;-)
Lost for words.... Just like Columbo, you show the killer within the first few moments of the video, however with this Video I watched it in its entirety, simply wonderful, so beautiful explained, and the final finish is not only technically proficient, but well explained. Most certainly Subscribed, you will certainly hear from me in the future. Thank you so very much :)
I've spent a long time wondering how to switch between data quickly in charts (all self taught on excel). The thing I've been looking for for so long is that slicer option!! thank you
I guess im asking the wrong place but does anyone know of a method to log back into an Instagram account?? I was stupid forgot the password. I would appreciate any help you can offer me!
@Nicholas Gerardo Thanks for your reply. I found the site through google and im waiting for the hacking stuff atm. Takes quite some time so I will reply here later with my results.
Tip: When creating the map chart, as you say you can't create the chart from the Pivot and therefore need to Copy Paste Values and create the Map chart, However once created you can edit the data source references by going to Chart Design>Select Data and pointing the references back to the original Pivot Table. Once done you can then delete the pasted values to clear clutter from your feeder worksheets. The other thing I would recommend is to ensure you label all of your Pivot Tables with sensible names, making the solution easier to maintain in the future.
I just got a new position at work and wasnt sure how to format the data for presentations. I think this is beautiful and Ill be giving it a try. Thank you for sharing.
Hello Everyone 👍 I have some BIG NEWS 🔥 I just launched my brand new website excelfind.com 🚀 On there, you will find the free version of this Dashboard for download. So I kindly invite you to check it out, and if you like it, feel free to share it with your friends and colleagues. Thank you 🔥 ▬▬▬▬▬▬▬▬▬▬ FAQ for this Video What Excel Version do you use in this video? I always have the latest Excel version that comes with Microsoft Office 365 Get it here ► @t Where can I get these beautiful icons? I got them from the huge icon library that is integrated in Excel and PowerPoint if you have Office 365. Where can I get the background image? I linked it for you here ►excelfind.com/tutorials/well-designed-and-interactive-excel-dashboard/
Hello Alex, Thanks very much for such informative video, I have learnt a lot... Just one thing borthering me is that how could change the BACKGROUND color of slicer to BLACK ?? please help me
@@amaadmahfooz8069 Format the Data Series by right clicking on the map. Then under the 'Series Options' you can change the 'Map Area' to 'Only regions with data'. That should fix it.
Fabulous work .. totally loved the design. Its so appealing to the eyes ! And I added couple of things more to this 1) Just the state/province map along with country which zooms relevant state when chosen (2) Names of top 5 States so the user don't need to hover on map to find top 5.
@@theofficelab I also tried to use image in background instead of inserting so that I can overlay max values of Revenues on each map from pivot sheets. But this caused me a problem - It increased the size of excel file a lot. So i tried to limit the size of each sheet by setting scrolling property but even that didn't help. Any suggestions how can I make cells values display on top of image and also not increase file size ?
Nice video! Re. drawing horizontal lines - hold Shift and draw the line - it should be perfectly horizontal. The end result looks great but I would lose the pie chart in any of its iterations - it's just chart junk, takes up far too much screen real estate and with two or three more items to display becomes very difficult for a user to gauge the relative size of the individual portions. Hope you don't think I'm being too negative - it really is a very good example of how to easily put together an interactive display.
best excel dashboard i have seen. I would look forward for more power automate and power query excel projects and if possible powerBI dashboard projects as well
30-years ago when computers were young, I remember having a discussion with a buddy and asked him, if you could only use 1 piece of software which would you use? He replied instantly saying, "A spreadsheet"... he was right and ahead of the times.
Unreal stuff! You have opened my eyes to a whole other world. I tried adding a background but it just ends up being way too big. Even if I zoom in or out it stays the same which is quite weird. Can you help out with that? Thanks!
Thanks for the great feedback :) Concerning your background issue, I faced the exact same issue with zooming and wasn't able to resolve that yet. However, in order to change the size of your background image you can adjust the size of the image before adding it into your excel file.
Sorry, I don't have the adjusted image file that I finally used on my computer anymore (only saved it temporarily). I recommend to just try out different image sizes to figure out what fits best for your purpose.
Wow! This is amazing. THANK YOU! This is a great lesson for building dashboards in Excel. Your explanations are so easy to follow and the video is straight to the point.
Completely loved this concept and Incorporated a version of my own for tracking my workout progress, thank you so much for uploading this! Is it possible to use a table diagram in the dasboard too? I'm trying to make one box in my dashboard represent Starting Point: [Value] Present: [Value] % Increase: [Value] As of right now, it is being placed in the cells underneath the background picture. :')
As I'm watching this video I'm thinking, "damn! this guy is moving fast! I have a lot of work to do if I want to get like this." Then I realized that my playback speed was at 1.5x from previous videos. Phew!
I got an internship a year ago thanks to a dashboard that I created following this video! Thanks random internet stranger, you are doing a lot of good.
Hi Joe,
that is awesome to hear! Thanks for letting me know 😊
I am really happy for you and wish you all the best for your future career 🔥
Haha that's funny I came across this comment. I'm in my second week of my internship and I'm here because I need to create an Excel sheet and I want to make it look really nice!
@@theofficelab Hey when applying the background my image is tiling, could you pls share the image that you have used? or let me know if the image needs to be a particular size?
@@theofficelab I'm also an equity analyst trainee and i was checking some good ideas too.. thanks!!
Raise your hand if the hardest part of the dashboard was finding the right background :)
Thankyou for this Office Lab, it was so well explained and slicers blew my mind!
My pleasure 😊
Literally searched the entire Internet trying to find this image .By any chance do you remember what it is 3yrs later😂
35 seconds of the entire clip was golden for me and worth a big thumbs up!
I really appreciate how you devote this clip VDO to everyone. This clip can help normal employee to be a professional employee within 30 mins.
Created a similar dashboard for weekly and monthly performance for a department meeting, can say managers were impressed. Thank you and amazing guides.
I just entered marketing industry and cant believe that this is not common practice! Thank you so much for helping me to say goodbye to ugly grey reports!
You are very welcome, MalaKuna1995! I am glad I was able to help and inspire you. I wish you all the best with your start in the marketing industry :)
I have always been using those functionalities but I have never thought it could look that good with that little effort. I will definetely upgrade my dashboards! Thanks a lot for the inspiration!
Thanks, Qrabbin! Always great to hear that :)
Man, I'm brazilian, so I don't understand all that you said, but the dashboard is so beautiful! I wish we have teachers like you here in Brasil
What a smooth tutorial. First I look to the duration and "Man 30 minutes! Should be lot of works". Since I really have no idea at all to create a dashboard I decide to try to watch every single minute of this video and surprisingly I really enjoy it! You explain it calmly yet I can feel your excitement and passion! I feel it, man. That 30 minutes are worth every second of it. Good job!
Thanks, man :) It's awesome to hear that you enjoyed it and that you took the time to give me that overwhelmingly positive feedback.
I am currently working on an even more advanced Excel Dashboard and will release a tutorial on that in the near future. I hope you gonna enjoy that just as much. Have a great day!
You just blew my mind! I had no idea that all this could be done with excel. I made a great dashboard because of your help. Thank you!
Thanks for your feedback, svijayiitk! It's great to hear that my video helped you :) Kind regards and have a great day.
@@theofficelab Bitteschon!
You people really have to admire this guy's work. Imagine! He's using Excel for Mac and came with such a cool looking design!
Side note: Office for Mac is horribly bad, whenever I need office work done, I instantly switch to Windows (Bootcamp) since I can't really stand it
This dashboard is effective and amazing! I transitioned in a new industry and creating this dashboard will dazzle my boss.
Thanks, Chris! Wish you all the best in your job.
you just blew my mind. I had no idea that all this could be done with excel
Just wanted to tell you thank you so much. I followed this to a tee over many hours and got a beautiful result.
TIMESTAMPS:
1:20 - Data
2:12 - Pivot Tables & Charts
8:15 - Dashboard Structure
15:40 - Dashboard Charts
22:43 - Dashboard Filters
NOTES:
1. DATA
- Insert data in a separate spreadsheet. Any data of your interest will do.
2. PIVOT TABLES & CHARTS
• Insert Tab > Pivot Table > Range > Customize > Highlight Pivot Table Made > Choose a Chart
- Date: Check if there's quarterly & delete if needed.
- Maps: Copy the values/table for the regions/states from the pivot tableb; paste in a separate cell; delete numeric values in the pasted cell then create a reference to the pivot table.
- Revenue: Sort your pivot table to sum of revenue.
NOTE: Create a separate spreadsheet for each pivot table if needed.
3. DASHBOARD STRUCTURE
- Customize by inserting text box, line (to separate the header), and tile design (rectangle; no line; adjust transparency).
- To add background, go to Page Layout > Background.
- While naming each charts, insert icons.
4. DASHBOARD CHARTS
- Copy & Paste the charts from different spreadsheets to the dashboard.
- Customize by deleting lines and title, and adjusting to no fill, shade/colors, font size/style, and numeric values to no decimal.
5. DASHBOARD FILTERS
• Click Chart > Insert Slicer > Choose Filters
• Right-click Slicer > Report Connections > Choose Pivot Table/s
> Let me know in the reply section if there's anything I'd miss. Let's help each other :))
thanx a lot!
YOU ARE A GOD SEND!!!
I did not know an Excel Dashboard could look so pretty. Mind Blown.
Great Tutorial, thank you for this nice design! One thing to your "horizontal" line: Just press the shift button while drawing the line and it will be perfectly horizontal (or vertical or 45~, as you wish) ;-)
Thank you, BikerMeise :) That is a great advice btw.
This the most polite and useful comment on RUclips i've ever seen.
I will put a like without view any of your vids,
You are amazing and your tutorials are impressive,
God bless and please you.
This was one of the best tutorials I've seen on a fairly complex set of Excel features. Well done!
Thank you. I appreciate it!
Lost for words.... Just like Columbo, you show the killer within the first few moments of the video, however with this Video I watched it in its entirety, simply wonderful, so beautiful explained, and the final finish is not only technically proficient, but well explained. Most certainly Subscribed, you will certainly hear from me in the future. Thank you so very much :)
Thanks, Phill! I appreciate your kind feedback 😊
I've spent a long time wondering how to switch between data quickly in charts (all self taught on excel). The thing I've been looking for for so long is that slicer option!! thank you
This was a tight 30 minutes of instruction. Excellent video.
Thanks, Fred :) Great to hear that.
awesome n so cool dashboard, no any info-graphic paid sheet required. i will try this soon. thanks.....u deserve many likes. great tutorial
What a fine intro in only half an hour! Thank you.
Thanks for your positive feedback :)
I'm seriously impressed
Excellent video! Now my dashboard looks really professional after watching your video!
Well done Bro :) that's a really beautiful dashboard
It’s indeed spectacular when professionals support each other.
I guess im asking the wrong place but does anyone know of a method to log back into an Instagram account??
I was stupid forgot the password. I would appreciate any help you can offer me!
@Nelson Samir Instablaster =)
@Nicholas Gerardo Thanks for your reply. I found the site through google and im waiting for the hacking stuff atm.
Takes quite some time so I will reply here later with my results.
@Nicholas Gerardo it worked and I now got access to my account again. I'm so happy!
Thank you so much you saved my account !
Wow I have to give it to you this is one sharp dashboard. I love that you didn't to anything complicated to design it. Thanks!
You just saved me working on my assignment and I have no words to thank you!! God bless you!
Tip: When creating the map chart, as you say you can't create the chart from the Pivot and therefore need to Copy Paste Values and create the Map chart, However once created you can edit the data source references by going to Chart Design>Select Data and pointing the references back to the original Pivot Table. Once done you can then delete the pasted values to clear clutter from your feeder worksheets. The other thing I would recommend is to ensure you label all of your Pivot Tables with sensible names, making the solution easier to maintain in the future.
That was awesome. And better then tableau nonsense.
Never thought Excel could be this beautiful. Now it's time for me to advance my Excel skill during this pandemic 😬
It’s a professional product!
Holy cow that slicer feature is a game changer! Thanks man!
I just watched this, wish I could found this video earlier. Excellent tips, thanks for sharing man! Awesome work!.. :)
Good use of slice function , liked.
Great tutorial! Looks very nice!
wow that was amazing bro ....... more videos like this
Thank you! There will be a lot more videos like this coming in the next months. Stay tuned 😊
Very well done, I learned more just now than i have in the last month about this...
Wahnsinn! Nach so etwas habe ich immer gesucht! Tolles Design und super erklärt! Weiter so :-)
Danke dir, Patrick 😊
Nicely done!! It almost looks as good as a Power BI dashboard
Most beautiful Excel Dashboard video seen till date.
Outstanding presentation! Very impressed by the use of filters and slicers to achieve a dashboard effect. Thanks for this!
You are genius.. 👌
Thank you 😊
EXCELENT DASHBOARD ... incredible desing!!! thank you very much.
I just got a new position at work and wasnt sure how to format the data for presentations. I think this is beautiful and Ill be giving it a try. Thank you for sharing.
That's awesome to hear. I wish you all the best in your new position! :)
Great Stuff - explanation is simple and easy to understand like a pro
Thank you, LAWN 2121! It's always great to get such a positive feedback :)
Good Job, Thanks
Very good result, elegant and functional design. Thank you.
This tutorial was amazing. You can make the work look so much better, improving the overall quality and making it look so premuim.
It was like a beautiful building built in front of eyes.
I was expecting tons of functions and equations but it's so simple and elegent omg... fantastic
Hello Everyone 👍 I have some BIG NEWS 🔥
I just launched my brand new website excelfind.com 🚀
On there, you will find the free version of this Dashboard for download. So I kindly invite you to check it out, and if you like it, feel free to share it with your friends and colleagues. Thank you 🔥
▬▬▬▬▬▬▬▬▬▬
FAQ for this Video
What Excel Version do you use in this video?
I always have the latest Excel version that comes with Microsoft Office 365
Get it here ► @t
Where can I get these beautiful icons?
I got them from the huge icon library that is integrated in Excel and PowerPoint if you have Office 365.
Where can I get the background image?
I linked it for you here ►excelfind.com/tutorials/well-designed-and-interactive-excel-dashboard/
Hello Alex, Thanks very much for such informative video, I have learnt a lot...
Just one thing borthering me is that how could change the BACKGROUND color of slicer to BLACK ?? please help me
Registered to your site but did not receive password for downloading stuff. Where can I get the password?
@@khopkarrohitdid you check the 'Spam' or 'Promotion' folder? Sometimes our mails are mistakenly redirected into one of these.
Hi @@theofficelab, when I try to create the pivot for sales by region it shows the world map instead of showing only the US. How can I fix this?
@@amaadmahfooz8069 Format the Data Series by right clicking on the map. Then under the 'Series Options' you can change the 'Map Area' to 'Only regions with data'. That should fix it.
Fabulous work .. totally loved the design. Its so appealing to the eyes !
And I added couple of things more to this
1) Just the state/province map along with country which zooms relevant state when chosen
(2) Names of top 5 States so the user don't need to hover on map to find top 5.
Thanks, Vineet. That's awesome to hear :)
@@theofficelab I also tried to use image in background instead of inserting so that I can overlay max values of Revenues on each map from pivot sheets. But this caused me a problem -
It increased the size of excel file a lot. So i tried to limit the size of each sheet by setting scrolling property but even that didn't help. Any suggestions how can I make cells values display on top of image and also not increase file size ?
@@vineetsansi The only way I can think of is to compress that image.
Ok, i tried that but need something more. Thanks anyways!!
Hello Vineet, could you show a pic of the result of 1) & 2) ?
Nice video!
Re. drawing horizontal lines - hold Shift and draw the line - it should be perfectly horizontal.
The end result looks great but I would lose the pie chart in any of its iterations - it's just chart junk, takes up far too much screen real estate and with two or three more items to display becomes very difficult for a user to gauge the relative size of the individual portions.
Hope you don't think I'm being too negative - it really is a very good example of how to easily put together an interactive display.
This might be the most helpful video on the Internet. I was able to put this to use right away!
Thanks, Alicia. That is awesome to hear :) There will be a lot more awesome dashboard content coming soon on my channel.
Beautiful I'm crying
don't cry for me Argentina
this is some high level excel tutorial
Fantastic tutorial, really helped me out a lot. Great content and got straight to the point which is hard to find these days, kudos to you sir
Thank you, Stuart :)
very nice.
You just gave quite a number of people the knowledge to become the office hero!
You're my hero! Great job!! Made a version of my own based on this :)
best excel dashboard i have seen. I would look forward for more power automate and power query excel projects and if possible powerBI dashboard projects as well
Amazing , so simple , well explained and can be used for so many things
You‘ve just given me an inspiration for an actual problem at work! Thanks!
Great to hear that :)
Just wow!!! Learned a lot in this one video.. Very informative dashboard..
One of the best videos I've seen so far. Thank you so much for this amazing video! 👏
Wow, this is wonderful! Will be so useful for my presentation. Thank you
I love videos like this, you learn all sorts of cool new features in Excel
This is so beautiful! You're a magician!
Wow. Just wow! Beautiful work!
Thank you very much!
Somebody said, Excel is the most powerful software ever built.
Now I see why
30-years ago when computers were young, I remember having a discussion with a buddy and asked him, if you could only use 1 piece of software which would you use? He replied instantly saying, "A spreadsheet"... he was right and ahead of the times.
@@renehouse2015 wise man
You can't possibly explore all excel features in a lifetime
My weekly reports will be looking so much better now! :O Gonna practise this over the weekend.
Thanks, @TheOfficeLab!
this is great! aesthetics is also sleek. thanks for sharinh this. :)
I have been working in controlling and worked with Excel a lot.
For our purposes 'looks' never mattered but that is a really fine job 👍
Amazeballs! Thank you so much for the work that you put into demonstrating such a useful way of visualising data :)
Very intuitive video. Thank you for sharing this.
awsome job i ll aplly for my hr dashboard thank you for tips
professionally done, simply explained, thank you very much
Excelent! I don't need tableau anymore thanks!!
Zoom out the screen next time!overall good presentation!!!
In fact you can use Power BI instead, same from Microsoft and powerfull than Excel, free for personal usage.
It's worth watching the video. I am amazed at the content created and shared. Thanks. It is absolute learning.
Ótimo trabalho, didática fácil de grande nível 👏👏
awesome, I just built my first dashboard thanks to you. thank you for sharing
Unreal stuff! You have opened my eyes to a whole other world.
I tried adding a background but it just ends up being way too big. Even if I zoom in or out it stays the same which is quite weird. Can you help out with that? Thanks!
Thanks for the great feedback :) Concerning your background issue, I faced the exact same issue with zooming and wasn't able to resolve that yet. However, in order to change the size of your background image you can adjust the size of the image before adding it into your excel file.
Thank you so much for the response. Could you let me know the size / specifications of the picture you used?
Sorry, I don't have the adjusted image file that I finally used on my computer anymore (only saved it temporarily). I recommend to just try out different image sizes to figure out what fits best for your purpose.
Wow! This is amazing. THANK YOU! This is a great lesson for building dashboards in Excel. Your explanations are so easy to follow and the video is straight to the point.
Completely loved this concept and Incorporated a version of my own for tracking my workout progress, thank you so much for uploading this!
Is it possible to use a table diagram in the dasboard too? I'm trying to make one box in my dashboard represent
Starting Point: [Value]
Present: [Value]
% Increase: [Value]
As of right now, it is being placed in the cells underneath the background picture. :')
I would like to see this application.
@Crebs Park if not, what are you using? I dont think there are any apps better and easier to use
@Crebs Park I see your going far in the professional business.
@Crebs Park you're
@Crebs Park you're*
This is an awe-inspiring dashboard, it could be evenly matched with Power BI, well done !
👍👍👍👍
Simplesmente show!!!
Parabéns!!!
This is super great - I will will blow the minds of my HR colleagues - thanks for the video ! Keep more coming
That's great to hear, thecrow. Thank you! There will be coming more great dashboard content soon. Stay tuned :)
Damn, that is a great feature the map graphic. Wish Numbers has it.
Thanks!Good job!You 're great teacher!!
Thank you, Muhammet. I appreciate it!
As I'm watching this video I'm thinking, "damn! this guy is moving fast! I have a lot of work to do if I want to get like this." Then I realized that my playback speed was at 1.5x from previous videos. Phew!
So Beautiful and fluid... Thanks hoping to use this in my summer internship
Can I download this Excel file please? Thanks!
where did you get the excel file ?
Thank goodness you've improved the screen recording and microphone since this video. Thirty columns!!
Excuse me sir... I salute you.
Simply superb, never knew you could do all of this in EXCEL, great work and thanks for sharing it.
Your skill in Excel makes me want to just give up.
Thanks, mate. However, I hope you won't give up on Excel ;)
This was so easy to understand. Ive gone through a lot of sites but this is beyond nice
This might be a heavy file
Saving as XLSB reduces the file size
2022 and this still helped me create my first dashboard. Thank you