Ultra Prompt

← All articles

GPT-5.6 Is Now the Preferred Model in Microsoft 365 Copilot — Here's How to Test It Today

OpenAI just announced GPT-5.6 as the preferred model in Microsoft 365 Copilot. No mandatory upgrade prompt, no fanfare. It's available in your Word, Excel, and the rest of the suite now.

That matters for two reasons. First, a new preferred model changes what Copilot can do with a well-structured prompt, and you won't know how much until you actually test it against real work. Second, more capable models can quietly drive up usage costs if you're not watching. Both deserve your attention.

This guide gives you a concrete test plan for Word and Excel, real prompts you can copy, and a clear path to the usage metrics that tell you what this upgrade is actually costing you.


Why GPT-5.6 Matters for Copilot Users

Per OpenAI's announcement, GPT-5.6 is now the preferred model in Microsoft 365 Copilot. It's built for the kinds of tasks Copilot handles daily: longer documents, nested tables, complex multi-step instructions.

The practical difference shows up fast in summarization. Ask a model to summarize a 10-page market research document with a vague prompt and you often get a shallow pass that misses the specifics. The model loses track of the nuance before it gets through the full document.

With a well-structured prompt, that same task handles noticeably better. The before/after isn't just about the model — it's about what any capable model can do when the prompt is built correctly:

Before (weak prompt):
"Summarize this 10-page market research document."

After (structured prompt):
"Summarize the following 10-page market research document, focusing on competitor analysis and identifying emerging trends. Include specific data points to support your conclusions."

The second prompt works with any capable model. But testing whether GPT-5.6 follows those instructions consistently across the full document length — without drifting — is exactly what's worth verifying in your environment now that it's the preferred model.

Worth noting: specific benchmark numbers and context-window specs weren't released in OpenAI's announcement, so treat any figures you see elsewhere with skepticism until Microsoft publishes them formally.


Step-by-Step Test: Build a Complex Multi-Section Report in Word

Long-form coherence is where Copilot has historically struggled most. A 3-page document feels solid. A 12-page report starts to feel like disconnected sections stitched together. Testing GPT-5.6 on exactly this kind of task is the fastest way to find out whether the upgrade is meaningful for your work.

What you're testing for

Consistent tone across sections, logical transitions, and accuracy of detail as the document gets longer. If the Competitor Analysis section contradicts something in the Market Overview, that's a coherence failure worth flagging.

The workflow

Step 1: Define the structure first. Before you touch Copilot, write out your section headers and subheaders. A report with no pre-defined structure gives the model too much latitude and makes the output hard to evaluate. Aim for something like:

Executive Summary
Market Overview
  - Market Size & Growth
  - Key Drivers
Competitor Analysis
  - Market Share Trends
  - Competitive Positioning
Future Trends
Conclusion & Recommendations

Step 2: Start with the outline prompt. Open a new Word document, activate Copilot, and run:

Create a detailed outline for a 10+ page industry report on [Industry Name], 
following this structure: [paste your headers above]. 
For each section, list 3–5 key points to cover and suggest relevant data 
sources to research for each.

Step 3: Generate sections individually. Don't ask Copilot to write the whole report in one shot. Write each section separately, then paste and link them. For the Competitor Analysis section specifically, try:

Expand the 'Competitor Analysis' section for a report on [Industry Name]. 
Focus on market share trends for [Competitor 1] and [Competitor 2] over 
the past three years. Reference the data patterns described in the 
Market Overview section above for consistency.

That last sentence — referencing a prior section explicitly — is what tests GPT-5.6's ability to track instructions across a full document. Test whether it actually stays consistent.

Step 4: Run a coherence check. Once the full draft is assembled, read it start to finish with one question in mind: does this feel like one document, or a collection of AI outputs? Inconsistent terminology, contradictory statistics, or a tone shift between sections are all flags. Copilot handles the scaffolding. Your judgment closes the gaps.

If you want a repeatable process for this kind of work, the AI drafts your reports so you focus on the strategy framework maps well to exactly this workflow.


Step-by-Step Test: Create a Data-Driven Dashboard in Excel

Excel dashboards are a harder test than Word reports. The model has to interpret data, choose appropriate visualizations, write formulas, and keep the output readable. Errors here aren't just stylistic — they show up in the numbers.

What you're testing for

Accuracy of formulas, appropriateness of chart types for the data, and whether the model can handle a multi-step visualization request without losing one of the instructions.

The workflow

Step 1: Import clean data. Start with a CSV that has clear column headers: Region, Revenue, Cost, Units Sold, Month, Year at minimum. Garbage in, garbage out applies here as much as anywhere. If your source data has merged cells or inconsistent date formats, clean those first.

Step 2: Run the dashboard prompt.

Create a sales performance dashboard in this Excel sheet. 
Visualize revenue by region using a bar chart, cost trends over time 
using a line graph, and units sold per product category using a pie chart. 
Place each visualization in a separate section with a clear label.

The specificity matters. Telling Copilot which chart type to use for which data prevents it from making aesthetic choices that obscure the actual story in the numbers.

Step 3: Refine one visualization at a time. Once the initial dashboard is generated, iterate on each chart separately:

Change the color scheme of the revenue bar chart to use our brand colors: 
[hex code 1] for primary bars and [hex code 2] for comparison bars.
Add data labels to the cost trend line graph showing the exact value 
at each monthly data point.

Step 4: Test formula automation. Try:

Calculate the year-over-year growth rate for each region using the 
revenue data in columns B through M. Display the result as a percentage 
in a new column labeled "YoY Growth %".

Then check the formula it writes. Don't assume it's correct. Run a manual spot-check on two or three regions before you present any of these numbers to anyone.

The honest truth about Copilot and Excel: the visualization suggestions are where it adds the most speed. The formula logic is where it still needs your verification. Keep that division of labor clear and you'll move faster than you would solo, without the risk of shipping wrong numbers.


Monitoring Usage and Controlling Costs in Office 365

Microsoft 365 Copilot is a paid add-on, and a more capable model doesn't automatically mean a more expensive one — but it does mean you should know what you're consuming before the invoice arrives.

Where to find the data

Log into the Microsoft 365 Admin Center at admin.microsoft.com with administrator credentials and look for Copilot usage or activity reports in the reporting section. Microsoft's admin reporting shows total prompts used and usage patterns by user, which tells you where the volume is concentrated.

If you're on a business plan and don't have admin access, ask your IT admin for a Copilot usage report. The data exists — it's just gated by role.

What to look for

  • Which users are running the most prompts per day
  • Whether usage spikes correlate with specific projects or teams
  • Whether your current plan tier matches your actual consumption pattern

The cost control lever most people miss

Prompt efficiency. A vague prompt that requires three follow-up clarifications costs more than a well-structured prompt that gets it right the first time. This is the overlooked argument for prompt quality: it's not just about output quality, it's about token economy.

Structured templates solve this directly. Instead of iterating toward a prompt through trial and error, you start with a tested structure that gets to the output in one or two exchanges. The Ultra Prompt business category includes templates built specifically for Microsoft 365 workflows, including long-form reports and data analysis tasks.

If you're evaluating Microsoft 365 Copilot alongside other cloud AI tools and wondering what data each one can see, the breakdown of what cloud AI sees about you is worth reading before you standardize on any one platform.


Prompts You Can Copy Right Now

These are the core prompts from the workflows above, formatted to copy directly into Copilot.

Long-form report outline

Create a detailed outline for a 10+ page industry report on [Industry Name], 
following this structure: [paste your section headers]. 
For each section, list 3–5 key points to cover and suggest relevant 
data sources to research for each.

Section expansion with cross-reference

Expand the '[Section Name]' section with a focus on [specific angle]. 
Maintain consistency with the terminology and data points introduced 
in the [prior section name] section above.

Excel dashboard creation

Create a sales performance dashboard in this Excel sheet, visualizing 
revenue by region using a bar chart, cost trends over time using a line graph, 
and units sold per product category using a pie chart. 
Place each visualization in a labeled section.

Dataset trend analysis

Analyze this dataset [paste CSV data or reference the sheet]. 
Identify three key trends and create a concise summary report 
including supporting charts and graphs for each trend.

Year-over-year growth formula

Calculate the year-over-year growth rate for each region using 
the revenue data in columns [specify]. Display results as a percentage 
in a new column labeled "YoY Growth %".

For a full library of tested Microsoft 365 Copilot prompt structures, the Ultra Prompt business templates cover report generation, data analysis, and executive communication formats across the Office suite.


FAQ

How do I test GPT-5.6 capabilities in Microsoft 365 Copilot?

Open Word or Excel with Copilot active and run a task you've done before — specifically something that involves more than five pages of content or a multi-variable dataset. Compare the coherence, accuracy, and relevance of the output against what you'd gotten previously. Long documents and nested tables are where differences tend to be most visible.

What are the best prompts for creating long reports in Word with Copilot?

Define your section structure before you write a single prompt. Then generate each section separately, explicitly referencing prior sections to maintain consistency. Provide your target tone, audience, and any specific data points you need included. Vague prompts produce generic output regardless of which model is running underneath.

How can I monitor Copilot usage and costs in Office 365?

Go to admin.microsoft.com and look for Copilot usage or activity reports in the reporting section of the admin center. You'll see total prompts used and per-user consumption data. If you're not an admin, request a Copilot usage report from your IT team. Microsoft's tiered plans have different Copilot access levels — check that your current plan matches your actual usage before assuming a cost issue exists.

Is GPT-5.6 worth testing for Excel dashboards?

Yes, and the fastest way to find out is to run the same dashboard prompt with the same dataset you've used before and compare the outputs directly. Pay attention to formula accuracy and whether multi-step visualization instructions all land. Your data is the benchmark that matters, not any vendor claim.

What tier of Microsoft 365 do I need for Copilot?

Microsoft 365 Copilot is available as a paid add-on to qualifying business plans. Check current Microsoft pricing and plan eligibility at microsoft.com, as plan structures and Copilot availability can change. If you're on a personal or family plan, Copilot's AI features may differ from the business add-on version.


GPT-5.6 is available in Microsoft 365 Copilot now. The question isn't whether to use it — it's whether you're using it deliberately enough to know if it's actually better for your work. Run the Word and Excel tests above with real projects, not toy examples, and you'll have a clear answer within a week.

If you want prompts that are already structured for these workflows, Ultra Prompt's business templates are built for exactly this kind of repeatable, measurable Copilot work.

Ready to level up your prompts?

Ultra Prompt has 600+ expert-crafted templates. Stop guessing, start prompting.

Try Ultra Prompt Free
S

Written by Sean

Founder of Ultra Prompt. Building the prompt engineering toolkit I wish existed.