極簡ChatGPT:如何利用AI提高辦公效率

韓穎 關東升

  • 出版商: 清華大學
  • 出版日期: 2023-10-01
  • 售價: $354
  • 貴賓價: 9.5$336
  • 語言: 簡體中文
  • 頁數: 208
  • ISBN: 7302645876
  • ISBN-13: 9787302645870
  • 相關分類: ChatGPT
  • 立即出貨 (庫存=1)

  • 極簡ChatGPT:如何利用AI提高辦公效率-preview-1
  • 極簡ChatGPT:如何利用AI提高辦公效率-preview-2
  • 極簡ChatGPT:如何利用AI提高辦公效率-preview-3
極簡ChatGPT:如何利用AI提高辦公效率-preview-1

買這商品的人也買了...

相關主題

商品描述

《極簡ChatGPT:如何利用AI提高辦公效率》從ChatGPT的使用入手,系統介紹瞭如何使用它實現Office自動化與數據分析。本書內容豐富,案例詳盡,可作為ChatGPT的使用教程與參考手冊,適合Office應用人員、數據分析師與項目管理人員閱讀。

目錄大綱

           第 1 章   認識   ChatGPT   與其應用場景 ......................................................................... 1

               1.1 ChatGPT   簡介 .........................................................................................................1

                    1.1.1 註冊   ChatGPT ..............................................................................................1

                    1.1.2 使用   ChatGPT ..............................................................................................3

               1.2  如何與    ChatGPT  交談 .............................................................................................4

                    1.2.1 提問的技巧與註意事項 ................................................................................4

                    1.2.2 示例   1:向   ChatGPT  提問的技巧與註意事項 ..............................................5

               1.3 ChatGPT   應用場景  .................................................................................................6

               1.4  本章總結 .................................................................................................................7

 

           第 2 章   學會與    ChatGPT   對話的語言 ......................................................................... 8

               2.1  繪圖語言 .................................................................................................................8

                    2.1.1 使用   Mermaid  繪圖語言 ...............................................................................9

                    2.1.2 示例   2:使用    ChatGPT  繪制本季度產品銷售占比餅圖 ..............................11

                    2.1.3  PlantUML 繪圖語言 ...................................................................................12

                    2.1.4 示例   3:使用    ChatGPT  繪制會議申請與執行流程 .....................................14

               2.2  輕量級的標記語言          Markdown ...............................................................................16

                    2.2.1 Markdown  基本語法 ...................................................................................16

                    2.2.2 示例   4:使用    ChatGPT  撰寫年度部門工作計劃 .........................................19

               2.3  使用編程語言 .......................................................................................................21

                    2.3.1 安裝   Python 語言運行環境 .........................................................................22

                    2.3.2 示例   5:使用    Python 繪制本季度產品銷售占比餅圖 .................................23

               2.4  本章總結 ...............................................................................................................27

 

           第 3 章   讓  ChatGPT   幫您理清思路 ........................................................................... 28

               3.1  思維導圖 ...............................................................................................................28

                    3.1.1 在辦公中使用思維導圖 ..............................................................................28

                    3.1.2 繪制思維導圖 .............................................................................................29

                    3.1.3 使用   ChatGPT  繪制思維導圖 .....................................................................31

                    3.1.4 示例   6:使用    Markdown 繪制“本周工作計劃”思維導圖 ........................33

 

 

全書.indd   5                                                                                     2023/9/21   11:12:24    VI     極簡   ChatGPT:如何利用         AI 提高辦公效率

 

                    3.1.5  示例  7:使用    PlantUML  繪制“新員工入職培訓計劃”思維導圖 .............35

               3.2  魚骨圖 ..................................................................................................................38

                    3.2.1 魚骨圖在辦公中的應用 ..............................................................................38

                    3.2.2 使用   ChatGPT  輔助繪制魚骨圖 ..................................................................39

                    3.2.3 示例   8:下一年銷售目標增長            200%  分析 ..................................................40

               3.3  表格 ......................................................................................................................43

                    3.3.1 Markdown  表格 ..........................................................................................43

                    3.3.2 示例   9:項目管理進度表 ...........................................................................44

                    3.3.3 CSV  電子表格 ............................................................................................46

                    3.3.4 轉換為    Excel 文件 ......................................................................................48

               3.4  本章總結 ...............................................................................................................48

 

           第 4 章   使用   ChatGPT   實現時間管理 ....................................................................... 50

               4.1  時間管理工具 .......................................................................................................50

               4.2  使用日歷管理時間 ................................................................................................50

                    4.2.1  Excel 日歷 ..................................................................................................50

                    4.2.2  Windows 系統自帶的日歷應用程序 ...........................................................51

                    4.2.3 移動設備上的日歷應用程序 .......................................................................52

                    4.2.4 示例   10:使用    ChatGPT  輔助“本周工作計劃”管理 ................................53

               4.3  番茄工作法 ...........................................................................................................54

                    4.3.1 番茄工作法的優勢 .....................................................................................55

                    4.3.2 示例   11:使用    ChatGPT  採用番茄工作法管理時間 ...................................55

               4.4  本章總結 ...............................................................................................................57

 

           第 5 章   使用   ChatGPT   實現任務管理 ....................................................................... 58

               5.1  制訂任務清單 .......................................................................................................58

                    5.1.1 使用   ChatGPT  制訂任務清單 .....................................................................59

                    5.1.2 示例   12:使用    ChatGPT  輔助製作“下周計劃”任務清單 ........................60

               5.2  制訂工作計劃 .......................................................................................................63

                    5.2.1 使用   ChatGPT  制訂工作計劃 .....................................................................63

                    5.2.2 示例   13:使用    ChatGPT  輔助制訂公司年度銷售會議計劃 ........................64

                    5.2.3 使用甘特圖 ................................................................................................66

                    5.2.4 示例   14:使用    ChatGPT  輔助繪制     Excel 甘特圖 .......................................68

                    5.2.5 示例   15:使用    ChatGPT  輔助繪制     Project 甘特圖 .....................................69

               5.3  跟蹤任務 ...............................................................................................................74

                    5.3.1 使用   ChatGPT  輔助跟蹤任務 .....................................................................74

 

 

全書.indd   6                                                                                     2023/9/21   11:12:24                                                                                         目  錄        VII

 

                    5.3.2 示例   16:使用    ChatGPT  輔助跟蹤公司年度銷售會議計劃 ........................74

                    5.3.3 示例   17:使用魚骨圖分析進度延遲的原因 ................................................76

               5.4  本章總結 ...............................................................................................................77

 

           第 6 章 ChatGPT     輔助實現郵件自動化 ..................................................................... 78

               6.1  使用   ChatGPT  輔助管理聯系人信息 .....................................................................78

                    6.1.1 提取聯系人信息 .........................................................................................78

                    6.1.2 示例   18:使用    ChatGPT  從往來郵件中提取聯系人信息 ............................78

                    6.1.3 聯系人信息整理 .........................................................................................81

                    6.1.4 示例   19:使用    ChatGPT  整理聯系人信息 ..................................................81

                    6.1.5 創建聯系人檔案 .........................................................................................83

                    6.1.6 示例   20:使用    ChatGPT  創建聯系人檔案 ..................................................83

               6.2  使用   ChatGPT  輔助處理郵件內容 .........................................................................85

                    6.2.1 郵件模板生成 .............................................................................................85

                    6.2.2 示例   21:使用    ChatGPT  生成郵件模板 ......................................................85

                    6.2.3 示例   22:使用    ChatGPT  分析會議紀要並撰寫郵件 ...................................87

               6.3  本章總結 ...............................................................................................................90

 

           第 7 章 ChatGPT     輔助實現     Word  自動化 .................................................................. 91

               7.1  使用   ChatGPT  生成  Word  文件 .............................................................................91

                    7.1.1 如何使用     ChatGPT  生成   Word 文件 ...........................................................91

                    7.1.2 示例   23:使用    ChatGPT  生成   XYZ 產品的報告 ........................................91

               7.2 ChatGPT+VBA .....................................................................................................98

                    7.2.1 編寫和運行      VBA   程序 ...............................................................................98

                    7.2.2 示例   24:使用    ChatGPT  輔助生成     VBA  代碼 ..........................................100

               7.3  示例   25:.doc 文件批量轉換為         .docx 文件 .........................................................102

               7.4  示例   26:Word  文件批量轉換為         PDF  文件 .........................................................106

               7.5  示例   27:批量統計文件頁數和字數 ...................................................................108

               7.6  本章總結 .............................................................................................................112

 

           第 8 章 ChatGPT     輔助實現     Excel 自動化 ................................................................113

               8.1  使用   ChatGPT  生成  Excel 文件 ...........................................................................113

                    8.1.1 如何使用     ChatGPT  生成   Excel 文件 .........................................................113

                    8.1.2 示例   28:使用    ChatGPT  生成   10 月份銷售報表 .......................................113

               8.2 ChatGPT   輔助格式轉換 ......................................................................................116

                    8.2.1  .xls 文件批量轉換為      .xlsx 文件 ................................................................116

                    8.2.2  .csv 文件批量轉換為       .xlsx 文件 ................................................................118

 

 

全書.indd   7                                                                                     2023/9/21   11:12:24  VIII     極簡   ChatGPT:如何利用         AI 提高辦公效率

 

               8.3  可視化報表 .........................................................................................................121

                    8.3.1 ChatGPT  輔助製作數據可視化報表 .........................................................121

                    8.3.2 示例   29:ChatGPT+VBA     生成圖表 .........................................................121

                    8.3.3 示例   30:使用    ChatGPT  通過無編程方式生成圖表 .................................123

               8.4  本章總結 .............................................................................................................126

 

           第 9 章 ChatGPT     輔助實現     PPT  演示文稿自動化 .....................................................127

               9.1  使用   ChatGPT  輔助生成     PPT 文件 ......................................................................127

                    9.1.1 如何使用     ChatGPT  生成   PPT 文件 ...........................................................127

                    9.1.2 示例   31:周度銷售業績報告           PPT ............................................................128

                    9.1.3 示例   32:使用    ChatGPT+VBA    輔助自動製作       PPT ..................................131

               9.2  示例   33:批量轉換      PPT  文件格式為      PPTX  文件格式 .........................................135

               9.3  示例   34:批量轉換      PPT  文件為   PDF  文件 ..........................................................138

               9.4  本章總結 .............................................................................................................141

 

           第 10 章 ChatGPT     輔助實現數據分析與可視化 ........................................................142

               10.1  數據分析 ...........................................................................................................142

                    10.1.1 使用   ChatGPT  輔助數據清洗 .................................................................142

                    10.1.2 示例   35:使用    ChatGPT  清洗客戶購買數據 ..........................................143

               10.2  數據可視化 .......................................................................................................145

                    10.2.1 ChatGPT  輔助數據可視化 ......................................................................145

                    10.2.2 示例   36:使用    ChatGPT  通過無編程方式生成圖表 ...............................145

                    10.2.3 示例   37:使用    ChatGPT+VBA    生成圖表 ...............................................149

                    10.2.4 示例   38:使用    ChatGPT+Python   生成圖表 ............................................151

               10.3  本章總結 ...........................................................................................................155

 

           第 11 章   綜合案例實戰訓練營 .................................................................................156

               11.1  案例   1:智慧產品月報——使用             ChatGPT+Office  製作產品月報 .....................156

                    11.1.1 任務   1:採集所需數據 ...........................................................................157

                    11.1.2 任務   2:利用    ChatGPT  生成報告框架和主要內容 .................................158

                    11.1.3 任務   3:人工完善和修訂詳情 ................................................................161

                    11.1.4 任務   4:使用    Office 工具設計格式 ........................................................161

                    11.1.5 任務   5:定期審閱與迭代 .......................................................................163

               11.2  案例   2:項目管理自動化——使用              ChatGPT  輔助敏捷團隊的任務分配與 

                     跟蹤 ..................................................................................................................163

                    11.2.1 任務   1:任務分配 ..................................................................................164

                    11.2.2 任務   2:任務跟蹤 ..................................................................................165

 

 

全書.indd   8                                                                                     2023/9/21   11:12:24                                                                                         目  錄        IX

 

                    11.2.3 任務   3:自動報告 ..................................................................................166

               11.3  案例   3:營銷策略優化——ChatGPT            輔助制訂產品推廣計劃與市場調研報告 ....171

                    11.3.1 任務   1:確定研究目標和問題 ................................................................172

                    11.3.2 任務   2:收集市場數據 ...........................................................................173

                    11.3.3 任務   3:分析市場數據 ...........................................................................174

                    11.3.4 任務   4:競爭對手分析 ...........................................................................174

                    11.3.5 任務   5:消費者洞察 ...............................................................................175

                    11.3.6 任務   6:編寫市場調研報告 ....................................................................176

               11.4  案例   4:電子商務公司客戶購買數據清洗和可視化分析 ..................................180

                    11.4.1 任務   1:ChatGPT   輔助數據收集 ............................................................180

                    11.4.2 任務   2:數據清洗 ..................................................................................181

                    11.4.3 任務   3:初步可視化 ...............................................................................184

                    11.4.4 任務   4:發現數據洞察 ...........................................................................187

               11.5  案例   5:電動車電池質量問題分析 ...................................................................189

                    11.5.1 任務   1:收集與分析問題相關的數據 .....................................................189

                    11.5.2 任務   2:對數據進行初步分析 ................................................................189

                    11.5.3 任務   3:比較與分析不同變量的數據 .....................................................190

                    11.5.4 任務   4:深入校驗與分析具體的數據 .....................................................190

                    11.5.5 任務   5:構建魚骨圖進行原因關聯分析 .................................................192

                    11.5.6 任務   6:校驗並確定根本原因 ................................................................192

               11.6  本章總結 ...........................................................................................................193

 

 

全書.indd   9                                                                                     2023/9/21   11:12:24