Skip to main content

📝 Lesson 7.3: Word, Excel, PowerPoint, To Do & Copilot

OneNote isn't an island in Office — it's the gathering point. In this lesson you'll pull Word, Excel, and PowerPoint files onto your pages (as attachments or as printouts you can write on), embed a live spreadsheet, connect your checkboxes to Microsoft To Do, and meet Microsoft 365 Copilot inside OneNote — with a clear, honest account of what needs a paid license and what doesn't.

📚 What You'll Learn

By the end of this lesson, you will be able to:

  • Choose between inserting an Office file as an attachment or as an inkable printout, and explain the trade-off
  • Embed a live Excel spreadsheet/table and know how it differs from a static pasted table
  • Send content from Word and PowerPoint into OneNote (print to OneNote) and copy between apps keeping formatting
  • Understand how OneNote checkbox tags relate to Microsoft To Do
  • Describe what Microsoft 365 Copilot in OneNote can do — and state honestly that it's a paid feature that's still rolling out

⏱️ Estimated Time: 55 minutes

🎯 Project: Insert an Excel table or a file printout onto a page and annotate it; if you have Copilot, ask it to summarize a page or draft a to-do list — otherwise do it by hand and mark where Copilot would help.

In This Lesson

OneNote as the Office Gathering Point

Think about how a project's documents usually sprawl: the budget in an Excel file, the proposal in Word, the pitch in PowerPoint, and your own notes in… somewhere else. To make sense of it you bounce between four windows, and nothing lives with your thinking about it.

Here's the mental model. Each Office app is a specialist workshop — Excel does numbers, Word does long documents, PowerPoint does slides — and OneNote is the project table where you lay everything out together and scribble in the margins. You can bring a copy of any specialist's work onto the table, write on it, and keep your commentary right beside it. The originals stay in their workshops; the gathering and thinking happens in OneNote.

🧠 Mindset

This lesson includes Copilot — the AI features everyone's talking about. It's genuinely useful, and it's genuinely a paid feature that not everyone has. We'll treat it as what it is: a helper for tasks you already know how to do by hand. Everything Copilot does here — summarizing, drafting a to-do list, tidying prose — you'll learn to do yourself in the project. If Copilot arrives later, you'll direct it well because you can do the work without it. The skill comes first; the assistant is a bonus.

Attachment vs Printout

When you drop an Office file onto a page (Insert → File), OneNote usually asks how you want it — and the choice matters. There are two fundamentally different ways to bring a document in.

📖 Definition

Attachment (Insert Attachment): the actual file is embedded on the page as an icon. Double-click to open it in Word/Excel/PowerPoint. It's the real document — editable in its own app — but you can't read or annotate its contents directly on the OneNote page.

Printout (Insert Printout / File Printout): OneNote renders the document's pages as images laid onto the page. You can read it inline and — the whole point — write and highlight on top of it with digital ink, exactly like marking up a paper printout. But it's a snapshot: editing the words means going back to the source file.

So the rule of thumb: attach when you need to keep editing the file; insert a printout when you want to read and annotate it. Reviewing a contract, grading an essay, marking up a proposal on a tablet? Printout. Keeping the working budget file handy inside the project page? Attachment. You can even do both — attach the live file and insert a printout to scribble on.

✅ Pro Tip

Printouts shine on a pen-and-touch device (Module 4). Insert a PDF or Word printout, then use the Draw tools to circle, underline, and comment right on it. Because OneNote's search can read text inside printouts, your annotated document stays findable later — the best of paper markup and digital search at once.

⚠️ Important Note: A printout does not update when the source file changes — it's a picture taken at insert time. If the document is still evolving, either re-insert the printout when it's final or attach the live file so you always reach the current version.

Live Excel Tables

Excel gets a special power beyond attach-or-printout. In the OneNote desktop app you can insert a live spreadsheet (Insert → Spreadsheet → Existing/New Excel Spreadsheet). OneNote shows a preview of the sheet on the page, and keeps a link to the underlying Excel file.

  • Click Edit on the embedded object and it opens in Excel; save, and the preview on your OneNote page updates to match.
  • This is different from a static table — whether OneNote's own table (Lesson 2.2) or a range you simply pasted as text. A static table is just cells of text on the page; it has no connection to Excel and no formulas.

Use a live spreadsheet when the numbers are calculated or change — a budget, a tracker, a data table you maintain in Excel — and you want the current figures to appear inside your notes. Use a plain OneNote table when you just need rows and columns of text you'll type by hand.

⚠️ Watch Out

Live-spreadsheet embedding is strongest in the OneNote desktop app; behavior is more limited in OneNote on the web and on mobile, where you may see the preview but not the full insert-and-edit round-trip. As always, teach yourself the concept and check what your specific app supports before relying on it for something important.

Sending From Word & PowerPoint

The flow also runs the other direction — from an Office app into OneNote.

Send to OneNote / Print to OneNote

On Windows, installing the OneNote desktop app adds a "Send to OneNote" printer (it may be listed as OneNote (Desktop)). At the time of writing this printer is Windows-only — on a Mac or the web, save the document as a PDF and use Insert → File Printout (where available) or attach it instead. On Windows, in Word, PowerPoint, a browser, or almost anything with a Print command, choose Print and pick Send to OneNote (or OneNote (Desktop)) as the printer. Instead of paper, the document arrives as a printout on a OneNote page you choose — ready to annotate. It's the same printout concept from Section 2, reached from the source app's Print dialog.

Copy between apps, keeping formatting

For smaller pieces, plain copy-and-paste works well: select a passage in Word, a chart in Excel, or a slide in PowerPoint, copy, and paste into OneNote. OneNote generally preserves formatting — headings, bold, table structure, images. When you want the text only, use Paste Special / Keep Text Only to strip the styling.

Linked Notes (classic desktop)

Older versions of the OneNote desktop app include Linked Notes — you dock OneNote beside Word or PowerPoint and, as you type notes, OneNote records a link back to the exact spot in the source document. It's handy for research, though it's a legacy feature that isn't in every version, so treat it as a nice-to-have rather than a cornerstone.

⚠️ Important Note: Whichever way you bring content in, decide where the source of truth lives. If the Word doc is the real document, your OneNote copy is a reference and annotations — don't let the two drift and then wonder which is current. Keep the "master" in one place and treat OneNote as commentary around it.

Checkboxes & Microsoft To Do

You met this in Lesson 7.1, and it's worth restating clearly because people expect more magic than exists. OneNote's To Do tag puts a checkbox on a line — perfect for capturing actions inside your notes. Microsoft To Do is the separate app that holds your real, cross-device task list.

The honest picture: a plain OneNote checkbox does not automatically appear in Microsoft To Do. The bridge is the Outlook Task flag (classic OneNote desktop) — flag a line as an Outlook task and it flows into To Do. On other platforms, keep actions as To Do tags in OneNote and add the important ones to the Microsoft To Do app yourself. Two useful lists that meet where you decide they meet — not by silent magic.

💡 A clean two-list habit

Let OneNote checkboxes capture everything in context as you take notes, then promote only the few that need chasing into Microsoft To Do (by flag or by hand). OneNote is the thinking space; To Do is the "what must I actually do today" space. Keeping those roles distinct stops your task list from becoming as noisy as your notes.

Copilot in OneNote (Honestly)

Microsoft 365 Copilot is Microsoft's AI assistant built into the Office apps, and it has been arriving in OneNote. When available, you open the Copilot pane and ask it, in plain language, to work with your page.

What Copilot can do in OneNote

  • Summarize a long, messy page (or a whole section of notes) into a few clear points.
  • Draft notes from a prompt — a meeting agenda, an outline, a first pass you then refine.
  • Generate a to-do list or plan from your notes — pulling the action items out of a wall of text.
  • Rewrite — tidy rough notes into clean prose, change the tone, or make something more concise.
graph LR W["📄 Word"] --> ON["📓 OneNote
the gathering point"] X["📊 Excel"] --> ON P["📽️ PowerPoint"] --> ON ON --> TD["✔️ Microsoft To Do"] ON --> CP["🤖 Copilot
(paid)"] CP --> ON

⚠️ Watch Out — the honest licensing picture

Copilot is a paid feature, not part of free OneNote. At the time of writing, on work/school accounts it requires a Microsoft 365 Copilot license (an extra per-user add-on on top of Microsoft 365), while Microsoft 365 Personal and Family subscriptions include some Copilot features (with usage limits) in certain apps, including OneNote on Windows. It's also rolling out gradually across apps and platforms, so exactly where and how it appears keeps changing, and Microsoft has offered different Copilot tiers over time. If you don't see Copilot in your OneNote, that's expected — it's very likely a license/rollout matter, not something you've done wrong.

✅ Pro Tip

Treat Copilot as a fast first draft, never the final word. Ask it to summarize, then read the summary against your notes and fix what it missed. The people who get the most from AI are the ones who could do the task themselves and can therefore judge the output — which is exactly why the project below has you do it by hand first.

Office App → Integration → Benefit

The integration layer at a glance:

Office app / service Integration with OneNote Benefit
Word Insert as attachment or printout; Send/Print to OneNote; paste keeping formatting Read and annotate documents beside your notes
Excel Insert a live spreadsheet that updates, or a static table Current numbers and calculations live inside your notes
PowerPoint Insert as printout / Send to OneNote; paste slides Mark up decks and keep talking points with the slides
Microsoft To Do Outlook-task flag promotes a checkbox into To Do (classic desktop) Important actions reach your real cross-device task list
Microsoft 365 Copilot Summarize, draft, make to-do lists, rewrite — paid plan, rolling out Faster first drafts and instant summaries of your pages

🎯 Project: Insert, Annotate & (Maybe) Copilot

You'll bring a real Office file onto a page, mark it up, and then produce a summary and a to-do list — with Copilot if you have it, by hand if you don't. Either way you finish with the skill.

🏋️ Gather and work a document in OneNote

Objective: One page that holds a document, your annotations, a summary, and an action list.

Step 1 — Insert something to work on (5 min)

  • Excel path: Insert → Spreadsheet → an existing Excel file (or make a quick one: a small budget or tracker). Confirm the preview shows on your page.
  • Printout path: Insert → File Printout (or Print → Send to OneNote from Word/ PowerPoint/PDF) so the document lands as an image you can write on.

Step 2 — Annotate it (7 min)

  1. Use the Draw tools (or typed note containers beside it) to circle, highlight, and comment on the content — a number that looks off, a paragraph to revisit.
  2. Add a short typed "My take" note under the inserted object.

Step 3 — Summarize the page (6 min)

  • With Copilot: open the Copilot pane and ask it to summarize this page. Read the summary, correct anything it got wrong, and keep it at the top.
  • Without Copilot: write a 3-bullet summary yourself. Then add a line: "[Copilot would help here by drafting this summary from the page.]" so you know where the AI fits.

Step 4 — Produce a to-do list (5 min)

  • With Copilot: ask it to generate a to-do list from this page, then turn each item into a To Do checkbox (Ctrl+1; Mac Cmd+1).
  • Without Copilot: pull the actions out yourself and tag each with a To Do checkbox. Promote one to Microsoft To Do (from Lesson 7.1).
💡 Hint — good Copilot prompts (or your own checklist) 
Summarize this page in 3 bullet points.
List the action items on this page as a to-do list.
Rewrite my rough notes above into clear, concise prose.
Draft a short agenda for a follow-up meeting from these notes.

No Copilot? These lines double as your checklist — do each one by hand. Doing it manually first is how you learn to judge Copilot's output later.

✅ Project Completion Checklist

  • A page holds an inserted Excel table (live) or a file printout
  • You annotated it with ink and/or a typed "My take" note
  • The page has a short summary — from Copilot or written by you
  • Actions are captured as To Do checkboxes, with one promoted to Microsoft To Do
  • You know which steps used (or would use) Copilot, and that it needs a paid plan

🎯 Quick Quiz

Question 1: You want to write and highlight directly on top of a Word document inside OneNote. Which do you insert?

Question 2: Which statement about Copilot in OneNote is accurate?

Best Practices for the Office Layer

✅ Do's

  • Match the insert to the job. Printout to annotate, attachment to keep editing, live spreadsheet for changing numbers.
  • Keep one source of truth. Decide whether the Office file or the OneNote page is the master, and don't let them drift.
  • Do the task by hand at least once. Then Copilot is a time-saver you can supervise, not a black box you trust blindly.

❌ Don'ts

  • Don't assume a printout updates. It's a snapshot; re-insert or attach the live file if the document is still changing.
  • Don't expect checkboxes to sync to To Do by themselves. Flag them (classic desktop) or add them to To Do by hand.
  • Don't count on Copilot being there. It's licensed and rolling out — build habits that work without it, and treat it as a bonus.

💡 Pro Tips

  • On a pen device, printouts + ink turn OneNote into the best document-markup tool you own.
  • Paste Special → Keep Text Only when you want an Office snippet's words without its styling.
  • If you do have Copilot, always read its summary against the source before you rely on it.

📓 Learning Journal

Keep writing your learning journal inside your OneNote notebook. After each lesson, note:

  • Key concepts you learned
  • Techniques that clicked for you
  • Questions or confusion points to revisit
  • Ideas you want to try
  • Your progress and feelings about learning this

✍️ This lesson's prompt: Which Office integration will change how you work — inkable printouts, a live Excel table, send-to-OneNote, or (if you have it) Copilot? Write a page describing one real document you'd bring into OneNote this week and exactly how you'd work it. If you don't have Copilot, note honestly where it would have saved you time — and how you'll do that step by hand for now.

📝 Lesson Summary

🎓 Key Takeaways

  • Insert Office files as an attachment (keep editing it) or a printout (read and ink on it) — a snapshot that doesn't auto-update.
  • A live Excel embed updates when you edit the source; a static/OneNote table is just text with no formulas.
  • Send/Print to OneNote brings Word and PowerPoint in as printouts; paste keeps formatting (or use Keep Text Only).
  • Checkboxes stay in OneNote unless flagged into Microsoft To Do; and Copilot (summarize, draft, to-do lists, rewrite) is a paid, rolling-out feature, not free OneNote.

🎉 What You've Accomplished

You've turned OneNote into the project table where the rest of Office comes together — documents you can annotate, spreadsheets that stay current, actions that reach your real task list, and a clear-eyed view of what AI adds and what it costs. You can do every one of these tasks by hand, which means whatever tools you have (or gain), you're in control of them rather than the other way round. That completes the whole integration layer.

❓ Common Questions at This Stage

Why can't I annotate an attached Word file directly on the page?

An attachment is the real file stored as an icon — OneNote isn't showing its contents, just a handle to open it in Word. To write on the document inside OneNote, insert it as a printout instead (or in addition), which renders its pages as inkable images.

My inserted spreadsheet doesn't update when I change the Excel file. Why?

Make sure you inserted it as a live spreadsheet (Insert → Spreadsheet) and edited via the embedded object's Edit button in the OneNote desktop app — that's where the round-trip is strongest. A pasted-in table or a printout won't update; those are static snapshots.

I don't have Copilot. Am I missing out on a lot?

You're missing a convenience, not a capability. Everything Copilot does here — summarizing, drafting, listing actions, rewriting — you can do yourself, and this lesson's project had you practice exactly that. If a Copilot license comes your way later, you'll wield it well precisely because you learned the manual version first.

🔭 Looking Ahead

That wraps Module 7. Next — Lesson 8.1: Mobile, Sticky Notes & Capture-Anywhere Mastery — we leave the desk entirely and make OneNote capture ideas from your phone, your lock screen, and the world around you, so nothing ever gets away.

✅ Before the Next Lesson

  • Finish your insert-and-annotate page with a summary and a to-do list
  • Decide your two-list habit: OneNote checkboxes for capture, Microsoft To Do for real actions
  • Write your Learning Journal entry for this lesson

📚 Additional Resources

Want to go deeper on the specialist workshops OneNote gathers together? Each has its own free companion course in this Microsoft 365 series:

🌟 Encouragement for the Journey

You've now connected OneNote to Outlook, Teams, and the whole Office family — the integrations that make it far more than a note app. And you did it the honest way: learning the manual skill first, so no paywall or rollout can leave you stuck. That's mastery. Let's step away from the desk and make capture happen anywhere. 📓