I have never once wanted to "play" with excel. I think I just found a new hobby that will actually result in being better at my job. Incredible. Thank you!
Great video! But please note that there is a much easier way to receive the results that you did from 4:00 to 11:00. If you insert seperate boxes (instead of one big box) and group them (ctrl + g), you are able to insert a gradiënt that affects all the boxes. Please give it a try and it will save you a lot of time! :) Cheers and thanks again for your video.
That's a fantastic tip there Machiel. You probably saved many people a lot of time there, especially if they have to deal with multiple changing requests for addition of new boxes, fields, etc. I cannot imagine having to repeat the steps in Powerpoint if the demand for more boxes grows every month! Phew!
Thx, thats really great. I am an Excel and reporting freak, but it is often quite tough to bring a KPI Report into a shape that suits not only the requirements of the the reporting teams, but also to have one that catches the attention of the management board for a regular use. Figures are crucial, but it's also essential to find a structure which is easily to understand for each level. This tutorial is a big help AND really simple to implement!
Thank you for your positive feedback 😊 You are absolutely right, structure and visuals are a crucial part when you try to make your analytics/ KPI insights understandable for others. I am happy you got some value from my tutorials.
Really Wonderful! Really, Thank you very much :) One tip for who like me had problems with adapting the image to the background: regarding the background i tried many things to make it adapt to excel and I finally discovered that you need to have an image with the same resolution of your computer. Thus you can easily change the resolution using many online tools and the image will perfectly adapt to your excel file!
Hi, I would like to thank you (and to congratulate you) for the time and effort you put into this video series. I was able to create a beautiful stats dashboard with a lot of functionality. It is (almost) perfect, except for one small detail that is enormously frustrating. I've got six rows of my data sheet that are appearing in all my charts, even when the charts are being filtered using slicers (and where the data from these six rows should be excluded from the filtering). I've tried rewriting the data, I've checked it thoroughly for errors and I can find no solution. Otherwise, I'm loving it. Thanks again for your clarity and your generosity. Happy New Year !!
Great and amazing tutorial, but what is not really clear to me is how to handle the size of the background and the canvas itself. What happens if I use a different picture as a background and how I define the size of the canvas? Thanks in advance
Hi The Office Lab Really cool video could you tell me what your page layout settings are on because if I use the same resolutions for my picture as yours then its to small, could you help me here ?
Thanks for your amazing but simple sharing. I just have one concern, I tried to save pic as your recommendation, but the dimension is 960 x 540 only. It leads the frame does not fit well when I inserted on excel. Could you help me with that?
@@theofficelab hi, i did use the same pic than you and got a 15' screen and it is still splited in 4 pieces i have insert as your command using "PNG". Can you help ?
I really love the design and work you shown us in this awesome vid, but unfortunately for some reason, it didnt work for me as i followed your step to step guide. The problem i face is when i put background image in excel, the bg is zoomed (although it has the same dimensions as mentioned), and the PPT part where you substract the rectangles, in my case the rectangles just disappears :(. But great vid tho! i just hoped it worked for me.
Thank you, Sir 😊 Regarding your question, I don't think there is a built-in functionality for directly importing Google Sheets into an existing Excel file, but you can easily convert a Google Spreadsheet to Excel format. Just open the sheet and go to File > Download as ... and select "Microsoft Excel". Hope that helps.
Hi, Thanks a lot for the demo! Would it be possible to have the same with 2 Pivot tables instead? Complexity is different because Pivots are embodied in cells directly ..
Thanks man! this is awesome. However, I got trouble with that Dimension. For some reason Inserting that image as a background into an Excel sheet is not working for me as I ended up with a bunch of same images next to each other. I even use your background image...=/
If I try to merge and subtract then the white remains same and I'm not able to see fragments of black but still except for the rectangles removed on the guides
Apologies if I missed this. If new data is added to the main sheet, are the charts on the dashboard automatically updated or do you have to select Refresh Data every time?
Very good question 😁 the answer is no, the charts are not automatically updated, but I'll show you how to solve that and make them automatically update in Episode 4 of this tutorial series (coming in 2 weeks).
Hi, thank you for the tutorial :) However i still don't understand how you make fit the image on the full screen . Mine is always split. Yet I made sure to take the same image than you. Can you help or advice me on to resize it ? i have Office 2019 pro plus so i have the same function than you. Best & thanks again
hey I have the same dimensions and all but then when I insert the pictures it is way too big even if the format is the same as yours and as a side note when I zoom in excel the upper bar (ABC etc) gets bigger too if you know what I mean
DEAR SIR, I have tried to create background and all made same as per you only thing is that the size of each font charts and slicers are very small need to increase size everytime and slicers size is very very smal... please help
I didn't understand how was picture taken into PPT?? Time 2:54.. Could you please help from where you have inserted.. I tried in excel find but i didnt and understand.
Thanks, bro! Well, for the whole dashboard you need the 2019 or 365 version. However, when only considering the designing part in this video, the 2016 version should be fine and work smooth. Hope that helps and I wish you beautiful day 😊
Hi There, I tried this and its brillent , just one thing to note if you are using Macpro book (which is rubbish as there are so many restrictions comapred to Microsoft ) it will not allow you to copy from Powerpoint as background , you can do all the picture formatting in excel but it will be a little different. Please let me know if anyone found a way to transfer to Mac (the crap).
Hi Mike, thanks for your positive feedback! Dimensions of your background image cannot be changed in Excel. You have to adjust the resolution/ dimensions of your image before you add it as a background.
I am using 2013 version and I can see all the options same as 2019. When I try to resize the background image to 1125x1999 cm it turns to black. Even after importing the background image in original to excel sheet it becomes completely black after adjusting the size. Kindly help.
Hi there, thanks for these tutorials I think they are great. Quick question: I'm trying to replicate the interactive info button you mention in Ep 1. Could you give me a hint on the tools you used to create it?
Hi there 😊 that will be covered in detail in Ep. 5 (coming in a few weeks). But sure, I can give you a hint beforehand: What you need are the icons (button) and shapes (rectangle & textbox) available in Excel + a little bit of VBA. In the VBA scripts you change the visibility status of the InfoBox and connect that script to the button. To make the button know what do on the next click (either hide or display the info box) you can either use two buttons (one per button state that will be displayed with clicking on the other one) or you change a property of the button (e.g. the color) and execute the action based on the current state of that property (color). Hope that is good starting point for you.
You can do that in the Visual Basic Editor. In there you can set the properties for each worksheet. There is one property called 'ScrollArea'. Just put in the area (e.g. $A$1:$H$100) you want to the user to be restricted to. Hope that helps 😊
Hello, when I make my shapes and add my graphs on top of them.... it seems that the graph end up below the shape. So the graph colors are not bright/clear. I’m not sure how to lock the shapes so that they are behind my graphs. Any advice is welcomed 🙏🏽
Hi Kelly, you can easily control the order of the shapes in the 'Selection Pane'. Just click on any shape and then you should be able to open the 'Selection Pane' in the 'Shape Format' tab. Another way to instantly send a shape to the back is to right click on it and click on 'Send to Back'. Hope that helps 😊
Hi how can I add map on my dashboard. I have Office student and home 2016 version. When I check on my maps option all I have is the 3D one. It does not give me the same option you’ve shown on this video. Pls help
Hi MarieLumen, the Map Chart feature as shown in the tutorial is only available in Office 365 (now called Microsoft 365) or Office 2019. If you want to learn more about these versions, please check the links in the description.
In that case, you have to adjust the image dimensions before you insert it as a background in Excel. Start with a 1920x1080 image, insert it as a background, and if it is too big, reduce the dimensions step by step, re-insert it, just until it fits your screen.
Hi John 😊 Absolutely you can suggest things. I am always open to ideas and inspiration. The best way to do that is to send you ideas to info@excelfind.com for now and I will check on them. Just as a little heads-up, I have a lot of topics already planned for the future, so if I like your idea it might still take some time till I do it.
Hey Ritesh, I am really sorry, but I will not be able to to upload the 3rd episode before the 16th. However, the custom slicer design I build in that episode is already included in the file that you can download from excelfind.com. So maybe you can take it from that file and adjust for your purpose. 😊
Hi JustAnotherPassenger, thanks for constructive question. You are right, that might an option. However, even if you do it that way (bottom-to-top-approach) I still recommend to not simply group the shapes but merge them (via 'union') into one single shape. That will make it a lot easier for you once you have it in Excel file for multiple reasons. Nonetheless, I decided to do it with this way (top-to-bottom-approach) because I felt like I have much more control over the precise separation of the tiles and equally sized gaps between them. But again, that's just one way to do it 😊 Hope that answers your question and I wish you a beautiful day.