CourseData & AnalyticsExcelGoogle Sheets
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.
What you get
- All 8 chapters, Appendix A prompt templates, Appendix B in-house training outline and exercises; 20-seat team licence for internal training.
- Main tool: Excel Copilot 與 GPT for Sheets
- Includes a worked example, checklists and an English summary of every chapter.
- Licence: 20 seats
Course modules
- Course Overview and Learning Goals課程導覽與學習目標
- Setup and Core OperationsExcel Copilot 與 GPT for Sheets：環境準備與基本操作
- Breaking Down the Task and Preparing Inputs需求拆解與輸入整理：表格數據的分類、摘要與自動處理
- Prompt and Parameter Design提示詞與參數設計
- Building the Workflow and Connecting Tools工作流搭建與工具串接
- Worked Example案例演練：自動分類 5,000 筆客訴並生成部門摘要
- Quality Checks, Common Problems and Risks品質檢查、常見問題與風險
- Measuring, Iterating and Going Further效率度量、迭代與進階延伸
FormatPDF · approx. 21 pages
Licence20 seats
DeliveryInstant download after payment confirmation (PDF / ZIP)
SKU: SW-C-019-T
