Part 5 of 5 in the series: AI at Work — A Professional's Field Guide
So far in this series, we've focused on what you can do on your personal device with public AI tools.
Now let's talk about what you can do at work.
Microsoft Copilot is embedded in the Office 365 tools you already use every day — Excel, Outlook, Teams, Word. If your firm has a Microsoft 365 Premium license, you already have access.
But it doesn't just work automatically. There are infrastructure requirements. Security policies. And the right way to use it — so you're adding professional value, not creating compliance problems.
This article covers all of it.
The Three Requirements (Most People Skip These)
Copilot in Excel won't work if you get these wrong.
1. File must be saved in OneDrive or SharePoint
Local files don't work. Period. If you open a file from your desktop or a local drive and wonder why Copilot isn't responding — this is why. Save to OneDrive first.
2. Auto-Save must be turned on
The toggle is in the top-left corner of Excel. When it's blue, it's on. Copilot needs continuous cloud sync to maintain context. Without it, nothing works.
3. Copilot must be licensed
You need Microsoft 365 Premium — not basic Microsoft 365. If your firm has enterprise licensing that includes Copilot, you're covered. Look for the Copilot icon in the top-right corner of the Excel ribbon. If it's there, you're good.
The Budget Workflow (A Real Example)
Here's the use case we worked through in our sessions: preparing an annual team budget.
The challenge: a massive department-wide Excel file. You need to extract your five direct reports' data, build a 2026 forecast, create a variance analysis, and produce something presentable to leadership.
Traditional approach: 3-4 hours of manual filtering, formula-building, and formatting.
With Copilot: about 55 minutes.
Here's the workflow:
Phase 1: Setup (5 minutes)
Save the file to OneDrive. Enable Auto-Save. Verify the Copilot icon is visible in the ribbon. Right-click any cell and select "Copilot" to open the panel.
Phase 2: Data Extraction (10 minutes)
I need to extract budget data for my team members:
- [Employee 1]
- [Employee 2]
- [Employee 3]
- [Employee 4]
- [Employee 5]
From the current data, create a new sheet that includes:
- All compensation components (base salary, bonus, benefits)
- 2025 actual spending by category
- Department overhead allocations
Name the new sheet: "My Team - 2025 Actuals"
Review what Copilot produces. Verify all employees are captured. Click "Add to new sheet."
Phase 3: 2026 Forecast (10 minutes)
Using the data in "My Team - 2025 Actuals," create a 2026
budget forecast with these assumptions:
- 3% cost-of-living adjustment on base salaries
- 5% merit increase pool
- Benefits costs at 4% trend rate
- Maintain current overhead allocation methodology
Show 2025 actual and 2026 forecast side-by-side.
Use formulas so I can adjust assumptions in one place.
Add to a new sheet: "2026 Budget Forecast"
Phase 4: Variance Analysis (10 minutes)
Compare "My Team - 2025 Actuals" and "2026 Budget Forecast."
Show:
- Dollar variances by employee and category
- Percentage variances
- Total team budget impact
- Conditional formatting: highlight variances over 10% or $10,000
Add to a new sheet: "Variance Analysis"
Phase 5: Visual Dashboard (10 minutes)
Create a budget dashboard for leadership presentation:
1. Column chart: 2025 actuals vs. 2026 forecast by employee
2. Pie chart: 2026 budget breakdown by category
3. Bar chart: year-over-year % changes by employee
Add to a new sheet: "Budget Dashboard"
Professional formatting. Clear titles and legends.
Phase 6: Final Formatting (5 minutes)
Apply professional formatting across all sheets:
- Currency columns: USD, zero decimals
- Percentage columns: 1 decimal place
- Headers: bold, centered, background color
- Apply borders to all data cells
- Auto-fit column widths
Then do your manual verification. Check totals. Spot-check formulas. Make sure the logic is sound before it goes anywhere official.
Copilot in Teams: The Privacy Rules
You'll want to use Copilot in Teams meetings for summaries and action items. Here's when it's appropriate — and when it's not.
Use it for:
- Internal team meetings on general topics
- Project status updates with colleagues
- Training or knowledge-sharing sessions
- Meetings you're hosting, where you control recording permissions
Don't use it for:
- Confidential client discussions without explicit consent
- Sensitive HR or personnel matters
- Meetings you're attending as a participant (not the host)
- Any conversation where participants haven't consented to AI assistance
The rule of thumb: if you're not the host, don't activate Copilot without asking.
How it works:
The Copilot button (separate from the recording button) uses real-time transcription to generate a summary, action items, and key decisions. By default, only you see the output — it doesn't automatically share to other participants.
For your own team meetings where you're the host, this is a straightforward time-saver. After the meeting, you have a structured summary and action item list ready to send.
Copilot in Word: The Same Approach, Different Surface
If you've been using Copilot in Outlook to generate emails from bullet points — and getting good results — the same approach works in Word.
You give it context and desired output. It drafts. You refine.
The prompting logic is identical. The surface is different.
Draft a professional memo announcing the annual budget
review process. Include the timeline, required inputs from
each team, and the submission deadline of [date].
That's it. You get a structured draft. You edit. You send.
Your Three-Tool Stack
By now, the full picture looks like this:
On your personal device:
Claude Pro for deep research, document analysis, and complex problem-solving. Your learning environment. Your research accelerator.
On your work computer, for client and tax work:
Your firm's internal AI assistant for domain-specific research within quality-controlled, approved data sources.
On your work computer, for productivity:
Microsoft Copilot across Excel, Outlook, Teams, and Word for daily workflow automation.
Each tool has a lane. Using them in the right lane is what keeps you effective — and compliant.
This Week's Practice
Open your actual budget file (or a real Excel file you're working on). Save it to OneDrive. Enable Auto-Save. Open Copilot.
Start with just one prompt: extract a subset of data into a new sheet.
See how it responds. Refine the prompt. Get the output where you want it.
Then do the same with Outlook. Take an email you're about to write. Bullet-point your key messages. Hand those bullets to Copilot and see what it produces.
You'll edit. That's fine. The goal is to stop starting from scratch.
The Takeaway
Copilot works. But you have to set it up right, use it in the right contexts, and verify what it produces.
The professionals who get the most out of enterprise AI aren't the power users who automate everything. They're the ones who automate the right things — the repetitive, time-consuming tasks that eat hours and don't require their professional judgment — so they can put that judgment where it actually matters.
Previous: Platform Architecture: Why the Tool You're Using Might Be Holding You Back
Discussion