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.

35 seconds of the entire clip was golden for me and worth a big thumbs up!

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!

I just watched this, wish I could found this video earlier. Excellent tips, thanks for sharing man! Awesome work!.. :)

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!

Outstanding presentation! Very impressed by the use of filters and slicers to achieve a dashboard effect. Thanks for this!

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!

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.

Very well done, I learned more just now than i have in the last month about this...

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) ;-)

This was one of the best tutorials I've seen on a fairly complex set of Excel features. Well done!

You just saved me working on my assignment and I have no words to thank you!! God bless you!

I'm seriously impressed

Amazing , so simple , well explained and can be used for so many things

Created a similar dashboard for weekly and monthly performance for a department meeting, can say managers were impressed. Thank you and amazing guides.

This tutorial was amazing. You can make the work look so much better, improving the overall quality and making it look so premuim.

Well done Bro :) that's a really beautiful dashboard

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

You're my hero! Great job!! Made a version of my own based on this :)

you just blew my mind. I had no idea that all this could be done with excel

Very good result, elegant and functional design. Thank you.

EXCELENT DASHBOARD ... incredible desing!!! thank you very much.

Just wow!!! Learned a lot in this one video.. Very informative dashboard..

It’s a professional product!

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

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/

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 👍

Great tutorial! You've inspired me to really amp up some of my reports! Thank you!

Wow, this is wonderful! Will be so useful for my presentation. Thank you

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

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!

Thank you so much for providing this video. Helped me build a great Department Headcount & Total Salary Dashboard for my job.

this is great! aesthetics is also sleek. thanks for sharinh this. :)

This is so beautiful! You're a magician!

Loved this. I plan to use this concept in some of my dashboard designs.

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.

awsome job i ll aplly for my hr dashboard thank you for tips

Nicely done!! It almost looks as good as a Power BI dashboard

I was really impressed to see this tutorial. Very nicely explained and it easy to grasp ! Keep it up!

My weekly reports will be looking so much better now! :O Gonna practise this over the weekend. Thanks, @TheOfficeLab!

It was like a beautiful building built in front of eyes.

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.

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

Beautiful I'm crying

Damn, that is a great feature the map graphic. Wish Numbers has it.

thank you so much!! this is more than excel pivot charts skills but also a sense of beauty！ great job~

Thanks, man! It was a clear tutorial. Just what I needed.

Great tutorial! Looks very nice!

That was awesome. And better then tableau nonsense.

Wow. Simply amazing. What a design! Thank you very much.

This is the best tutorial! Thank you so much!

Great Stuff - explanation is simple and easy to understand like a pro

Ótimo trabalho, didática fácil de grande nível 👏👏

This is super great - I will will blow the minds of my HR colleagues - thanks for the video ! Keep more coming

I am superthankfulllll you did this kind of content! Very helpful love it!😊

Simplesmente show!!! Parabéns!!!

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!

I love the design. Thank you so much for the tutorial. You have got a new subscriber.

Simply superb, never knew you could do all of this in EXCEL, great work and thanks for sharing 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 :))

Amazeballs! Thank you so much for the work that you put into demonstrating such a useful way of visualising data :)

This dashboard is effective and amazing! I transitioned in a new industry and creating this dashboard will dazzle my boss.

I wish I would have seen this before! Great work and many thanks for sharing!!

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. :')

Excelent! I don't need tableau anymore thanks!! Zoom out the screen next time!overall good presentation!!!

Wow that is amazing! Love the design

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!

Somebody said, Excel is the most powerful software ever built. Now I see why

Can I download this Excel file please? Thanks!

Awesome video, very usefull. Easy to follow. Thanks a lot!

I was expecting tons of functions and equations but it's so simple and elegent omg... fantastic

Excuse me sir... I salute you.

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 love videos like this, you learn all sorts of cool new features in Excel

What a fine intro in only half an hour! Thank you.

This might be a heavy file

Your skill in Excel makes me want to just give up.

Holy cow that slicer feature is a game changer! Thanks man!

Simply awesome.. Benefited a lot.I think its not fare, if I dont appreciate you for sharing your knowledge.God bless you

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.

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!

This was so easy to understand. Ive gone through a lot of sites but this is beyond nice

I did not know an Excel Dashboard could look so pretty. Mind Blown.

This might be the most helpful video on the Internet. I was able to put this to use right away!

Great job!! Thank you for the explanation. Could you please share a sample of your data so that we can practice using the same structures ?

You‘ve just given me an inspiration for an actual problem at work! Thanks!

very good tutorial. easy to follow and very productive! thank you!

great video, I would recommend some sound absorption or a condenser mic to reduce room reverb audio when you speak

Nice work done! Really helpful.

Man this is awesome! Thank you for sharing !

Amazing!!! Very well explained. Thanks a lot!

Awesome! Thank you for your generosity and sharing!

One of the best videos I've seen so far. Thank you so much for this amazing video! 👏

This is an awe-inspiring dashboard, it could be evenly matched with Power BI, well done ! 👍👍👍👍

I really like your concept and how you teach. Very easy to understand. Thank you for your tips

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!

Nicely done. Thanks for the tutorial.

Quick and clean! thanks for sharing!

This is really nice. Can't wait to create a similar dashboard..I like your colour combination too.