小さな一歩から、本物のスキルへ。
次に身につける役立つスキル.
作業を説明し、提案を確認し、Excelの結果を検証します。
無料レッスン3本 · 役立つ1章
以前の評価は保持されています。保存済みの作業内容は変更されません。新しい課題では、プロンプト、確認、適用、検証の流れを使います。
あなたのExcelガイド
実践しながら、自分のペースで学ぶ最初のExcelプロンプト
デモを見てから、練習しましょう。
| 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 |
指示書 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 |
指示書 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 |
指示書 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 |
指示書 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 |
指示書 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 |
指示書 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.
- プロンプトを書く
- 確認
- 適用
- チェック
あなたのビジネス向け指示
例 チューターのプロンプト例
チューターの例の操作を確認する
適用前に確認
提案されたセル、数式、グラフの変更
最初のプロンプトが動きました。この進捗を保存しますか?
現在は、このブラウザセッションにのみ保存されています。AI Coalition Networkのアカウントでサインインすると、進捗を引き継げます。
進捗を保存する →ビジネス向けの指示を、チェック済みのスプレッドシートにできるようになりました。
売上管理表、連動した経費予算、地域別グラフを作成しました。次は、データ整理、財務モデル、信頼できるルックアップ、ネイティブのピボットテーブル、ダッシュボードを学びましょう。
後半のコースをプレビュー →第1章〜第2章は無料です。フルコースアクセスは1回のお支払いで $19 USD で、最新の演習、評価、レッスン指導が含まれます。必須のサブスクリプションはありません。ホリデー限定オファーと購入可否を見る →
このレッスンについて質問する
固定デモチューター
ハイライトされたセルに従ってください。
このワークブックをExcelで使う
ワークブックの機能と保存バージョン
バージョン 0
これらのレッスン用に作られた機能は、数値データの2〜4行目における算術演算、括弧、SUM関数に対応しています。その他の関数、外部リンク、任意のコードは受け付けられません。対応していない操作を行うと、エラーが表示されます。