How to use Microsoft Copilot Notebooks to evaluate commercial proposals

🧠 What are Copilot Notebooks (and why they’re different)?
Copilot Notebooks:
✅ Only use the documents you add as references
✅ Can suggest additional files from your Microsoft 365
✅ Automatically summarise the documents you add
✅ Let you run multiple conversations against the same evidence
✅ Can be reused anytime (projects, reviews, recurring decisions)
Perfect for:
📁 Project work
📊 Decision making
📅 Meeting preparation
📚 Research or learning
📈 Recurring reporting

🧪 Demo scenario used in this video
We use a fictional accountancy firm that is:
🏢 Evaluating proposals for a new website
📄 Working from an RFP document
💷 Managing a fixed marketing budget
📑 Comparing multiple supplier proposals
Using Copilot Notebooks, we evaluate everything in one place, grounded in the same source documents.

👀 What I show step‑by‑step
On screen, you’ll see how to:
🔹 Create a new Copilot Notebook
🔹 Add multiple reference documents (RFP, budget, proposals)
🔹 Get instant summaries and key insights
🔹 Compare proposals side‑by‑side in a table
🔹 Generate a scored evaluation against RFP criteria
🔹 Identify risks and red flags automatically
🔹 Draft a shortlist recommendation memo
🔹 Re‑run the same analysis when a late proposal arrives
⏱️ This saves hours of manual reading and comparison.

🛠️ Bonus tools shown
I also demonstrate how Copilot Notebooks can create:
📊 A ready‑made PowerPoint from your notebook
🎧 An audio overview (great for digesting information podcast‑style)
🧾 Word documents directly from Copilot outputs
Ideal if you need to brief a leadership team quickly.

✅ Who this is for
This video is ideal for:
👔 Directors and Managing Directors
📈 Operations and Finance leaders
🧑‍💼 Professional services firms (accountancy, legal, financial services)
💡 Anyone using Microsoft 365 Copilot and wanting practical, real‑world examples