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?
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.
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.
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.
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 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.
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.
@@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 : th-cam.com/video/9jfRPbIwY2Q/w-d-xo.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.
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.
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.
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.
@@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.
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!!
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.
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.
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!
If you dont recommend this method - then what alternative would you do? when managers want presentation on powerpoint, and all your data is often stored on excel / BI
I would share the Excel file with them and use workbook protection to guide them to the relevant parts of the file they can interact with and protect the rest. Or use Power BI and share the reports securely using the Power BI service.
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.
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
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?
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?
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.
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.
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.
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
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.
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?
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.
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 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...)
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?
Love it!
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! :-)
Glad it was helpful, Vijay!
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.
Glad I could help!
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.
Great tips, Bart! I would definitely get caught out by that. Thanks for sharing.
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.
Thanks! Yes, I agree, better to just insert an image and then switch to Excel when you get to that section of the presentation.
Hi Mynda!Really Helpful Advice..Thank You :)
Great to hear, Darryl :-)
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.
You can, but the size doesn't stick. Once you click out of the edit mode, it reverts to the truncated view.
@@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.
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.
@@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 : th-cam.com/video/9jfRPbIwY2Q/w-d-xo.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.
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.
Thanks Mynda😊
Pleasure 😊
thank a lot for lessons, do we have any addins to have a chance to edit visible ranges ?
Thank you for your video Mynda!!!
My pleasure, Ivan :-)
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.
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.
@@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.
You are giving useful information to us, thank you
Pleased to hear that :-)
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!!
I totally agree, Wayne!
I can't use option 3 in my ppt, what should I do?
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.
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.
Not sure, sorry, but I'd say PowerPoint isn't the place for such a table.
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!
Ooh, not sure about a Mac, sorry.
If you dont recommend this method - then what alternative would you do? when managers want presentation on powerpoint, and all your data is often stored on excel / BI
I would share the Excel file with them and use workbook protection to guide them to the relevant parts of the file they can interact with and protect the rest. Or use Power BI and share the reports securely using the Power BI service.
It's really very useful....
Glad to hear that 🙏
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?
You can use Excel Web App to embed the dashboard in a web page: www.myonlinetraininghub.com/interactive-excel-web-app-dashboard
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.
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
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?
No, you need to open the file in Excel to use the Slicers.
@@MyOnlineTrainingHub Thank you. Hopefully Microsoft will make improvements to that in future.
you made my day. thank you.
Wow, great to hear!
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?
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.
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.
You can’t use the slicers in presentation mode.
Thanks. This is really helpful
Pleased to hear that, Sagar :-)
Great, Mynda !
Thanks, Francis!
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.
Glad you liked it 😊
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.
I agree, Andy. Embedding the dashboards in PowerPoint is a bad idea, but plenty of people want to do it!
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.
Well Done Mynda.
Thanks, Shakira!
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
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.
pls design background colour in power point for power bi background colour
It's essentially the same process.
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?
Yes, with the embedded option I demonstrate in the video.
thanks for your tips
You're welcome, Cherrell!
You are a wonderful woman, I love you very much
Glad you like my videos!
Hi Mynda, Could we induct the PPT animations inside an excel
Not that I'm aware of.
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.
Not sure, Filipe. I'm not an expert in PowerPoint, sorry.
Amazing t-shirt 👕
:-D thanks!
Since you don't recommend to do this, do you know any other way that I can do that?
I recommend you leave your Dashboards in Excel and switch to Excel during the presentation.
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?
Not sure what you mean. Charts is just another name for graphs.
@@MyOnlineTrainingHub Thank you for the reply!! i meant when i select the cells in excel, the graphs(charts) do not get selected.
hi thanks for nice tut.
Thanks, Reza!
Thank you for your sharing ma'am,,, now i know why,,,, and why,,,, never repeat it again,, 😅😅
:-) great to hear.
Very good video
Thank you, Atul!
i dont know why i dont have past embed funtion show on
I'm not sure either...perhaps it's not available in your version of PowerPoint.
Hola, muy buen dato!!
Gracias!
That is the nerdiest shirt ever. I need one....
😁 I'll take that as a compliment! 🙏
superb...
Thanks, Yogesh!
Very fast very easy
Glad it'll be useful to you.
Brilliant
Glad it was useful, Jules :-)
@@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...)
😇