How to make an Excel spreadsheet with AI

Give your workbook a clear question

This workshop budget asks how an optional printing cost changes the remaining funds. Follow the source, inputs, formulas and revision, then use the complete practice brief below or replace it with your own figures.

Keep source figures and unknowns visible

Separate quantities, unit costs and proposed income before asking for a workbook. Tax and delivery are unspecified in this example; the remaining funds exclude them and the workshop proposal still needs approval.

Ask for an editable Excel workbook

Specify the sheet name, input cells, units and calculations. Ask Work for a finished XLSX with native formulas. The initial request below produced the original workshop budget.

1
2
3
4
5
6
7
8
9
10
11
12
13
14Create a real editable XLSX workbook named cedar-workshop-budget.xlsx for a public product example. Use only the facts below; do not use personal memories, connected accounts or outside files. Deliver the actual workbook, not only a Markdown table or instructions.

Use one sheet named Budget. A4:D4 headers: Item, Quantity, Unit cost (USD), Line cost (USD). Rows 5–9:
Notebooks | 24 | 5
Marker packs | 10 | 8
Folders | 20 | 3
Room hire | 1 | 110
Optional printing package | 0 | 25
Put editable inputs in B5:C9 and formulas =B5*C5 through =B9*C9 in D5:D9. Printing is optional and excluded initially, hence quantity 0; its quoted package cost is USD 25.
A11 label Total cost; D11 formula =SUM(D5:D9).
Row 14: A14 Proposed fee income, B14 24 participants, C14 USD 20 fee, D14 formula =B14*C14.
A15 Remaining funds; D15 formula =D14-D11.
Expected initial results: line costs 120, 80, 60, 110, 0; total 370; proposed income 480; remaining 110. Add an ordinary note that tax and delivery are unspecified and excluded from these figures; the proposal is not approved, and there is no date, venue or attendance guarantee.  Preserve formulas as native Excel formulas and make recalculation automatic. Check the actual cell addresses and totals before delivering the file.

Read the budget and its formulas

The table shows the original workbook’s inputs, native formulas and saved results. Read across each row to connect the quantity and unit cost with its calculated total. The full cell list is available below.

Follow the calculations from inputs to totals

Multiply quantity by unit cost for each line, add the costs, calculate proposed fee income and subtract costs from income. The formula guide below explains how those steps connect. Keep units and unspecified tax and delivery in view.

Change printing and preserve the formulas

The follow-up asks for a separate workbook with printing quantity B9 changed from 0 to 1 and the note in A17 updated. The other source cells, sheet name and eight formulas should stay the same.

1
2Create a separate revised copy named cedar-workshop-budget-printing.xlsx. In the original Budget sheet change only the optional printing quantity B9 from 0 to 1, and update its explanatory note to say printing is included in this scenario. Preserve all other source quantities, unit costs, sheet name and formulas. Expected total cost D11 is 395; proposed income D14 stays 480; remaining funds D15 is 85. Tax and delivery remain unspecified; this is an unapproved proposal. Deliver the actual revised editable XLSX, keeping the original available, and check its cells and calculations.

Compare the recalculated workbook

The revised file changes B9 and A17 while preserving the other inputs and all eight formulas. Printing adds USD 25: costs become USD 395, proposed income stays USD 480 and remaining funds become USD 85. Compare the two tables and notes.

Inspect inputs and formulas in the editor

Open the workbook output and select a cell to inspect its value or formula. To explore a scenario, change an input and check the dependent totals. Wait for Saved after editing, then reopen the same workbook from Files to confirm the input and results. Docs explains editing and recovery.

Build a workbook from your own figures

Use the complete practice brief below or replace the source with a small budget you can check. After the revision, compare the changed input, its note, the formulas and the totals against the original.

• Spreadsheets overviewLearn more
• Spreadsheets controls and formatsLearn more
• Work access and workflowLearn more
• Plans and creditsLearn more