PICCOLI PASSI. COMPETENZE REALI.
La tua prossima competenza utile.
Descrivi l'attività. Rivedi la proposta. Verifica il risultato in Excel.
Tre lezioni gratuite · un capitolo utile
Verifica precedente conservata. Il tuo lavoro salvato resta invariato; i nuovi compiti usano prompt, revisione, applicazione e verifica.
La tua guida di Excel
Impara facendo, con i tuoi tempiIl tuo primo prompt in Excel
Segui la dimostrazione, poi esercitati.
| A | B | C | |
|---|---|---|---|
| 1 | Product | January | February |
| 2 | Notebooks | 120 | 150 |
| 3 | Pens | 80 | 90 |
| 4 | Folders | 60 | 75 |
| 5 | Total |
| A | B | C | |
|---|---|---|---|
| 1 | Product | January | February |
| 2 | Notebooks | 120 | 150 |
| 3 | Pens | 80 | 90 |
| 4 | Folders | 60 | 75 |
| 5 | Total | 260 |
Il brief Goal: total February sales from the current sheet. February is C2:C4 (150, 90, 75). Request a connected formula in C5. Preserve all source data and January. Check that the total is 315 and responds to each February value.
Add all February sales in C2:C4 and put a formula total in C5. Preserve the source data.
- B5 → =SUM(B2:B4)
- ✓Headings describe the data. Each product gets one row, with January and February in separate columns.
- ✓=SUM(B2:B4) adds 120 + 80 + 60 to get 260. The colon includes every cell between the endpoints.
- ✓=SUM(C2:C4) or =C2+C3+C4 adds all three February values to get 315. Enter calculates; Check grades separately.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | |
| 3 | Pens | 5 | 2 | |
| 4 | Folders | 4 | 3 | |
| 5 | Total |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | 36 |
| 3 | Pens | 5 | 2 | |
| 4 | Folders | 4 | 3 | |
| 5 | Total |
Il brief Goal: calculate revenue per product and a grand total from the supplied quantities and prices. Request connected formulas in D2:D4 and D5. Then refine your prompt to set Notebooks units to 4 and Pens units to 7, preserving prices and Folders. Verify that revenue and the grand total recalculate to 48, 14, 12 and 74.
Calculate revenue for each product from quantity times price, and a grand total. Set Notebooks units to 4 and Pens units to 7. Keep the prices and Folders unchanged.
- D2 → =B2*C2
- ✓Revenue = quantity × unit price. =B2*C2 and =C2*B2 both work. A fixed 36 would not recalculate.
- ✓Multiply each row’s quantity by its price, then use =SUM(D2:D4) or =D2+D3+D4 for the total. Initially it is 58.
- ✓Changing notebook quantity from 3 to 4 updates its revenue from 36 to 48. Changing pen quantity from 5 to 7 updates pen revenue to 14 and total revenue to 74.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Notebooks | 48 |
| 3 | Pens | 14 |
| 4 | Folders | 12 |
| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Notebooks | 48 |
| 3 | Pens | 14 |
| 4 | Folders | 12 |
Il brief Goal: compare the supplied product revenues: Notebooks 48, Pens 14, Folders 12. Request a column chart using A1:B4 or A2:B4, a descriptive revenue title, and the highest-revenue product and value. Preserve the source table.
Create a column chart from A1:B4 titled "Product sales revenue" and identify the highest-revenue product and its value. Keep the data unchanged.
- Column chart from A1:B4 titled “Revenue by product”
- ✓Choose both product labels and all three revenue values. A1:B4 includes headings; A2:B4 is also valid for this chart.
- ✓A column chart uses height to compare values. Descriptive titles such as “Product sales revenue” tell the reader what the values mean.
- ✓Notebooks has the tallest column and the most revenue: 48, compared with 14 for Pens and 12 for Folders.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | 36 |
| 3 | Pens | 5 | 2 | 10 |
| 4 | Folders | 4 | 3 | 12 |
| 5 | Total | 58 |
Il brief Business goal: track shop sales. Supplied data: Notebooks — 3 units at 12 each; Pens — 5 units at 2 each; Folders — 4 units at 3 each. Desired result: a table with revenue per product and a calculated grand total.
Create a sales tracker for my shop. Data: Notebooks 3 units at 12 each; Pens 5 units at 2 each; Folders 4 units at 3 each. Calculate revenue for each product and a grand total.
- 10 cells of supplied data: A2, B2, C2, A3, B3, C3…
- D2 → =B2*C2
- D3 → =B3*C3
- D4 → =B4*C4
- D5 → =SUM(D2:D4)
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Create a sales tracker for my shop. Data: Notebooks 3 units at 12 each; Pens 5 units at 2 each; Folders 4 units at 3 each. Calculate revenue for each product and a grand total.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Category | Expense | Metric | Value |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Category | Expense | Metric | Value |
| 2 | Rent | 800 | Budget limit | 1000 |
| 3 | Utilities | 120 | Total expenses | 1000 |
| 4 | Supplies | 80 | Remaining | 0 |
Il brief Business goal: plan monthly spending. Budget limit: 1000. Supplied expenses: Rent 800; Utilities 120; Supplies 80. Desired result: an expense table, total expenses and the remaining budget, all connected by formulas.
Build a monthly expense budget. Budget limit: 1000. Data: Rent 800; Utilities 120; Supplies 80. Calculate total expenses and the remaining budget.
- 10 cells of supplied data: A2, B2, A3, B3, A4, B4…
- D3 → =SUM(B2:B4)
- D4 → =D2-D3
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Build a monthly expense budget. Budget limit: 1000. Data: Rent 800; Utilities 120; Supplies 80. Calculate total expenses and the remaining budget.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | North | 1200 |
| 3 | South | 900 |
| 4 | West | 1500 |
Il brief Business goal: compare regional sales for a business review. Supplied data: North 1200; South 900; West 1500. Desired result: a product-style column comparison of all three regions, a descriptive sales title, and a statement identifying the highest-sales region and its value.
Summarise regional sales for a business review. Data: North 1200; South 900; West 1500. Create a column chart titled "Sales by region" and identify the highest sales region with its value.
- 6 cells of supplied data: A2, B2, A3, B3, A4, B4
- Column chart from A1:B4 titled “Sales by region”
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Summarise regional sales for a business review. Data: North 1200; South 900; West 1500. Create a column chart titled "Sales by region" and identify the highest sales region with its value.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
- Scrivi il prompt
- Rivedi
- Applica
- Controlla
Il tuo brief aziendale
Esempio Prompt di esempio del tutor
Esamina le azioni dell'esempio del tutor
Rivedi prima di applicare
Modifiche proposte a celle, formule e grafici
Il tuo primo prompt funziona. Vuoi conservare questi progressi?
Per ora appartengono a questa sessione del browser. Accedi con il tuo account AI Coalition Network per conservarli.
Salva i miei progressi →Ora sai trasformare un brief aziendale in un foglio di calcolo verificato.
Hai creato un registro delle vendite, un budget delle spese collegato e un grafico per regione. Ora impara la pulizia dei dati, i modelli finanziari, le ricerche affidabili, le tabelle pivot native e le dashboard.
Anteprima del resto del corso →I capitoli 1–2 sono gratuiti. L'accesso completo al corso costa $19 USD una tantum, inclusi esercizi, verifiche e tutoraggio sulle lezioni aggiornati. Nessun abbonamento obbligatorio. Consulta l'offerta di lancio natalizia e la disponibilità del pagamento →
Chiedi di questa lezione
Tutor demo fisso
Segui le celle evidenziate.
Usa questa cartella di lavoro in Excel
Funzionalità della cartella di lavoro e versione salvata
Versione 0
Queste lezioni predisposte supportano operazioni aritmetiche, parentesi e SUM nelle righe di dati numerici 2–4. Altre funzioni, collegamenti esterni e codice arbitrario vengono rifiutati. Le operazioni non supportate producono un errore visibile.