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 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!
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 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
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
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 :)
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 :))
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.
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.
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
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.
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.
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 ?
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😂
Created a similar dashboard for weekly and monthly performance for a department meeting, can say managers were impressed. Thank you and amazing guides.
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.
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!
35 seconds of the entire clip was golden for me and worth a big thumbs up!
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 :)
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
Just wanted to tell you thank you so much. I followed this to a tee over many hours and got a beautiful result.
awesome n so cool dashboard, no any info-graphic paid sheet required. i will try this soon. thanks.....u deserve many likes. great tutorial
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
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!
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!
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
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 blew my mind. I had no idea that all this could be done with excel
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.
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.
Really! Are you saying I spent hours getting that line straight on my resumes when all I have to do is press shift? Thanks stranger :)
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 😊
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 :))
I did not know an Excel Dashboard could look so pretty. Mind Blown.
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 !
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! :)
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.
What a fine intro in only half an hour! Thank you.
Thanks for your positive feedback :)
You just saved me working on my assignment and I have no words to thank you!! God bless you!
I will put a like without view any of your vids,
You are amazing and your tutorials are impressive,
God bless and please you.
Nicely done!! It almost looks as good as a Power BI dashboard
This is an awe-inspiring dashboard, it could be evenly matched with Power BI, well done !
👍👍👍👍
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 tutorial was amazing. You can make the work look so much better, improving the overall quality and making it look so premuim.
Outstanding presentation! Very impressed by the use of filters and slicers to achieve a dashboard effect. Thanks for this!
I was expecting tons of functions and equations but it's so simple and elegent omg... fantastic
I just watched this, wish I could found this video earlier. Excellent tips, thanks for sharing man! Awesome work!.. :)
Excellent video! Now my dashboard looks really professional after watching your video!
It was like a beautiful building built in front of eyes.
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
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 :)
I love videos like this, you learn all sorts of cool new features in Excel
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 :)
Holy cow that slicer feature is a game changer! Thanks man!
Great tutorial! Looks very nice!
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.
Very well done, I learned more just now than i have in the last month about this...
One of the best videos I've seen so far. Thank you so much for this amazing video! 👏
Very good result, elegant and functional design. Thank you.
Most beautiful Excel Dashboard video seen till date.
I'm seriously impressed
Never thought Excel could be this beautiful. Now it's time for me to advance my Excel skill during this pandemic 😬
EXCELENT DASHBOARD ... incredible desing!!! thank you very much.
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 👍
That was awesome. And better then tableau nonsense.
Wahnsinn! Nach so etwas habe ich immer gesucht! Tolles Design und super erklärt! Weiter so :-)
You're my hero! Great job!! Made a version of my own based on this :)
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.
It’s a professional product!
This was a tight 30 minutes of instruction. Excellent video.
Thanks, Fred :) Great to hear that.
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
Simply superb, never knew you could do all of this in EXCEL, great work and thanks for sharing it.
Amazing , so simple , well explained and can be used for so many things
My weekly reports will be looking so much better now! :O Gonna practise this over the weekend.
Thanks, @TheOfficeLab!
Just wow!!! Learned a lot in this one video.. Very informative dashboard..
It's worth watching the video. I am amazed at the content created and shared. Thanks. It is absolute learning.
Beautiful I'm crying
don't cry for me Argentina
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) ?
Wow, this is wonderful! Will be so useful for my presentation. Thank you
very nice.
You just gave quite a number of people the knowledge to become the office hero!
Amazeballs! Thank you so much for the work that you put into demonstrating such a useful way of visualising data :)
You‘ve just given me an inspiration for an actual problem at work! Thanks!
Great to hear that :)
This is so beautiful! You're a magician!
Good use of slice function , liked.
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.
this is great! aesthetics is also sleek. thanks for sharinh this. :)
I love how detailed your dashboard. I must confess your good in colour selection. Hoping to give replicate this :)
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.
Thanks for posting this and sharing your knowledge now im so excited to apply this in my work.
Damn, that is a great feature the map graphic. Wish Numbers has it.
So Beautiful and fluid... Thanks hoping to use this in my summer internship
awsome job i ll aplly for my hr dashboard thank you for tips
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 😊
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*
Very intuitive video. Thank you for sharing this.
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!
awesome, I just built my first dashboard thanks to you. thank you for sharing
Ótimo trabalho, didática fácil de grande nível 👏👏
I really like your concept and how you teach. Very easy to understand. Thank you for your tips
Thanks Pulnisa, great to hear that :)
Can I download this Excel file please? Thanks!
where did you get the excel file ?
professionally done, simply explained, thank you very much
Excuse me sir... I salute you.
Great video, I already know what I will do on Monday! My only advice would be to try to do a 15-20 min video. Once again it's excellent!
Simplesmente show!!!
Parabéns!!!
Kudos to you sir.. awesome design I actually became your fan with this dashboard
That's great to, Mandar :) Thank you! There will be even more dashboard content on my channel in the close future, so stay tuned.
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
Thank goodness you've improved the screen recording and microphone since this video. Thirty columns!!
Thats a hell of a dashboard! Maaan i need to learn how to do this ASAP🙌
2022 and this still helped me create my first dashboard. Thank you