Integrating Source Files and Data

1. Integrating Source Files and Data

Welcome back!

2. The Presentation Piece of the Puzzle

Presentations are rarely created from scratch. More often than not, the information already exists somewhere — in a Word document, a PDF report, or an Excel spreadsheet. Your job is to distill that content into a visual and impactful story. The challenge?

3. The Presentation Piece of the Puzzle

Manually copying and reformatting content across different files is tedious and error-prone.

4. The Presentation Piece of the Puzzle

That's where Copilot shines — it can read your source files and transform them into structured slides, helping you tell a unified story without the copy-paste headache.

5. A Unified Story

You're building a business performance deck for BrightWave Energy's EcoCharge EV Battery rollout, and you've got information scattered across multiple files:

6. A Unified Story

a Word report covering market highlights,

7. A Unified Story

an Excel sheet with regional sales data,

8. A Unified Story

and a PDF summary from your sustainability team. In the old world, you'd be switching between apps, copying paragraphs, reformatting tables, and probably losing track of what you've already added. But with Copilot, you can bring all of these sources together right inside PowerPoint.

9. PDF Report to Slide Deck

We open the Copilot panel and upload our source files - here, a PDF report. Then we give Copilot clear instructions: "Use this document to create a 6- to 9-slide update for senior management."

10. PDF Report to Slide Deck

Copilot reads the file and drafts the deck for us, giving us a firm foundation to iterate on with more prompts. Presentations really come to life when you add data — numbers that back up your narrative and give your audience something concrete to remember.

11. Excel Spreadsheet to Slide Deck

Within the same presentation, we can prompt Copilot with: Add a section summarizing regional Q2 sales performance from the EcoCharge sales Excel sheet. Copilot reads the spreadsheet, identifies relevant columns like Region and Revenue, and automatically generates the slide content.

12. Excel Spreadsheet to Slide Deck

Once your data is on the slides, we're back in the review-revise-review cycle we've been using with other slide refinements.

13. Best Practices for Data-Driven Decks

Here are a few best practices to keep in mind when creating presentations from reference files.

14. Best Practices for Data-Driven Decks

First, always confirm data accuracy before presenting. Copilot is powerful, but it can misread columns or pull outdated figures — a quick sanity check saves embarrassment later.

15. Best Practices for Data-Driven Decks

Second, add captions or annotations for transparency on what sources were used. If a chart comes from an external source, say so. Your audience will trust you more.

16. Best Practices for Data-Driven Decks

Third, focus your slides on insights, not raw data. Nobody wants to stare at a spreadsheet — tell them what it means. And finally, when in doubt, combine Copilot's structure with your own expertise. Let AI do the heavy lifting, but let your judgment shape the final story.

17. Let's practice!

In the next lesson, we'll use Copilot's Chat app to extract strategic insights from presentations. See you there!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.