~AEA Public Library

CBD127: Easily Present Your Data: Automating the Transfer of Excel Charts to PowerPoint - Jennifer Bain  

02-13-2013 19:19

This Coffee Break webinar will explain how to automate the process of transferring Excel charts to a PowerPoint presentation in seconds rather than tediously copying, pasting, and re-aligning each chart individually to its own slide. The presenter will explain how to add already-written VBA code to the user’s personal Excel workbook – making the code available to any open worksheet – that pulls all of the Excel charts from a worksheet and adds them to a PowerPoint presentation, one chart to a slide, resized and aligned to be centered on the slide. In addition, the presenter will explain how to add a shortcut to the Excel ribbon so that this process and all other macros can be run at the click of a button.

#DataVisualizationandReporting #WebinarSeries

Statistics
0 Favorited
44 Views
2 Files
0 Shares
55 Downloads

Related Entries and Links

No Related Resource entered.

Tags and Keywords

Attachment(s)
docx file
Code Sub CreatePowerPoint_v2.docx   14 KB   1 version
Uploaded - 02-13-2013
docx file
Steps to create macro that creates PowerPoint presentatio....docx   753 KB   1 version
Uploaded - 02-13-2013