250 likes | 412 Views
Going from Excel to PowerPoint. Echo Swinford Presentation geek @ echosvoice | echosvoice.com. Keeping colors and fonts intact. Should you link or embed your data?. Transferring charts. Transferring spreadsheets. Activate a spreadsheet during a presentation.
E N D
Going from Excel to PowerPoint Echo Swinford Presentation geek@echosvoice | echosvoice.com
Keeping colors and fonts intact Should you link or embed your data? Transferring charts Transferring spreadsheets Activate a spreadsheet during a presentation
Office themes help you maintain consistency Colors Fonts Effects Slide layouts (background graphics)
Office themes help you maintain consistency Colors Fonts Effects Slide layouts (background graphics)
Default Office Theme Body font
PowerPoint Design tab > Save Current Theme C:\Users\UserName\AppData\Roaming\Microsoft\Templates\Document Themes For default, name it Default Theme.thmx
Embedding vs linking (AKA pasting charts from Excel into PowerPoint)
Picture (U) Use Destination Theme and Embed Workbook (H) • Keep Source Formatting and Embed Workbook (K) • Use Destination Theme and Link Data (L) • Keep Source Formatting and Link Data (F) EMBED LINK • Data lives in PowerPoint • Edits must be made in PowerPoint • Large workbooks will increase file size • Entire workbook is embedded (be careful of sensitive data) • Data lives in Excel • Data edits must be made in separate Excel file (must have access) • Formatting can still be edited • Does not increase file size • Risk of link breaking • Chart is not editable • Users tend to distort the image when it doesn’t fit as desired
Keep Text Only Use Destination Styles • Keep Source Formatting • Embed • Picture POWERPOINT TABLE EXCEL TABLE • Data becomes a PowerPoint table • Formatting from Excel file is maintained • Data becomes a PowerPoint table • Most formatting is stripped • Excel spreadsheet lives in PowerPoint • Excel formatting is maintained • Entire workbook is embedded • Large workbooks will increase file size • Can be clunky to edit, may truncate the data • Conditional formatting is maintained • Table is not editable • Users tend to distort the image when it doesn’t fit as desired • Unformatted text in a text box
Link a spreadsheet: Insert > Object > Create From File Close the XLSX first!
Activate a workbook Insert the workbook using embed or link Optional: rename the embedded object in the Selection Pane (Home tab > Arrange) Animations tab > OLE Action Verbs > Open Optional: Add a trigger animation
Keeping colors and fonts intact Should you link or embed your data? Transferring charts Transferring spreadsheets Activate a spreadsheet during a presentation
Evaluations CBA Attendees Non-CBA Downloads https://bit.ly/2SD31Y0