Use Copilot in Excel for KPI and Inventory Formula Work

What This Does

You describe a KPI or inventory calculation in plain English. Fill rate, freight cost per unit, a reorder flag. Copilot writes the formula for you and explains what it does before you insert it. That means fewer minutes spent nesting IF statements and more time reviewing whether the number is actually right.

Before You Start

• You have Excel open, desktop or web, with your KPI or inventory data in a worksheet
• Your organization has added a Microsoft 365 Copilot license to your subscription. This is a paid add-on on top of a standard Microsoft 365 plan, and not every seat gets one automatically. Ask your IT team if you are not sure, or look for a Copilot icon in the lower right corner of the Excel window as a quick check. See Microsoft's Copilot page for current plan details
• Your columns have clear headers (SKU, On Hand, Safety Stock, Days of Supply). Copilot reads these to understand your data

Steps

1. Find the Copilot feature

Open your workbook and click the Copilot icon in the lower right corner of the Excel window (Microsoft retired the older in-cell =COPILOT() formula in September 2026, so this side pane is now the entry point). The pane opens on the right side of the screen. If you do not see the icon, your organization may not have the add-on turned on yet. Ask whoever manages your Microsoft 365 licenses.

2. Tell it what you need

In the pane, describe the calculation using your actual column letters and headers. Be specific about the condition, not just the output.

Example: "Write a formula in column H that flags any SKU where on-hand inventory in column D is below safety stock in column E, and days of supply in column F is under 10."

3. Review and use the result

Copilot returns the formula along with a plain-language explanation of what each part does. Read the explanation before you insert it. Click Insert to place it in the selected cell. Then check the first several rows by hand against what you already know about those SKUs before you drag it down the full column.

Real Example

Scenario: Your monthly KPI pack needs a freight cost per unit column, and last month's version broke when a supplier's unit count came back as zero for two SKUs.

What you type: "Write a formula in column I that divides total freight cost in column G by units shipped in column H. If column H is zero, return 'No Units' instead of an error."

What you get: =IF(H2=0,"No Units",G2/H2), with a short explanation of why the IF wrapper prevents a divide-by-zero error. You paste it once instead of remembering the fix from three months ago.

Tips

• Give Copilot the exact column letters as they appear in your sheet. Vague descriptions like "the inventory column" slow it down and increase the odds of a wrong reference.
• Before any KPI formula's output reaches a leadership dashboard, check its numbers against the ERP export or your source sheet for at least a handful of SKUs. Copilot can misread a column that looks similar to another one, and a wrong fill rate formula is worse than a slow one.
• If a formula errors out, paste it back into the pane and describe what it should be doing instead of starting over from scratch.

Tool interfaces change. If the Copilot icon has moved, look for a similar AI or sparkle icon in the Excel ribbon or window corners.