Тёмный

Embed Excel Dashboards in PowerPoint - It's so bad! 

MyOnlineTrainingHub
Подписаться 624 тыс.
Просмотров 86 тыс.
50% 1

The 3 options for embedding Excel Dashboards and charts in PowerPoint and the downsides of each.
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...

Наука

Опубликовано:

 

27 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 105   
@vijayarjunwadkar
@vijayarjunwadkar 3 года назад
Wow, I never tried this! Thanks for sharing the tips Mynda! Your videos are always valuable, as I get to learn so much more every time! :-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad it was helpful, Vijay!
@darrylmorgan
@darrylmorgan 3 года назад
Hi Mynda!Really Helpful Advice..Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Great to hear, Darryl :-)
@IvanCortinas_ES
@IvanCortinas_ES 3 года назад
Thank you for your video Mynda!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
My pleasure, Ivan :-)
@harbour3857
@harbour3857 3 года назад
Hi Mynda, thanks for your great content! You could also reverse the roles from Excel and PowerPoint. In stead of pasting your dashboard in PowerPoint, you could just copy / paste your PowerPoint slides in Excel. Every slide in its own sheet. Turn of gridlines - formula -bar and hide the ribbon and make the slides as big as the screen. No one will see the difference. Only drawback is that there are no slide animations, but who needs those when you have a live dashboard?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Love it!
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 3 года назад
Thank you Mynda, great tips. You could also embed small excel exercises in a Word document. One point for attention: if you switch from PPT to Excel during presentation: be aware of the settings with dual screen. If you don't practice this (at home you don't have a beamer but a second screen can do) this often causes some hickups. Same is true for youtube video's in PPT.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Great tips, Bart! I would definitely get caught out by that. Thanks for sharing.
@karin0963
@karin0963 3 года назад
Thank you so much!! I have been searching for a while to fix my power point. I somehow messed up the link and now you showed me how to make it work again.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad I could help!
@yogeshramrao5312
@yogeshramrao5312 3 года назад
You are giving useful information to us, thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Pleased to hear that :-)
@sagar5238
@sagar5238 3 года назад
Thanks. This is really helpful
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Pleased to hear that, Sagar :-)
@354dw
@354dw 3 года назад
Great video. Embedd as a picture can be useful because it means the dashboard will not change but you probably need several static slides. If up to date data is needed then I put a link on a slide to open the dashboard in excel and switch apps.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks! Yes, I agree, better to just insert an image and then switch to Excel when you get to that section of the presentation.
@maksim0933
@maksim0933 2 года назад
thank a lot for lessons, do we have any addins to have a chance to edit visible ranges ?
@cherrellwillems9889
@cherrellwillems9889 3 года назад
thanks for your tips
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
You're welcome, Cherrell!
@rez2109
@rez2109 3 года назад
you made my day. thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Wow, great to hear!
@shakiraasfoor7599
@shakiraasfoor7599 3 года назад
Well Done Mynda.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks, Shakira!
@DuraiSeeni85
@DuraiSeeni85 5 месяцев назад
Thanks Mynda😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 месяцев назад
Pleasure 😊
@rezayoun6571
@rezayoun6571 3 года назад
hi thanks for nice tut.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks, Reza!
@kuhekaizen3426
@kuhekaizen3426 3 года назад
Hello! Thank you for your great content, it is a big help. I put together my thesis and wonder how to put xls tables, sheets or especially diagramms into a word file. Which one is the way to save RAM/capacities? Does the majority here import it as a picture (which i do) or is there a smarter way?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad it's useful to you. I'm not sure what the most efficient way to embed Excel in Word, but my guess is an image will result in a smaller file, but you could easily test it.
@francisdon537
@francisdon537 3 года назад
Great, Mynda !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks, Francis!
@sergiohernandez9513
@sergiohernandez9513 3 года назад
Hola, muy buen dato!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Gracias!
@DuraiSeeni85
@DuraiSeeni85 5 месяцев назад
It's really very useful....
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 месяцев назад
Glad to hear that 🙏
@wayneedmondson1065
@wayneedmondson1065 3 года назад
Hi Mynda. I've never had much luck embedding Excel in other apps. Of course it can be done.. but so clunky in execution and too frustrating. Better to use one of your other methods and do updates as needed.. just my opinion. Thanks for the tips. Thumbs up!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
I totally agree, Wayne!
@tutsecret499
@tutsecret499 4 месяца назад
I made a dashboard in Excel using dax and some DArray. It has charts, sliders, etc. So how I can place in powerpoint without losing the interactivity. Do I have to publish the excel project somewhere before placing a link on the powerpoint? In PBI it's possible.
@atulkumardey2270
@atulkumardey2270 3 года назад
Very good video
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thank you, Atul!
@caiooliveira2314
@caiooliveira2314 2 года назад
First of all, thanks for the advice. But, what would you recommend for a presentation instead of Power Point? Have any post on your blog?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
You can use Excel Web App to embed the dashboard in a web page: www.myonlinetraininghub.com/interactive-excel-web-app-dashboard
@williamaviles4962
@williamaviles4962 3 года назад
Hi, I tried the embedded also. question for you. Is there a way to creat either a drop down list that connects with a bar charts in PP or create a bar chart with slicers in excel and link it to PP and have the links in the slicer to work with the bar chart in PP?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Yes, with the embedded option I demonstrate in the video.
@priyatrigunayat9330
@priyatrigunayat9330 Год назад
Hi Mynda! Thank you for the presentation. I was wondering if there's any tricks for doing this on Macs. When I embed the pivot table and slicers, they are still not interactive. Please let me know. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Ooh, not sure about a Mac, sorry.
@latedayJM
@latedayJM 3 года назад
You can actually re-size the embedded Excel by dragging the gray dotted border whenever you are in editing the file. I do this for very simple editable tables with Excel's conditional formatting.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
You can, but the size doesn't stick. Once you click out of the edit mode, it reverts to the truncated view.
@latedayJM
@latedayJM 3 года назад
@@MyOnlineTrainingHub We must be doing something different from each other then. I am able to freely re-size embedded Excel Sheets based on my needs. I do this on a weekly basis. I can adjust the "window" to show a 9 x 9 grid of cells, or 4 x 6, or 2 x 12. And my sizing sticks. I have not once had to re-embed my Excel due to a wrong size.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
I wonder if it's because the size of your Excel area is smaller than mine. My dashboard takes up the full 1920 x 1080p area of my screen, so I'm thinking that is exceeding the limit of what PowerPoint can embed. IDK, just guessing based on experience.
@latedayJM
@latedayJM 3 года назад
​@@MyOnlineTrainingHub Yeah. You probably are exceeding the limit of columns that can be made visible in an embedded Excel. In this video you can see how re-sizing works : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9jfRPbIwY2Q.html And this solution seems to indicate there is a rather small size limit for columns in an embedded Excel answers.microsoft.com/en-us/msoffice/forum/all/excel-object-in-powerpoint-2013-resizes/3c17b99c-8b27-44bc-b9e5-5b72315216ee (you can embed any Excel, but there is a limit as to what is visible) I love your videos by the way and have learned so much from them.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Yes, I said in my video that you need to build your dashboard to fit inside the limitations of that bounding box, which typically isn't ideal for a dashboard, but it might suit some.
@Malovika09
@Malovika09 3 года назад
Amazing t-shirt 👕
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
:-D thanks!
@yogeshpadte1481
@yogeshpadte1481 3 года назад
superb...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thanks, Yogesh!
@pythonpythons8664
@pythonpythons8664 3 года назад
You are a wonderful woman, I love you very much
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad you like my videos!
@dhitakrd
@dhitakrd Год назад
Hi Mynda, thanks for this useful tutor! I wonder, can we insert a very long excel table to multiple sheet in ppt? This table must also connected to one another sheet in ppt, soooo yeah I'm so confused how to solve this problem. Thanks in advance.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Not sure, sorry, but I'd say PowerPoint isn't the place for such a table.
@Jakeu1701
@Jakeu1701 3 года назад
You can also link the charts to the PPTx without embedding the excel file. As far as the charts being cut off, if you double click again and open the embeded file, you can then resize and move the viewable area. I used to embed until I found a way to link the charts. The file size drops like a rock when you just link. I prefer linking the charts instead of linking as an image as the charting I have do not line up with the PPTx format (I suppose I could change that) and if I someone else needs to make a change in formatting, display of callouts or axis range, you do not need to have access to the original excel file.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Hi Jason, I agree, the first example I showed was a linked picture in PowerPoint. The problem when embedding dashboards is that they are typically large and the embedded area size in PowerPoint is limited. So, while you can double click to resize the viewable area in an embedded dashboard, there is a limit to how big this can go, and often it's not big enough for a dashboard, which is why it appeared truncated on the right hand side in my example. Mynda
@chunkypants9773
@chunkypants9773 2 года назад
OK. That was good! You have a very nice way of explaining things. Pardon my English, but I very much like the lack of bullshit.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad you liked it 😊
@sadhannathan
@sadhannathan 2 года назад
Hi Mynda, Could we induct the PPT animations inside an excel
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Not that I'm aware of.
@graemegourlay2850
@graemegourlay2850 3 года назад
I'm experiencing this "chopping off" the right side of an embedded sheet which is really frustrating. The other options don't work for this specific need that I have as I need someone to double click on the Excel object, update values in a table in the spreadsheet and then have the view of this data show in Powerpoint. At least good to know that it's not my configuration or actions that are the cause, a material limitation in Powerpoint getting in the way.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad my video explained the problem. The solution is to make your dashboard smaller so it fits inside the area PowerPoint defaults to after you exit out of edit mode.
@graemegourlay2850
@graemegourlay2850 3 года назад
@@MyOnlineTrainingHub Thanks for the idea. Unfortunately in this case this solution presents usability issues as the content is used on a screen to present to an audience and with the amount and when downsized becomes unreadable. This one is a definite constraint in the Microsoft suite interoperability.
@RossMaynardProcessExcellence
@RossMaynardProcessExcellence 2 года назад
Excellent video. It's very annoying that you cannot interact with the slicers in presentation mode. I have a large Excel table one slicer that I want to embed in PowerPoint so we can interact with it during the presentation by changing the slicer. Is there no way to do that?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
No, you need to open the file in Excel to use the Slicers.
@RossMaynardProcessExcellence
@RossMaynardProcessExcellence 2 года назад
@@MyOnlineTrainingHub Thank you. Hopefully Microsoft will make improvements to that in future.
@filipefjro
@filipefjro 3 года назад
Hello. Can you help me? I want to insert 2 excel tables inside a PowerPoint slide and connect them in a 3rd one. Can I do it withouth the excel - only using PowerPoint? For instance - sheet 1 - Sales Jan, Feb, Mar, sheet 2 Salary Jan, Feb, Mar, sheet 3 Profit Jan, Fev, Mar. How can I do it? thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Not sure, Filipe. I'm not an expert in PowerPoint, sorry.
@chakrath9149
@chakrath9149 3 месяца назад
I can't use option 3 in my ppt, what should I do?
@julessarkissian6147
@julessarkissian6147 3 года назад
Brilliant
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad it was useful, Jules :-)
@julessarkissian6147
@julessarkissian6147 3 года назад
​@@MyOnlineTrainingHub I think you should do another little video with how to "attach" an excel document in a slide (insert --> object --> from file ---> check the symbol box) ==> Then an Excel logo shows up and by double clicking it's opening by itself in a specific window. (sometimes the sheet is too large and you prefer hiding it...)
@emmetzzisco9377
@emmetzzisco9377 3 года назад
Thank you for your sharing ma'am,,, now i know why,,,, and why,,,, never repeat it again,, 😅😅
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
:-) great to hear.
@saran985
@saran985 Год назад
How to edit the embedded xl file during presentation mode? Say, I need to toggle between years during the presentation mode and be more interactive.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You can’t use the slicers in presentation mode.
@leonardoghigonetto4750
@leonardoghigonetto4750 3 года назад
Since you don't recommend to do this, do you know any other way that I can do that?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
I recommend you leave your Dashboards in Excel and switch to Excel during the presentation.
@Khan-mc3gi
@Khan-mc3gi Год назад
pls design background colour in power point for power bi background colour
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
It's essentially the same process.
@ashish905
@ashish905 Год назад
When i do the same , charts works fine and show paste link option but when i do the same for slicer it does not work and shows not paste link and embeded option tell me how to add the slicer in Power point
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You can't copy and paste a Slicer on its own, instead you have copy the whole area of the dashboard including the cells the Slicer is sitting above and then embed the Excel workbook in PowerPoint, as shown in the last example.
@Ivan_Petkov
@Ivan_Petkov 3 года назад
you look very good
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Thank you!
@joslitainterel6503
@joslitainterel6503 3 года назад
Hi Mynda, while i select the dashboard charts in excel it is not selecting the graphs!! please could you let me know if there is any specific reason for it?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Not sure what you mean. Charts is just another name for graphs.
@joslitainterel6503
@joslitainterel6503 3 года назад
@@MyOnlineTrainingHub Thank you for the reply!! i meant when i select the cells in excel, the graphs(charts) do not get selected.
@andymitchell2146
@andymitchell2146 3 года назад
I don't get why you'd want to embed a dashboard on powerpoint in the first place. Mine typically use a vba macro in excel to zoom to selection (being the dashboard area) to ensure the user sees what i want them to see regardless of resolution etc, and just hide the tabs, headers and ribbon.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
I agree, Andy. Embedding the dashboards in PowerPoint is a bad idea, but plenty of people want to do it!
@TSSC
@TSSC 3 года назад
Embedding creates a copy that isn’t linked to the source. With this comes the risk of the files not being in sync. Especially important to consider if the data (not filters or slicers) is added or modified in one of the files. I’d stay away from embedding. Perhaps the Fluid framework will solve this.
@sminthian
@sminthian 4 месяца назад
That is the nerdiest shirt ever. I need one....
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 месяца назад
😁 I'll take that as a compliment! 🙏
@sokratespanopoulos7143
@sokratespanopoulos7143 3 года назад
Very fast very easy
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Glad it'll be useful to you.
@nhatthanhma9466
@nhatthanhma9466 3 года назад
i dont know why i dont have past embed funtion show on
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
I'm not sure either...perhaps it's not available in your version of PowerPoint.
@arturoguzman5230
@arturoguzman5230 3 года назад
😇
Далее
PowerPoint Infographic Dashboard + 🔥Slide Zooms🔥
9:56
The Mistake Almost EVERY Excel User Makes (Free File)
10:16
Fast & Easy! McKinsey Chart in Excel. Watch this...
10:38
📊 How to Build Excel Interactive Dashboards
19:21
Просмотров 2,4 млн
How to show Excel Dashboard in PowerPoint
15:14
Просмотров 117 тыс.
Красиво, но телефон жаль
0:32
Просмотров 1,5 млн
APPLE дают это нам БЕСПЛАТНО!
1:01
Просмотров 772 тыс.
How to Soldering wire in Factory ?
0:10
Просмотров 4,4 млн
MSI сделали свой Steam Deck
12:54
Просмотров 36 тыс.