內容簡介
《Office 2016高級套用》是一門實踐性很強的專業基礎課程,主要注重培養學生的實際操作能力。內容涉及到Office 系列中Word、Excel、PowerPoint、Access、Outlook、Visio、Project 以及Publisher的高級操作;通過本課程的學習,學生應能夠掌握文字處理功能、編輯排版圖書功能、瀏覽編輯圖片功能、數據收集和處理功能、製作和播放演示文稿功能、電子郵件管理功能、日常工作安排套用功能、工程項目管理功能等,從而順利完成以後日常辦公、商業活動以及科研活動中的各種工作。
圖書目錄
第 1 章 Windows 10系統基本操作 ··········1
1.1 Windows 10的啟動與退出 ··············2
1.1.1 啟動Windows 10 ·························2
1.1.2 關機退出Windows 10 ·················2
1.1.3 系統睡眠與重新啟動 ··················3
1.2 Windows 10的桌面 ··························4
1.2.1 認識Windows 10的桌面 ············4
1.2.2 桌面圖示 ······································4
1.2.3 桌面背景 ······································6
1.2.4 系統列 ··········································6
1.3 “開始”選單 ···································7
1.3.1 認識“開始”選單 ······················7
1.3.2 系統控制區 ··································8
1.4 Windows 10中的對話框 ··················8
1.5 操作視窗 ···········································9
1.5.1 認識Windows 10視窗的構成 ····9
1.5.2 Windows 10視窗的操作 ···········10
1.6 Cortana ·············································11
1.6.1 Cortana可以提供的幫助 ··········11
1.6.2 Cortana的設定 ··························12
第 2 章 Office 2016基礎入門 ················13
2.1 Office 2016界面概述 ·····················14
2.1.1 功能區 ········································14
2.1.2 Backstage視圖 ···························15
2.1.3 快速訪問工具列 ························16
2.2 Office 2016安裝與卸載 ·················16
2.2.1 Office 2016的安裝 ····················16
2.2.2 Office 2016的卸載 ····················17
2.3 Office 2016組件的啟動與退出 ·····19
2.3.1 啟動Office 2016的3種方法 ····19
2.3.2 退出Office 2016的3種方法 ····20
2.4 Office 2016的幫助信息 ·················20
第3章 Word 2016基礎 ························21
3.1 Word 2016工作界面 ·······················22
3.1.1 標題欄 ········································22
3.1.2 選項卡 ········································22
3.1.3 功能區 ········································23
3.1.4 快速訪問工具列 ························24
3.1.5 文檔編輯區 ································24
3.1.6 狀態欄 ········································25
3.2 創建Word 文檔 ······························25
3.2.1 創建空白文檔 ····························25
3.2.2 使用模板創建文檔 ····················26
3.3 打開文檔 ·········································27
3.3.1 使用“打開”選項打開文檔 ····27
3.3.2 迅速打開最近打開過的文檔 ····28
3.4 查看並設定文檔屬性 ·····················29
3.4.1 設定文檔“唯讀”或“隱藏”
屬性 ············································29
3.4.2 設定“標題”和“作者”等
屬性 ············································29
3.5 保存文檔 ·········································30
3.5.1 保存和關閉文檔 ························30
3.5.2 設定自動保存文檔 ····················31
3.6 文檔保護功能 ·································33
3.6.1 刪除文檔中的個人信息 ············33
3.6.2 文檔許可權設定 ····························34
第 4 章 文檔簡單編輯 ····························36
4.1 瀏覽和定位文檔 ·····························37
4.1.1 瀏覽文檔 ····································37
4.1.2 定位文檔 ····································37
4.2 選定文檔內容 ·································38
4.2.1 拖曳滑鼠選定文檔內容 ············38
4.2.2 Shift鍵配合滑鼠選定連續
內容 ············································39
4.2.3 使用鍵盤選定文本 ····················39
4.2.4 其他常用選取文檔內容的
方法 ············································40
4.3 輸入文本 ·········································41
4.3.1 輸入方式的切換 ························41
4.3.2 改寫與插入狀態的切換 ············43
4.3.3 符號、編號的插入 ····················44
4.3.4 插入時間和日期 ························46
4.4 設定文字格式 ·································47
4.4.1 文字格式基本設定 ····················47
4.4.2 文字效果設定 ····························48
4.4.3 字元間距設定 ····························50
4.5 調整段落結構 ·································52
4.5.1 設定段落對齊方式 ····················52
4.5.2 縮進方式和間距控制 ················53
4.6 框線和底紋設定 ·····························54
4.6.1 設定文字框線與底紋 ················55
4.6.2 設定頁面框線 ····························57
4.6.3 設定頁面底紋 ····························57
4.7 撤銷、恢復和重複操作 ·················62
4.7.1 撤銷操作 ····································63
4.7.2 恢復操作 ····································64
4.7.3 重複操作 ····································64
4.8 查找、替換、定位功能 ·················65
4.8.1 查找 ············································65
4.8.2 替換 ············································66
第 5 章 頁面設定與文檔輸出 ·················69
5.1 選擇文檔視圖與版式 ·····················70
5.2 頁面設定 ·········································72
5.2.1 頁邊距設定 ································72
5.2.2 設定文檔紙張大小 ····················73
5.2.3 設定每頁行數和每行字元數 ····75
5.2.4 設定分頁和換行 ························76
5.2.5 使用中文版式控制文本對齊 ····77
5.3 設定頁眉頁腳 ·································77
5.3.1 插入頁眉 ····································77
5.3.2 調整頁眉和頁腳位置 ················81
5.3.3 設定頁碼 ····································81
5.4 使用樣式統一文檔格式 ·················83
5.4.1 在文檔中套用樣式 ····················83
5.4.2 新建樣式 ····································85
5.4.3 修改樣式 ····································87
5.4.4 複製並管理樣式 ························89
5.5 列印文檔 ·········································92
5.5.1 列印選項設定 ····························92
5.5.2 取消或暫停列印選項設定 ········94
第 6 章 創建與編輯表格 ·························95
6.1 插入和刪除表格 ·····························96
6.1.1 使用“表格”選單創建簡單
表格 ············································96
6.1.2 手動繪製表格 ····························96
6.1.3 文本與表格的相互轉換 ············99
6.1.4 刪除表格 ··································101
6.2 編輯表格 ·······································102
6.2.1 選取行、列或單元格 ··············103
6.2.2 合併單元格、拆分單元格和拆分
表格 ··········································105
6.2.3 調整行、列及單元格尺寸 ······108
6.2.4 插入行、列或單元格 ···············111
6.3 調整表格格式和布局 ···················112
6.3.1 設定表格文字方向和對齊
方式 ··········································112
6.3.2 使用自動套用格式功能 ··········114
6.3.3 設定文字環繞表格的形式 ······115
第7章 圖文混排 ··································118
7.1 圖片的插入和編輯 ·······················119
7.1.1 從檔案插入圖片 ······················119
7.1.2 插入在線上圖片 ··························120
7.1.3 設定圖片映像和藝術效果 ······123
V
7.1.4 調整圖片顏色、亮度與
對比度 ······································126
7.1.5 調整圖片方向 ··························127
7.1.6 調整圖片大小 ··························130
7.1.7 圖片布局設定 ··························134
7.2 圖形的插入和編輯 ·······················136
7.2.1 “繪圖”工具的用途 ··············136
7.2.2 繪製圖形並添加文字 ··············137
7.2.3 組合與分解多個圖形 ··············143
7.3 SmartArt圖形的插入和編輯 ········144
7.4 文本框的插入和編輯 ···················148
7.4.1 創建文本框 ······························149
7.4.2 調整文本框顏色、線條與
版式 ··········································151
7.5 使用公式編輯器插入公式 ···········153
第 8 章 高級排版功能 ··························155
8.1 項目符號和編號 ···························156
8.1.1 插入項目符號 ··························156
8.1.2 插入編號 ··································158
8.1.3 插入多級編號 ··························159
8.2 標記和編制索引 ···························162
8.2.1 標記索引 ··································162
8.2.2 編制索引 ··································163
8.3 腳註和章節附注的使用 ·······················165
8.4 自動創建目錄 ·······························167
8.5 文檔的審閱 ···································168
8.5.1 文檔的修訂 ······························169
8.5.2 為文檔設定批註 ······················170
8.5.3 篩選修訂和批註 ······················172
8.5.4 審閱修訂和批註 ······················174
8.5.5 快速比較文檔 ··························176
8.5.6 構建並使用文檔部件 ··············177
8.6 拼寫和語法檢查 ···························179
8.6.1 開啟拼寫和語法檢查功能 ······179
8.6.2 拼寫和語法檢查功能套用 ······180
第 9 章 Word排版實例 ························181
9.1 標題及正文格式設定 ···················182
9.1.1 樣式設定 ··································182
9.1.2 格式設定 ··································184
9.1.3 格式刷的運用 ··························184
9.2 參考文獻及注釋的設定 ···············184
9.2.1 參考文獻設定 ··························184
9.2.2 注釋設定 ··································187
9.3 目錄設定 ·······································188
9.3.1 添加目錄 ··································188
9.3.2 更新目錄 ··································189
9.4 分節符的添加 ·······························189
9.5 頁眉、頁腳的設定 ·······················190
9.5.1 頁眉設定 ··································190
9.5.2 頁碼設定 ··································192
9.6 頁面設定 ·······································193
第10 章 Excel基礎 ·····························194
10.1 Excel工作界面 ···························195
10.2 工作表操作 ·································195
10.2.1 插入工作表 ····························196
10.2.2 刪除工作表 ····························198
10.2.3 重命名工作表 ························199
10.2.4 移動、複製工作表 ················200
10.2.5 設定工作表標籤顏色 ············202
10.2.6 隱藏工作表 ····························204
10.2.7 拆分和凍結窗格 ····················206
10.3 輸入文本與數據 ·························207
10.3.1 輸入負數 ································207
10.3.2 輸入分數 ································208
10.3.3 輸入文本類型數字 ················209
10.4 填充 ·············································209
10.4.1 “填充”選項填充數據 ········209
10.4.2 填充柄填充數據 ····················211
10.4.3 填充柄填充公式 ····················213
10.5 選擇性貼上 ·································214
10.5.1 “選擇性貼上”工具列 ········214
10.5.2 選擇性“加”貼上 ················215
10.5.3 選擇性“乘”貼上 ················217
10.5.4 選擇性“轉置”貼上 ············218
第11 章 編輯工作表 ····························220
11.1 工作表格式設定 ··························221
11.1.1 調整工作表列寬、行高 ········221
11.1.2 調整對齊方式 ························224
11.1.3 修改數字格式 ························226
11.1.4 設定表格底紋 ························229
11.1.5 設定表格框線 ························231
11.1.6 設定和使用主題 ····················233
11.1.7 套用預設表格樣式 ················236
11.2 添加工作表批註 ··························239
11.2.1 添加批註 ································239
11.2.2 查看批註 ································241
11.2.3 修改批註 ································242
11.2.4 刪除批註 ································243
11.3 設定工作表組 ······························244
11.3.1 設定工作表組 ························244
11.3.2 取消工作表組 ························244
11.4 保護工作表 ··································245
11.4.1 保護工作表 ····························245
11.4.2 取消工作表的保護 ················247
11.5 列印工作表 ··································247
11.5.1 頁面設定 ································248
11.5.2 設定列印區域和列印順序 ····250
11.5.3 列印設定 ································252
第12章 公式和函式 ····························255
12.1 運算符 ·········································256
12.1.1 算術運算符 ····························256
12.1.2 比較運算符 ····························256
12.1.3 文本運算符 ····························257
12.1.4 引用運算符 ···························258
12.2 單元格引用 ·································259
12.2.1 相對引用 ································259
12.2.2 絕對引用 ································259
12.2.3 混合引用 ································260
12.3 公式和函式的輸入和編輯 ·········261
12.3.1 公式的輸入和編輯 ················261
12.3.2 函式的輸入和編輯 ················262
12.3.3 公式或函式中的常見錯誤 ····263
12.4 常用函式 ·····································264
12.4.1 文本函式 ································264
12.4.2 日期與時間函式 ····················265
12.4.3 統計函式 ································266
12.4.4 查找和引用函式 ····················267
12.4.5 邏輯函式 ································268
12.4.6 數學和三角函式 ····················268
12.4.7 兼容性函式 ····························269
12.4.8 財務函式 ································269
12.5 函式套用示例 ·····························270
12.5.1 學生成績表的計算 ················270
12.5.2 年齡與工齡的計算 ················281
12.5.3 銷售信息統計 ························283
12.5.4 貸款分期付款額的計算 ········285
12.5.5 身份證信息提取 ····················287
第13章 圖表 ·······································290
13.1 圖表類型 ·····································291
13.2 圖表的編輯 ·································291
13.2.1 插入圖表 ································291
13.2.2 修改圖表 ································293
13.2.3 完善圖表 ································298
13.3 迷你圖 ·········································301
13.3.1 迷你圖與圖表的關係 ············302
13.3.2 創建迷你圖 ····························302
13.3.3 填充迷你圖 ························303
13.4 數據透視表 ·································304
13.4.1 新建數據透視表 ····················304
13.4.2 添加和刪除欄位 ····················307
13.4.3 刪除“匯總”和“總計”
數據 ········································309
13.4.4 套用數據透視表格式 ············310
13.5 數據透視圖 ·································311
13.5.1 創建數據透視圖 ····················311
13.5.2 修改數據透視圖 ····················315
第14章 數據的分析和處理 ·················316
14.1 排序 ·············································317
14.1.1 簡單排序 ································317
14.1.2 複合排序 ································318
14.1.3 特殊排序 ································319
14.1.4 自定義排序 ····························321
14.2 篩選 ·············································324
14.2.1 自動篩選 ································324
14.2.2 自定義篩選 ····························327
14.2.3 高級篩選 ································328
14.3 分類匯總 ·····································329
14.3.1 創建分類匯總 ························329
14.3.2 分級顯示 ································331
14.3.3 刪除分類匯總 ························333
14.4 合併計算 ·····································333
14.5 單變數求解 ·································335
14.6 規劃求解 ·····································338
14.7 模擬運算表 ·································344
14.7.1 單變數模擬運算表 ················344
14.7.2 雙變數模擬求解 ····················346
14.8 Excel宏的簡單套用 ···················348
14.8.1 載入宏 ····································348
14.8.2 宏安全設定 ····························349
14.8.3 錄製宏 ····································349
14.8.4 運行宏 ····································351
14.8.5 刪除宏 ····································351
第15章 PowerPoint 2016 基礎 ··········352
15.1 PowerPoint視窗結構 ··················353
15.1.1 演示文稿編輯區 ····················353
15.1.2 視圖模式 ································354
15.1.3 顯示比例 ································354
15.2 新建演示文稿 ·····························354
15.2.1 新建空白演示文稿 ················354
15.2.2 根據設計模板創建演示文稿 ····356
15.2.3 根據主題創建演示文稿 ········358
15.3 使用不同視圖查看演示文稿 ·····360
15.3.1 普通視圖 ································360
15.3.2 幻燈片瀏覽視圖 ····················361
15.3.3 幻燈片放映視圖 ····················363
15.3.4 其他視圖 ································364
15.4 添加、刪除和調整幻燈片順序····365
15.4.1 添加、刪除幻燈片 ················365
15.4.2 調整幻燈片順序 ····················367
第16章 幻燈片的編輯 ························369
16.1 插入文本 ·····································370
16.1.1 在幻燈片中加入文本 ············370
16.1.2 在頁眉頁腳中加入文本 ········372
16.2 插入圖形 ·····································375
16.2.1 插入圖片 ································375
16.2.2 插入SmartArt圖形 ···············380
16.3 插入表格 ·····································383
16.3.1 插入表格 ································383
16.3.2 修飾表格 ································383
16.4 插入圖表 ·····································385
16.4.1 插入圖表模板 ························385
16.4.2 修改圖表 ································387
16.5 插入視頻檔案 ·····························388
16.5.1 插入檔案中的視頻 ················388
16.5.2 插入線上視頻 ························389
16.6 插入音頻檔案 ·····························389
16.6.1 插入音頻檔案 ························389
16.6.2 設定音頻檔案播放選項 ········391
16.6.3 插入錄製音頻 ························393
16.7 通過母版調整幻燈片外觀 ·········396
16.7.1 設定幻燈片母版 ····················396
16.7.2 設定講義母版 ························398
16.7.3 設定備註母版 ························399
16.8 幻燈片外觀設計 ·························401
16.8.1 設定主題 ································401
16.8.2 設定顏色方案 ························403
16.8.3 設計動畫效果 ························406
16.9 設計幻燈片切換效果 ·················409
第17章 演示文稿的放映和輸出 ··········412
17.1 插入旁白 ·····································413
17.2 排練計時 ·····································414
17.3 隱藏幻燈片 ·································416
17.4 設定自定義放映 ·························417
17.5 控制演示文稿放映 ·····················419
17.6 幻燈片書寫 ·································420
17.7 使用黑白板功能 ·························421
17.8 演示文稿輸出 ·····························422
17.8.1 打包演示文稿 ························422
17.8.2 播放演示文稿 ························424
17.9 頁面設定 ·····································425
17.10 列印演示文稿 ···························427
17.10.1 幻燈片列印 ··························427
17.10.2 列印講義、備註和大綱 ······430
第18章 Access 2016基礎 ·················432
18.1 資料庫基本概念 ·························433
18.1.1 資料庫系統 ····························433
18.1.2 數據模型 ································434
18.1.3 關係資料庫管理系統—
Access ·····································436
18.1.4 關係資料庫的特點 ················436
18.2 Access 2016的工作界面 ············437
18.2.1 Backstage視圖 ·······················437
18.2.2 功能區 ····································437
18.2.3 導航視窗 ································438
18.3 Access 2016的基本概念 ············438
18.3.1 運行方式 ································438
18.3.2 操作方式 ································439
18.3.3 Access 2016主體結構 ···········439
第19章 創建和維護資料庫 ·················442
19.1 資料庫的創建 ·····························443
19.1.1 創建空資料庫 ························443
19.1.2 使用樣本模板創建資料庫 ····444
19.2 資料庫的打開和關閉 ·················447
19.2.1 打開資料庫 ····························447
19.2.2 關閉資料庫 ····························448
19.3 創建數據表 ·································448
19.3.1 使用數據表視圖 ····················448
19.3.2 使用設計視圖 ························451
19.3.3 設定主鍵 ································452
19.3.4 設定有效性規則 ····················453
19.3.5 設定有效性文本 ····················455
19.3.6 向表中輸入數據 ····················456
19.4 創建查詢 ·····································457
19.4.1 使用查詢嚮導創建查詢 ········457
19.4.2 使用設計視圖創建查詢 ········459
19.5 設計窗體 ·····································462
19.5.1 窗體的主要功能 ····················462
19.5.2 使用嚮導創建窗體 ················462
19.6 創建報表 ·····································465
19.6.1 使用“報表”工具自動創建
報表 ········································466
19.6.2 使用“報表嚮導”創建報表 ····466
19.7 維護資料庫 ·································469
19.7.1 備份資料庫 ····························469
19.7.2 壓縮與修複數據庫 ················470
19.7.3 加密資料庫 ····························472
第20章 用Visio創建繪圖 ··················475
20.1 Visio 2016的繪圖環境 ···············476
20.2 新建空白繪圖 ·····························478
20.3 使用模板創建圖形 ·····················479
20.4 調整繪圖頁面顯示比例 ·············479
20.5 向繪圖頁面中添加形狀 ·············481
20.6 連線形狀 ·····································485
作者簡介
張麗瑋,首都經濟貿易大學管理工程學院副教授,一直從事計算機領域的教育工作,研究方向為文本挖掘、情報分析,先後主持國家社會科學基金、北京自然科學基金、北京社會科學基金以及中國博士後基金,在德國柏林工業大學訪問學者一年。2014年出版《office 2010高級套用教程》先後再版八次,受到相關讀者的好評。