AI Formulas and Automation in Excel and Google Sheets

Excel 與 Google Sheets 的 AI 公式與自動化

Use AI functions and scripts inside spreadsheets to classify, summarise and transform data at scale.

สิ่งที่คุณจะได้รับ

• All 8 chapters (PDF), Appendix A with 10 prompt templates, English summary; single-user licence.
• Main tool: Excel Copilot 與 GPT for Sheets
• Includes a worked example, checklists and an English summary of every chapter.
• Licence: single user

บทเรียน

1. Course Overview and Learning Goals課程導覽與學習目標
2. Setup and Core OperationsExcel Copilot 與 GPT for Sheets：環境準備與基本操作
3. Breaking Down the Task and Preparing Inputs需求拆解與輸入整理：表格數據的分類、摘要與自動處理
4. Prompt and Parameter Design提示詞與參數設計
5. Building the Workflow and Connecting Tools工作流搭建與工具串接
6. Worked Example案例演練：自動分類 5,000 筆客訴並生成部門摘要
7. Quality Checks, Common Problems and Risks品質檢查、常見問題與風險
8. Measuring, Iterating and Going Further效率度量、迭代與進階延伸

รหัสสินค้า: SW-C-019-P