I dont know how this came in to my recommended but I'm glad it did xD never knew excel sheets can become a piece of art...Looking like professionally designed analytics dashboards damm!
I love how they allow you to purchase the template, but also give the tutorial if you want to learn or make it yourself for free (aside from the cost of excel of course). This is sure to impress employers, especially since they never think much of "proficient in excel" on applications.
Oh they do, but that "proficiency" amounts to knowing how to use pivot tables. This stuff right here will completely blow them off the face of the Earth.
@@BeyondTheIslands Yeah you're right, I've seen "proficiency in excel" among other microsoft office applications in under the job requirement for jobs that won't touch a goddamn computer. It's like the joke about having to reverse binary trees in an interview for a middle school IT position
No one is going to be impressed by this. This is pure fluff, there is zero interactivity with the data, you can't drill-down or segment it, it's style over any substance. Excel is meant for presenting data in as simple and impactful a way as possible, you would be laughed out of an interview at a corporate with this.
@@mdc123-v2v If Excel were just about data entry, there would be no need for any of it's functionality. The point of this dashboard is that it calculates the statistics from the data entry and displays them on a readable dashboard with graphs that display the importance of the information. More importantly, if shows that you clearly know your way around excel. Any employer who would laugh at this just because of the fluff should be fired
@@mdc123-v2v customers eat that shit up like it's froyo. Excel is meant for presenting data. Simple and impactful is just what you like. If excel was only about data, you'd easily do with a database engine instead.
As a graphic designer with decades of experience in data visualization, I am very, very happy to have found this. I have a feeling I'll be using some of your templates in the future. :)
Dude this is ANOTHER LEVEL! I've been doing simple excel dashboards and successfully impressed my employers, but this kind of dashboard is going to make their minds blown away! will absolutely try this in my next project. Thanks for sharing!
@@Arddy I was only developing simple dashboards with simple charts before stumbled upon this video. Now I managed to develop dashboards that look like professional websites. So, this method is obviously better than mine! 😄
let me say this clearly. the entire world financial markets rely on, depend on, and exist solely on MS excel. if they sent out a "nuke" command code via an update the worldwide economy would crash and we would have instant wars.
True, I was mind blown when I first discovered what can be done with PowerPoint, seeing the same being the case for Excel is just, wow. As a student, I guess it's time to learn some Excel.
@@OtherLevels wouldn't that be just crazy and so unique! You pull that off and if I were you then I would build a whole community around that and sell your excel-based games as NFTs! Imagine that!
@@rinnepy depends what you’re trying to use photoshop to do but since all images pasted within office programs are in layers you’d be surprised and how much you could do. Just would take a lot more time since it isn’t tailored for the use case. Being someone who likes to create original digital art within programs like photoshop though, there would be a lot lost due to not having the brush engine.
This is art. One tip: How about creating a base design and then duplicating the worksheets? Saves time in formatting other worksheets alike and copy-pasting similar elements.
I don’t know if you’ll read this. This video inspired me. I knew the possibilities of data representation in excel are unlimited but this…… This was a very unique and beautiful approach. Not only me but you must have inspired thousands if not millions. 🎉
Honestly, it's the OTHER LEVEL, your videos gave me a huge inspiration enhancing my creativity level personally, before watching your tutorials I thought I am good enough in excel! but after your videos, I realized there are much more you can do by connecting things together, It's not only the rigid knowledge of the app that takes you to the next level. It depends on how you can utilize it. Thanks for the priceless effort you made through all your videos whoever is behind this channel.
So I'm pretty good at excel. I use it daily as my primary tool for work and I must say - I am beyond blown away by how beautiful and impressive this is. It has opened my mind to a whole 'other level! I can't believe it! It's just so stunning! Going to be taking inspiration from this moving forward and definitely showing this video to others since it's so insanely genius!
@@magnetoza It depends on different situations and circumstances. In finance, Excel is everywhere and known to pretty much everyone having to deal with numbers, for example. Even outside of finance, your dashboard may need to be given to senior management and other people not having the know how to use something more complicated. They may just want to browse the data and see quickly what things look like during the day. There is no need to give something more complicated to this user group. A more viable competitor may well be to use a backend service to calculate and then feed the data to some webpages, but then you have to deal with the infrastructure to hold the components as well as to support everything later. For a small business, it is less likely to do this.
When I first saw the beginning of this video I was thinking you would start using clipart to make the sections of the dashboard but to see that you do it all from within excel and it's available tools is pretty amazing. I knew excel was capable for making dashboards but I never knew it allowed this much detail. I've been using data studio and sheets for quite a while now and I would love to have this much functionality in my dashboard workflow. It's making me think if only excel was as accessible as sheets/bq and data studio cost and shareability then I probably wouldn't hesitate to switch. Mircrosoft just adds such a huge pricetag to everything. Anyway excellent video
Honestly.... jaw on the floor in awe of this masterpiece. I can't believe this was done in excel. I watched the entire tutorial and I'm still in shock. This is absolutely insane...
This reminded me of the first time I watched a video of some guy drawing the Mona Lisa in the MS Paint with incredible detail. There will always be pro users who will just take things into the next level.
I Believe if @Other Levels and @One Skill PowerPoint work together, they can create an incredible system using PPT and Excel, Please think about it...for humanity
I'm feeling myself luckiest one on this planet after youtube recommend me this video. Now I don't know how it recommends me but I unconsciously clicked it and yeah it was my best decision ever. Now In Sha Allah it will progress my business by doing this art and yeah all of my employees would be rather astonished 😂😂
This looks so amazing i'm commenting on it before i've watched it. You know this is the video everyone needs. You've come a long way, and i hope success sees you soon if not already.
00:36 Financial statistics system with multiple dashboards using Excel 02:49 Setting up the first dashboard and its elements. 10:51 Creating a scatter chart with multiple shapes and charts for the financial statistics dashboard. 14:24 Creating financial statistics dashboard elements in Excel 20:33 Creating and analyzing income sources dashboard 31:32 Use circular symbols and design a distinctive background for financial statistics dashboards system. 43:39 Creating financial statistics dashboards in Excel 51:01 Design a creative financial statistics dashboard system Crafted by Merlin AI.
Really nice dashboard. However, I think it doesnt fulfill the main goal of a financial dashboard: to be easily readable, with all consistent information in one page. Here, we have some basic information, that not allow anyone to take any action or explanation (where come the variance, ...). Anyway, Good job for the design and thanks for the sharing. Really appreciate it.
I was going to say the same thing. I did this type of work and information overload defeats the purpose of a DASHBOARD. Think of your cars dash board. If you had every metric possible on your cars dashboard it would take you forever to know if you're speeding or low on gas. A dash board should be simple in the data it provides as it should be the most critical pieces of data needed to make a decision. You should then build in sub sheets that allow you get additional detail for the metrics in question if needed, This is cool looking, but it's too much data for practical use.
@@ikannunaplays I agree with you and with @Galiat. I've been watching some videos of Other Level's and, yes, they are all great, good-looking dashboards to please our views. However, the more sophisticated the videos have become, the more information is necessary to fill in the dashboards, and it's getting hard to see such a lot of information spread on every corner. It should be kind of simple and easier. And the time spent seems to have increased in order to make them - due to the amount of information displayed.
@@cassioalexan I second you both. It has to be simple, easily acessible and clear. After many years using third part solutions, developing my own app, I came back to a very simple spreadsheet, actually using google docs (because it gets the prices from the market) and I think that's the best for me. Also, the only colours I use is to point negative values (in red) and some big distortions (i. e. price lower than patrimonial value in x% ). Other than that, plain white.
for my business I made a semi CRM software, on which I used some pre made dashboards (css and javascript) it was fun for a while, but later I realized I only rely on more basic reports. some info come on it's dahsboard, but I have to check it on a basic report
For a boardroom presentation with high level numbers, this is perfect and I cannot ask for more. It looks great and I am sure it will impress a lot of em. As a management account and business analyst, I’ll stick with my messy pivot charts and tables to easily manoeuvre the ever changing number game within a business.
The AI and Crypto Deck creators are going to have a Blast using this in their next sales deck and concept notes. This was an exceptional tutorial, Hope to see more themes of Styles to do in Excel, Maybe an Agency Model for Digital Marketing plan or Social Media content theme.
We need more UI or I should say more GUI like this . I saw years ago this interface for music were the songs were clusters of little stars and the albums were galaxies ...It was beautiful.
I am really bad at color coordination and lacking ideas for a new dashboard. And this was randomly recommended to me. Coincidence? I think not. This is an exceptional tutorial, also easy to follow! Thank you for sharing!
Thats quite amazing, I am used to making charts and visual aid fo projecks in Msexcel but the design was never on my strong side, I am sure to learn something very usefull from this tutorial.
What a CREATIVITY!!! You can find Macro's, Visual Basic's and C#'s traces everywhere.. but where are they :)) just need to know a little PivotTable and some basic formulas, and of course, have like this ART of IMAGINATION.. congrats..
This is super cool - great work. My only critique of these types of dashboards, and I'm curious of your thoughts, is that if new data series are added (for example: a new method of Advertising, like say Magazine or instagram, etc) you need to manually go in and add that line item to the dashboard doughnut chart. I love these creative dashboards. But it is these exact type of limitations for why I can't hand them off to my boss or some other user - because it constantly needs my manual updating.
Couldn't you design basically a Form to fill say on a spare spreadsheet tab so that other users could add that needed info tap like an "add to charts" button and then script that updating so that any user could do those edits :)?
@@Aetheric I know with tables you can auto update lists at any time. Simple pivot references would auto update. However the scripting of the additional series to the dashboard custom charts, that's a bit technical for me.
Wow. I am gonna learn this immediately lol. I don't understand the X Y values and how they are numbered for the circle locations. Could someone please explain?
Hey, your work is just beyond amazing. I never knew that such an interactive and beautiful dashboard can be created in excel. Can you pls tell which excel version are you using ?
Amazing, I didn't even think you could do this with Excel...I haven't even seen anything like this being built on PowerPoint either. It would be really great if you could provide the dataset so that we can follow along with the tutorial, I'm already itching to start learning myself!
@Other Level's.... from 11:00 mins of the video I have been trying out where and how did you get the data for X and Y to prepare the scatter chart. Not sure if I missed out anything on the video but I surely cannot find it anywhere.
This looks stunning. I'm in a sales role and would love something like this to share quarterly sales results. Is there anyway to integrate with Salesforce?
Uma obra de arte, sinceramente até me emocionei um pouco kk de tão bem feito e incrível, parabéns, te aconselho a estudar sobre como 'ranquear vídeos no RU-vid' te desejo tudo de bom e grandes conquistas, sucessos e abração =)
Awesome spreadsheet creativity and skill! I have a question: Do I need the latest version of Excel or can I also use Excel 2013 to create dashboards like these? I'm afraid I'll be missing some functionalities..
anyone ok with 44:00 how do you change it to combo, while keeping it as a circle. when I change mine to combo it's not a donut anymore - it changes to a square
