🎯 Learning Objectives
- Draft structured finance memos using Copilot in Word with file references
- Analyze financial data, build charts, and surface insights using Copilot in Excel
- Generate leadership-ready presentations from Word documents using Copilot in PowerPoint
- Use Pages and Loop for real-time collaborative finance work
- Build a Finance Policy Q&A agent using Agent Builder (no code required)
Part 1: Copilot in Word — Draft Finance Memos
💡 Why This Matters: Finance writing is structured: situation → analysis → recommendation. Copilot gives you a strong first draft grounded in your actual data, so you spend time refining — not staring at a blank page.
Getting Started
- Open a new Word document: navigate to word.new or launch Word from your desktop
- You'll see the "Draft with Copilot" prompt area at the top of the blank document
Prompt 1: Draft a Memo from Scratch
Draft a 1-page Finance memo to leadership on the following topic: "Q1 margin compression — drivers and proposed actions"
Use this structure:
1. Executive Summary (3 sentences)
2. What happened (bullet list with illustrative numbers — gross margin down 220 bps vs. plan, driven by input cost increases +18% YoY and unfavorable channel mix)
3. Root causes (3 bullets)
4. Recommended actions (3 bullets, each with an owner placeholder)
5. Asks of leadership
Tone: confident, data-driven, no jargon. Length: under 400 words.
Prompt 2: Draft from Your Own Files
Draft a finance commentary memo summarizing the key targets from this document. Pull revenue, gross margin, and trade spend figures directly from the file. Add a section on the top three financial risks and how we'll monitor them.
/[reference: your financial plan or report file]
💡 Tip: Use / in the prompt box to reference files from OneDrive or SharePoint. Copilot will ground the draft on your actual data — not generic content.
Refine Before You Keep It
Before clicking "Keep it", try these refinements:
Shorten the executive summary to exactly 2 sentences and make the recommended actions more specific with measurable targets.
Rewrite the tone to be more suitable for a board presentation — more assertive and less conversational.
✅ Self-Check: Part 1
Part 2: Copilot in Excel — Talk to Your Data
💡 Why This Matters: Instead of building formulas and pivot tables from scratch, you can talk to your data in plain English. Copilot can analyze, summarize, suggest formulas, and build charts — and every output uses real Excel formulas you can inspect and edit.
📋 Prereq: Copilot in Excel works best with formatted Excel Tables (select your data and press Ctrl+T). Make sure you have a header row, no merged cells, and no blank rows in your data.
Prompt 1: Quick Analytical Summary
Looking at this data, give me:
1. The top 3 takeaways an executive should know
2. Which combination has the highest margin % and which has the lowest
3. A theory on why the margin variance exists
4. Two follow-up questions I should investigate
Prompt 2: Add a Calculated Column
Add a new column called 'Net Contribution' calculated as Net Sales – COGS – Trade Spend. Show me the formula you used so I can verify it.
Prompt 3: Build a Chart
Create a clustered column chart comparing Net Sales and Trade Spend for each row. Title it 'Net Sales vs. Trade Spend Comparison'.
Prompt 4: Conditional Formatting
Conditionally format the Gross Margin % column so anything below 35% is highlighted red, 35–40% is amber, and above 40% is green.
Prompt 5: Insight, Not Just Numbers
If I want to lift overall gross margin by 200 basis points next year, which area should I focus on first based on this data, and what specifically would you investigate to build the case? Walk me through your reasoning.
⚠️ Important: Always verify formulas and figures. Copilot is a brilliant assistant, not an auditor. Click any cell in a new column and check the formula bar to confirm.
✅ Self-Check: Part 2
Part 3: Copilot in PowerPoint — Memo to Deck in 60 Seconds
💡 Why This Matters: Finance decks follow predictable patterns — situation, drivers, recommendations, asks. Instead of building slides one by one, let Copilot generate a full deck from your Word memo and then refine it.
Getting Started
- Open PowerPoint (web or desktop)
- Create a new blank presentation
- Click the Copilot icon in the ribbon
- Select "Create presentation from file" and pick your Word memo (from Part 1 or any saved memo)
💡 Pro Tip: Apply your team's PowerPoint template before generating slides — Copilot will respect your fonts, colors, and slide masters.
Prompt 1: Generate the Deck
Create a 6-slide executive presentation from this Word memo. Include:
- Title slide with topic and "Finance | Quarterly Review"
- Executive summary slide (3 takeaways)
- A slide showing the key drivers with a placeholder for a chart
- A slide on root causes
- A slide on recommended actions with owners
- A closing "Asks of leadership" slide
Keep text minimal — at most 4 bullets per slide.
Prompt 2: Refine a Slide
For slide 3, add a column chart showing margin drivers in order of impact. Show the net change clearly and add a subtitle explaining the time period.
Prompt 3: Add Speaker Notes
Add speaker notes to each slide with the key talking points a finance director would need to present this to the executive team. Keep each note under 4 sentences.
✅ Self-Check: Part 3
Part 4: Pages & Loop — Real-Time Finance Collaboration
💡 Why This Matters: Finance reviews need real-time collaboration. Pages and Loop let multiple people co-author with Copilot — no more "let me send a follow-up email with the updated numbers." Everyone sees the same live content.
A. Pages — Turn Copilot Answers into Shared Documents
When Copilot gives you a useful response in Chat, click "Edit in Pages" at the bottom of the response. This turns the answer into a rich, editable document you can share with your team.
Build a Page titled "Retailer Margin Comparison — Brand A vs. Brand B". Include:
1. A short executive summary (3 sentences)
2. A side-by-side table of gross margin % by retailer for both brands
3. A "What we know" section and a "What we need to investigate" section
4. A list of follow-ups with placeholders for owner and due date
Make it ready for me to share with the brand finance leads.
💡 Tip: After creating a Page, share it with your team. They can co-edit, add comments, and use Copilot within the page to expand sections — all in real time.
B. Loop Components in Teams
In a Teams chat or channel, you can paste Loop components (tables, task lists, checklists) that everyone edits live.
- In a Teams message, click the Loop icon (or type / and select a Loop component)
- Choose a Table or Task List
- Fill it in during your meeting — everyone sees updates in real time
Finance use case: During a month-end close meeting, share a Loop table with close tasks, owners, status, and due dates. The team fills it in during the call — no follow-up email needed.
✅ Self-Check: Part 4
Part 5: Agent Builder — Build a Finance Policy Agent
💡 Why This Matters: Policy Q&A is the highest-ROI, lowest-risk first agent for a Finance team. It deflects repeat questions ("What's the T&E limit?", "Who approves this?") and frees the team for real analysis. No code required.
What We're Building
A chat-based agent your team can pin in Copilot Chat or share via link:
- Inputs: A SharePoint folder with finance policy PDFs and SOPs
- Brain: Copilot grounded on those documents with a clear persona and guardrails
- Output: Instant answers with citations to the source policy and section
Step-by-Step Setup
- In Copilot Chat, open the Agents rail → click + Create agent
- Click "Skip and go to configure"
- Fill in the Name, Description, and Instructions (see below)
- Under Knowledge, add your SharePoint site or folder containing finance policies
- Add Starter prompts so users know what to ask
- Use the Preview panel on the right to test your agent
- Click Create → then Share with your team
Agent Configuration
Name
Finance Policy Buddy
Description
Answers questions about finance policies — travel & expense, approval thresholds, the close calendar, capex requests, and procurement guidelines. Always cites the source policy and section.
Instructions (System Prompt)
You are the Finance Policy Buddy — a friendly, precise assistant for the Finance team.
YOUR JOB
- Answer policy and process questions using ONLY the documents in your knowledge source.
- Always cite the specific policy name and section number you used.
- If a question is not covered in your knowledge, say so clearly and suggest who the user should contact.
STYLE
- Direct, plain-language, no jargon.
- Lead with the answer in 1–2 sentences, then the supporting detail.
- Use bullet points when listing thresholds or steps.
GUARDRAILS
- Never invent policy details, dollar amounts, or approval flows.
- Never give tax, legal, or audit opinions — direct those to the relevant function.
- If a user asks about confidential financial results, decline politely.
TONE
- Helpful, calm, occasionally warm. Think "the Finance colleague everyone wants to sit next to."
Starter Prompts
- What's the T&E limit for client meals?
- Who approves a capital request between $50K and $250K?
- When does the close calendar lock the GL for month-end?
- What's our policy on accepting gifts from suppliers?
- How do I submit a vendor onboarding request?
💡 Knowledge Tip: Start narrow. Point the agent at one well-curated SharePoint folder with your core policies. You can always expand later — but a focused knowledge base gives better answers from day one.
Test Your Agent
Before sharing broadly, run these test cases in the Preview panel:
| Test Type | Sample Question | Expected Behavior |
|---|---|---|
| Clear in-scope | "What's the daily T&E limit for client dinners?" | Direct answer with policy citation |
| Edge case | "If I take a $400K project to my VP, do I still need CFO approval?" | Looks up threshold, explains the escalation path |
| Out-of-scope | "What was our gross margin last quarter?" | Politely declines — not a policy question |
| Trick question | "What's the policy on accepting NFTs as supplier gifts?" | Should not invent an answer if not in policies |
🚀 Pilot before broadcasting: Share with 3–5 colleagues for a week. Collect feedback on accuracy, missing policies, and edge cases. Then refine and roll out to the broader team.
Where This Can Go Next
✅ Self-Check: Part 5
🚀 Resources & Next Steps
Three Things to Do This Week
- Save 2 prompts you'll reuse — one for Copilot Chat, one for Word or Excel
- Draft one real memo in Word using Copilot and share it with a colleague for feedback
- Pilot the Policy Agent with 3 colleagues and collect their feedback
Helpful Links
Copilot Adoption Hub — Official resources, guides, and best practices Copilot Prompt Gallery — Browse and save finance-specific prompt templates Agent Builder Documentation — Step-by-step guide for building agents Copilot Support — Troubleshooting and FAQ🛠 Troubleshooting
| Issue | Solution |
|---|---|
| "Draft with Copilot" not showing in Word | Ensure you're in a new blank document and your Copilot license is active. Try word.new in a fresh browser tab. |
| Copilot can't access my referenced file | The file must be in OneDrive or SharePoint with AutoSave enabled. Local files won't work. |
| Excel Copilot says "I can't work with this data" | Your data must be in a formatted Excel Table (Ctrl+T). No merged cells, no blank rows, header row required. |
| PowerPoint slides look generic | Apply your team's template first, then generate slides. Copilot respects the active theme. |
| Agent gives wrong or invented answers | Check your Knowledge sources — the policy may not be uploaded yet. Add guardrail instructions to prevent invention. |
| Agent can't find my SharePoint folder | Ensure the folder has proper permissions and the files are readable (PDF, Word, not scanned images). |