The Art of Copilot Gallery
Wing IV

The Excel Observatory

Where data reveals its patterns

Copilot in Excel turns natural language into analysis questions become answers, prompts become formulas, and datasets surface their outliers and trends for you.

Exhibit 01

Ask questions of your data

No pivot tables required. Ask Copilot a question in English and it reads the range, surfaces trends, and can narrate what the chart is actually telling you.

Try this — as a…

Task: rank the top five products by margin growth over the last four quarters. Persona: act as a finance analyst. Format: a table plus a two-sentence takeaway. Audience: the leadership team. Tone: neutral and evidence-led. Context: the 'Product Margin' sheet only.

Exhibit 02

Formulas, transforms, what-if

Turn a sentence into a formula. Ask Copilot to explain a legacy formula you inherited. Model 'what if costs rise 10%' and see the impact ripple through your workbook.

Try this — as a…

Task: model a what-if where headcount grows 12% and salary inflation is 4%. Persona: act as a finance business partner. Format: a table showing baseline vs. scenario totals and a 3-bullet takeaway. Audience: the CFO. Tone: neutral and evidence-led. Context: the current headcount plan sheet.