Use Excel Copilot to Write Replenishment Formulas

What This Does

Copilot in Excel writes, explains, and debugs complex formulas for you using plain language — so you can build accurate replenishment models, safety stock calculations, and inventory reports without spending an hour reverse-engineering a nested IF statement.

Before You Start

• You have Excel open (desktop or web via Microsoft 365)
• Your organization has Microsoft 365 with Copilot enabled (M365 Business Standard + Copilot add-on, or M365 E3/E5 with Copilot license)
• Your data is in a worksheet (column headers help Copilot understand the structure)

Steps

1. Find the Copilot feature in Excel

Open your Excel workbook. Look for the Copilot button in the Home tab of the ribbon — it shows a sparkle/star icon labeled "Copilot." Click it to open the Copilot sidebar on the right side of your screen.

If you don't see it: your organization may not have Copilot enabled yet. Ask your IT department or manager. Copilot in Excel requires Microsoft 365 with the Copilot add-on.

2. Describe the formula you need

In the Copilot sidebar text box, describe your formula in plain language. Be specific about:

• What calculation you want to perform
• Which columns contain which data
• Any special conditions (e.g., only apply if inventory is below a threshold)

Example: "Write a formula in column H that calculates reorder quantity. If column D (current inventory) is less than column E (safety stock), calculate: column F (max stock) minus column D, then round up to the nearest value in column G (case pack size). Otherwise return 0."

3. Review and insert the formula

Copilot will display the formula with an explanation of what it does. Click Insert (or the equivalent button) to add it to the cell you have selected. Review the first few results to verify they're correct before applying to the full column.

4. Debug existing formulas

If you have a broken formula, paste it in the Copilot sidebar and say: "This formula isn't working correctly. It should [describe what it should do]. What's wrong and how do I fix it?"

Real Example

Scenario: You want to calculate days of supply for each SKU in your weekly inventory report — a metric your manager asks for every Monday.

What you type in Copilot: "Write a formula in column F that calculates days of supply. Divide column C (current inventory in units) by column D (average daily demand in units). If column D is zero, return 'N/A' instead of an error."

What you get: =IF(D2=0,"N/A",C2/D2) with an explanation, ready to insert. What would have taken 10 minutes of Googling takes 30 seconds.

Tips

• Give Copilot your column headers exactly as they appear in your spreadsheet — it uses them to understand the data structure.
• For Power Query transformations (M code), Copilot can also write these — ask "Write a Power Query step that..."
• If the formula is complex and you're not sure it's right, ask Copilot to explain it step by step before you use it in a production model.

Tool interfaces change — if the Copilot button has moved, look for similar AI/sparkle options in the Home or Formulas tab.