Creation of PPT slides directly from excel Sheet
I would like to see a new feature in excel, where from just one click we can export the excel sheet , charts ,objects in powerpoint slides.
This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.
Scott Sobel commented
This is like my idea I posted - search for "Big dream of an idea - Would it be possible to integrate Excel, Word & PowerPoint, and/or Access/SQL??"
Thanks for the tip. I'll check that out.
Sameer Bhide commented
@Scott[MSFT] - Did you know that in Excel Ver 5 (1993) you could right click on a sheet and say insert -> Slide
This feature was promptly removed in the next version - because MS realized that nobody would then buy Power point
@Chris Newman - Also left you comment through site but I could not complete order process to try evaluation version. "Total cannot be 0" at checkout.
Andreas Thehos commented
That would be great. Actually we are using several VBA Solutions to create presentations automatically.
- f.e. save one presentation for any row of a large Excel PivotTable by pressing a button. This saves days at creating nearly 800 different presentations.
- to fill several objects of different slides by connecting cell references to slides and form names (Some VBA Code at YouTube (German) : https://youtu.be/K3zvMrrYaHM )
- for mass printing of different Excel rows to the same type of slide (certificates like mail merge in Word)
The implemented solution could be a simple list of cell and object references to the path of a PowerPoint template, the slide number or type of slide and the name of the destinatíon form.
Thanks a lot to all giving the vote for this idea.
Chris Newman commented
This would be awesome if this feature was baked into Excel. If you google search "E2P Excel", I've created an Excel add-in that will easily do this for you. Could give Microsoft an idea for tackling this request :)
I made this into a macro - press a keyboard shortcut and the chart is copied and centered into a new slide after the active one. Huge timesaver.
one of excellent usage and optimization of Excel features
Great !!! it will save lot of time & energy....
This is a great idea....helpful in work!!!!!
Zack Barresse commented
This is something done quite often. We have to write code to do this currently, which is quite popular. Having this functionality natively would be used quite a bit I imagine. Good idea Rajender!
Very Nice thinking which Microsoft can change in reality.
Indeed, that would be grateful if we have a feature in excel wherein we can export the excel sheet charts and objects into power point slides. That would indeed help us in minimizing the man efforts and also improve the quality of work, innovative thing I must say and appreciate.
Mahesh M Menon commented
Its an awesome faeture, which helps to reduce the workload & improves the quality of Excel & powerpoint.