Word/Excel/PPT 2013辦公三合一傻瓜書

01 Office 2013全新體驗
1.1 初識Office 2013 ····································2
1.1.1 Office 2013 辦公軟件的特點·················2
1.1.2 Office 2013 主要組件及其用途·············3
1.2 安裝Office 2013 ····································4
1.3 認識Word 2013 工作界面······················6
1.4 Office 2013 的基本操作·························8
1.4.1 新建文件··················································8
1.4.2 打開文件················································10
1.4.3 保存文件················································10
1.4.4 打印文件················································12
1.4.5 關(guān)閉文件················································13
1.4.6 認識Word 2013 視圖模式····················14

02 Word 2013文檔基本操作
2.1 編輯文本·············································· 18
2.1.1 輸入文本················································18
2.1.2 選擇文本················································18
2.1.3 復(fù)制文本················································20
2.1.4 刪除文本················································20
2.1.5 剪切文本················································21
2.1.6 撤銷、恢復(fù)和重復(fù)操作························21
2.1.7 查找與替換文本····································22
2.2 輸入特殊字符······································· 24
2.2.1 輸入帶圈字符········································24
2.2.2 添加漢語拼音········································25
2.2.3 添加字符邊框········································26
2.2.4 插入特殊符號········································27
2.2.5 插入數(shù)學(xué)公式········································27
2.3 設(shè)置文本與段落格式···························· 29
2.3.1 設(shè)置文本格式·······································29
2.3.2 設(shè)置段落格式·······································32
2.4 使用項目符號與編號····························34
2.4.1 插入項目符號·······································35
2.4.2 插入編號···············································36
2.5 設(shè)置邊框和底紋····································37
2.5.1 為文字添加邊框和底紋·······················37
2.5.2 為段落添加邊框和底紋·······················39

03 制作圖文并茂的Word文檔
3.1 在文檔中插入圖片································42
3.1.1 插入電腦中的圖片·······························42
3.1.2 插入聯(lián)機圖片·······································42
3.1.3 獲取屏幕截圖·······································44
3.2 編輯圖片···············································45
3.2.1 調(diào)整圖片大小與角度···························45
3.2.2 刪除圖片背景·······································46
3.2.3 裁剪圖片···············································47
3.2.4 設(shè)置圖片樣式·······································49
3.2.5 更改圖片位置·······································49
3.3 使用自選圖形·······································51
3.3.1 插入自選圖形·······································51
3.3.2 設(shè)置自選圖形格式·······························52
3.4 使用文本框···········································55
3.4.1 插入文本框···········································55
3.4.2 設(shè)置文本框效果···································57
3.5 使用藝術(shù)字···········································58
3.5.1 插入藝術(shù)字···········································58
3.5.2 設(shè)置藝術(shù)字效果···································59
3.6 使用SmartArt 圖形·······························61
3.6.1 認識SmartArt 圖形······························61
3.6.2 創(chuàng)建SmartArt 圖形······························ 61
3.6.3 更改布局··············································· 62
3.6.4 應(yīng)用Smartart 圖形樣式······················· 64

04 辦公表格的編輯與應(yīng)用
4.1 創(chuàng)建表格·············································· 66
4.1.1 使用網(wǎng)格創(chuàng)建表格······························· 66
4.1.2 使用“插入表格”對話框創(chuàng)建表格··· 66
4.1.3 手動繪制表格······································· 67
4.1.4 插入Excel 表格···································· 69
4.1.5 快速插入表格······································· 69
4.2 編輯單元格·········································· 70
4.2.1 選定表格中的單元格··························· 70
4.2.2 輸入文本并設(shè)置格式··························· 72
4.2.3 設(shè)置對齊方式······································· 74
4.3 編輯表格·············································· 75
4.3.1 插入行、列與單元格··························· 75
4.3.2 刪除行、列與單元格··························· 77
4.3.3 合并與拆分單元格······························· 78
4.3.4 調(diào)整行高與列寬··································· 80
4.3.5 設(shè)置表格邊框和底紋··························· 81
4.3.6 套用表格格式······································· 83
4.3.7 繪制斜線表頭······································· 83
4.4 表格文本的排序與計算························ 84
4.4.1 表格中數(shù)據(jù)的計算······························· 84
4.4.2 表格中文本的排序······························· 85
4.5 表格與文本轉(zhuǎn)換··································· 86
4.5.1 將表格轉(zhuǎn)換為文本······························· 87
4.5.2 將文本轉(zhuǎn)換為表格······························· 87
4.6 實戰(zhàn)——制作工資表···························· 88

05 辦公文檔頁面設(shè)置與打印
5.1 美化文檔頁面······································· 94
5.1.1 設(shè)置水印效果······································· 94
5.1.2 設(shè)置頁面背景······································· 95
5.1.3 插入文檔封面頁··································· 97
5.2 頁面設(shè)置··············································98
5.2.1 設(shè)置頁邊距與裝訂線邊距··················· 98
5.2.2 設(shè)置紙張············································· 100
5.2.3 插入頁眉與頁腳································· 101
5.2.4 插入頁碼············································· 103
5.2.5 設(shè)置文檔分欄····································· 104
5.3 打印辦公文檔·····································106
5.3.1 添加網(wǎng)絡(luò)打印機································· 106
5.3.2 打印設(shè)置············································· 107

06 Word 2013高級辦公操作
6.1 使用文檔視圖····································· 110
6.1.1 使用大綱視圖······································110
6.1.2 使用閱讀版式視圖······························111
6.2 拆分與并排窗口··································112
6.2.1 拆分窗口··············································112
6.2.2 并排查看文檔······································113
6.3 使用書簽············································ 115
6.3.1 添加書簽··············································115
6.3.2 定位書簽··············································115
6.4 創(chuàng)建目錄············································ 116
6.4.1 添加手動目錄······································116
6.4.2 自動生成目錄······································116
6.4.3 更新目錄··············································118
6.5 編制索引············································118
6.6 添加腳注與尾注··································119
6.6.1 插入腳注··············································119
6.6.2 插入尾注············································· 120
6.6.3 設(shè)置腳注與尾注編號格式················· 121
6.6.4 腳注與尾注相互轉(zhuǎn)換························· 122
6.6.5 刪除腳注或尾注································· 123
6.7 頁面分節(jié)與分頁································· 124
6.7.1 插入分節(jié)符········································· 125
6.7.2 插入分頁符········································· 125
6.8 文檔的審閱·········································126
6.8.1 添加批注··············································126
6.8.2 更改批注的顯示方式··························126
6.8.3 對文檔內(nèi)容進行修訂··························128
6.8.4 拒絕或接受修訂··································128
6.9 保護文檔············································ 129
6.9.1 限制文檔編輯······································129
6.9.2 取消文檔保護······································130

07 Excel 2013表格制作快速入門
7.1 認識Excel 2013 工作界面················· 132
7.2 工作表的基本操作······························ 133
7.2.1 插入工作表··········································133
7.2.2 刪除工作表··········································134
7.2.3 移動工作表··········································134
7.2.4 復(fù)制工作表··········································135
7.2.5 重命名工作表······································136
7.2.6 保護工作表··········································137
7.2.7 隱藏工作表··········································138
7.3 在工作表中輸入數(shù)據(jù)·························· 138
7.3.1 輸入文本··············································139
7.3.2 輸入數(shù)字··············································139
7.4 填充工作表數(shù)據(jù)································· 140
7.4.1 快速填充數(shù)據(jù)······································140
7.4.2 填充數(shù)據(jù)序列······································140
7.4.3 自定義固定填充··································141
7.5 單元格操作········································· 142
7.5.1 選擇單元格··········································142
7.5.2 刪除單元格··········································142
7.5.3 合并單元格··········································143
7.5.4 清除單元格············································144
7.5.5 凍結(jié)單元格··········································145
7.6 行和列的操作····································· 145
7.6.1 選擇行和列··········································146
7.6.2 自動調(diào)整行高或列寬··························146
7.6.3 設(shè)置固定行高或列寬·························147
7.7 設(shè)置單元格數(shù)據(jù)格式··························149
7.7.1 設(shè)置數(shù)據(jù)字體格式·····························149
7.7.2 設(shè)置數(shù)據(jù)對齊格式·····························150

08 制作專業(yè)的Excel 辦公表格
8.1 設(shè)置單元格邊框和底紋·······················152
8.1.1 設(shè)置單元格邊框·································152
8.1.2 設(shè)置單元格底紋·································153
8.2 使用條件格式·····································154
8.2.1 使用數(shù)據(jù)條·········································154
8.2.2 使用圖標集·········································155
8.2.3 突出顯示單元格規(guī)則·························156
8.3 設(shè)置工作表·········································156
8.3.1 為工作表標簽設(shè)置顏色·····················157
8.3.2 添加工作表背景·································157
8.3.3 工作表頁面設(shè)置·································158
8.3.4 設(shè)置打印區(qū)域·····································159
8.3.5 為工作表添加頁碼·····························160
8.4 插入圖片、藝術(shù)字與SmartArt圖形·····161
8.4.1 插入圖片·············································161
8.4.2 插入藝術(shù)字·········································162
8.4.3 插入SmartArt 圖形····························163
8.5 使用批注·············································164
8.5.1 插入批注·············································164
8.5.2 設(shè)置批注格式·····································165
8.5.3 刪除和隱藏批注·································166

09 Excel 圖表、公式與函數(shù)應(yīng)用
9.1 應(yīng)用圖表·············································168
9.1.1 創(chuàng)建圖表·············································168
9.1.2 編輯圖表·············································169
9.1.3 美化圖表·············································171
9.2 修改圖表布局···································· 172
9.2.1 添加圖表元素····································· 172
9.2.2 設(shè)置圖表元素格式····························· 172
9.2.3 插入形狀和圖片································· 173
9.2.4 添加趨勢線········································· 175
9.2.5 添加誤差線········································· 175
9.2.6 創(chuàng)建圖表標題鏈接····························· 177
9.3 應(yīng)用公式············································ 178
9.3.1 公式的結(jié)構(gòu)········································· 178
9.3.2 運算符················································· 178
9.3.3 運算符的優(yōu)先級································· 180
9.3.4 開始輸入公式····································· 180
9.3.5 復(fù)制公式············································· 181
9.3.6 編輯公式············································· 183
9.3.7 修改單元格引用································· 184
9.4 使用函數(shù)計算數(shù)據(jù)······························ 185
9.4.1 認識常用函數(shù)····································· 185
9.4.2 使用平均值函數(shù)································· 185
9.4.3 使用相乘函數(shù)····································· 187
9.4.4 使用最大值函數(shù)································· 188
9.4.5 使用文本函數(shù)····································· 188
9.5 使用嵌套函數(shù)計算數(shù)據(jù)······················ 189
9.5.1 使用IF函數(shù)判斷條件························ 190
9.5.2 IF 和OR 函數(shù)聯(lián)合應(yīng)用····················· 190
9.5.3 IF 和AND 函數(shù)聯(lián)合應(yīng)用·················· 191
9.6 檢查公式的準確性······························ 191
9.6.1 公式常見錯誤解析····························· 191
9.6.2 追蹤單元格········································· 192
9.6.3 顯示公式············································· 193

10 Excel辦公數(shù)據(jù)管理與分析
10.1 獲取外部數(shù)據(jù)··································· 196
10.1.1 獲取文本文檔中的數(shù)據(jù)··················· 196
10.1.2 獲取網(wǎng)頁中的數(shù)據(jù)··························· 197
10.1.3 更新獲取的外部數(shù)據(jù)······················· 198
10.2 數(shù)據(jù)篩選·········································· 199
10.2.1 自動篩選··········································· 200
10.2.2 高級篩選··········································· 200
10.3 數(shù)據(jù)排序··········································202
10.3.1 簡單排序··········································· 202
10.3.2 自定義排序······································· 202
10.4 分類匯總··········································204
10.4.1 創(chuàng)建分類匯總··································· 204
10.4.2 刪除分類匯總··································· 205
10.5 創(chuàng)建與編輯數(shù)據(jù)透視表·····················206
10.5.1 創(chuàng)建數(shù)據(jù)透視表······························· 206
10.5.2 移動數(shù)據(jù)透視表······························· 207
10.5.3 更改數(shù)據(jù)透視表結(jié)構(gòu)······················· 207
10.5.4 行標簽排序······································· 208
10.5.5 更改值的匯總方式··························· 209
10.5.6 更改值的顯示方式··························· 209
10.5.7 使用切片器篩選數(shù)據(jù)······················· 209
10.5.8 添加篩選器········································211
10.5.9 刪除數(shù)據(jù)透視表································211
10.6 創(chuàng)建與編輯數(shù)據(jù)透視圖·····················212
10.6.1 創(chuàng)建數(shù)據(jù)透視圖······························· 212
10.6.2 使用數(shù)據(jù)透視圖篩選數(shù)據(jù)··············· 213

11 PowerPoint 2013操作快速入門
11.1 認識演示文稿····································216
11.1.1 演示文稿與幻燈片的區(qū)別··············· 216
11.1.2 制作演示文稿的要點······················· 216
11.2 初識PowerPoint 2013······················217
11.2.1 啟動PowerPoint 2013 ······················ 217
11.2.2 PowerPoint 2013 工作界面·············· 217
11.2.3 熟悉PowerPoint 2013 視圖············· 218
11.3 創(chuàng)建演示文稿····································220
11.3.1 創(chuàng)建空白演示文稿··························· 220
11.3.2 使用模板創(chuàng)建演示文稿··················· 220
11.4 保存演示文稿····································221
11.4.1 保存新演示文稿······························· 222
11.4.2 將演示文稿保存為其他類型··········· 222
11.5 打開和關(guān)閉演示文稿························ 223
11.5.1 打開演示文稿····································223
11.5.2 關(guān)閉演示文稿····································225
11.6 幻燈片的基本操作···························· 226
11.6.1 新建幻燈片········································226
11.6.2 選擇幻燈片········································227
11.6.3 刪除幻燈片········································228
11.6.4 移動幻燈片········································228
11.6.5 復(fù)制幻燈片········································229
11.6.6 使用節(jié)組織幻燈片····························230

12 添加與編輯幻燈片對象
12.1 添加與編輯文字······························· 234
12.1.1 在幻燈片占位符中輸入文本············234
12.1.2 在大綱視圖下輸入文本····················234
12.1.3 設(shè)置字體格式····································235
12.1.4 設(shè)置文本段落格式····························236
12.2 插入與編輯圖片······························· 238
12.2.1 插入電腦圖片····································238
12.2.2 插入聯(lián)機圖片····································239
12.2.3 設(shè)置圖片格式····································239
12.3 插入表格·········································· 241
12.3.1 在幻燈片中插入表格························241
12.3.2 插入Excel 電子表格·························242
12.4 插入SmartArt 圖形·························· 244
12.4.1 插入V形流程圖·······························244
12.4.2 更改SmartArt 圖形···························245
12.4.3 將文本轉(zhuǎn)換為SmartArt 圖形···········246
12.5 插入與編輯形狀······························· 248
12.5.1 插入單個形狀····································248
12.5.2 插入多個形狀····································249
12.5.3 設(shè)置形狀樣式····································249
12.5.4 更改形狀············································251
12.6 插入與編輯文本框···························· 251
12.6.1 插入文本框········································251
12.6.2 在圖片上輸入文本····························252
12.7 插入與編輯圖表································252
12.7.1 插入圖表···········································253
12.7.2 更改圖表樣式···································253
12.8 插入媒體元素···································255
12.8.1 插入背景音樂···································255
12.8.2 插入視頻文件···································256

13 制作風(fēng)格統(tǒng)一的演示文稿
13.1 設(shè)置幻燈片大小································260
13.1.1 更改幻燈片比例·······························260
13.1.2 自定義幻燈片尺寸···························260
13.2 設(shè)置幻燈片背景································261
13.2.1 設(shè)置漸變背景···································261
13.2.2 設(shè)置圖片背景···································263
13.2.3 自定義紋理背景·······························264
13.3 設(shè)置幻燈片主題································265
13.3.1 應(yīng)用內(nèi)置主題···································265
13.3.2 應(yīng)用變體···········································266
13.3.3 創(chuàng)建自定義主題·······························268
13.4 使用母版···········································269
13.4.1 設(shè)置母版背景···································269
13.4.2 設(shè)計幻燈片版式·······························271
13.4.3 創(chuàng)建新版式·······································272
13.4.4 應(yīng)用新版式·······································274
13.4.5 插入Logo 圖片·································276
13.5 設(shè)置頁眉和頁腳································277
13.6 創(chuàng)建幻燈片模板································278

14 創(chuàng)建動態(tài)演示文稿
14.1 為幻燈片添加切換動畫·····················280
14.1.1 應(yīng)用切換動畫···································280
14.1.2 設(shè)置切換速度和計時·······················281
14.1.3 添加切換聲音···································281
14.2 將幻燈片制成動畫····························282
14.2.1 應(yīng)用進入動畫··································· 282
14.2.2 繼續(xù)添加動畫··································· 284
14.2.3 更換動畫··········································· 284
14.2.4 調(diào)整動畫順序··································· 285
14.2.5 刪除動畫··········································· 285
14.2.6 設(shè)置動畫效果··································· 286
14.2.7 使用動畫刷······································· 287
14.3 制作第1張幻燈片動畫···················· 288
14.4 為SmartArt 圖形添加動畫··············· 291
14.5 為圖表添加動畫······························· 292
14.6 創(chuàng)建路徑動畫··································· 293
14.7 創(chuàng)建母版動畫··································· 295
14.8 添加動畫觸發(fā)器······························· 297

15 演示文稿的放映與導(dǎo)出
15.1 設(shè)置交互式演示文稿························ 300
15.1.1 為對象創(chuàng)建超鏈接··························· 300
15.1.2 創(chuàng)建文本超鏈接······························· 302
15.1.3 更改超鏈接文本顏色······················· 303
15.1.4 鏈接到外部文件······························· 304
15.1.5 鏈接到網(wǎng)頁······································· 305
15.1.6 編輯與刪除超鏈接··························· 306
15.1.7 插入動作按鈕··································· 306
15.1.8 為幻燈片對象添加動作··················· 308
15.2 設(shè)置幻燈片放映································ 311
15.2.1 隱藏幻燈片········································311
15.2.2 放映指定的幻燈片····························311
15.2.3 設(shè)置放映類型··································· 313
15.2.4 排列計時··········································· 313
15.2.5 錄制幻燈片演示······························· 315
15.2.6 開始放映幻燈片······························· 315
15.3 導(dǎo)出演示文稿···································318
15.3.1 發(fā)布為PDF文檔····························· 318
15.3.2 創(chuàng)建視頻文件··································· 318
15.3.3 另存為放映文件······························· 320