Embed Excel Dashboards in PowerPoint - It's so bad! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Har
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?
reply
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?
reply
Graeme
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.
reply
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.
reply
Filipe
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.
reply
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.
reply
K-HE
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?
reply
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?
reply
Andy
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.
reply
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.
reply
Ross
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?
reply
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?
reply
William
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?
reply
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?
reply
Wayne
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!!
reply
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!!
reply
354dw
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.
reply
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.
reply
Add a review, comment
Other channel videos
