模块 1 文档处理的基本操作
1.1 快速创建文档 ··························· 1
1.1.1 在桌面上创建文档 ·····················1
1.1.2 启动 Word 2016 程序创建新文档 ···1
1.1.3 使用模板创建新文档 ·················2
1.1.4 使用快捷键创建新文档 ··············3
1.1.5 使用“文件”选项卡创建新文档 ··3
1.2 页面格式的设置······················· 4
1.2.1 设置页眉与页脚 ·······················4
1.2.2 设置页码 ································5
1.2.3 设置页边距 ·····························7
1.2.4 设置页面背景 ··························8
1.2.5 应用主题和样式集 ·················· 11
1.3 文档格式的编排····················· 14
1.3.1 字体格式的设置 ····················· 14
1.3.2 段落格式的设置 ····················· 15
1.3.3 中文版式的设置 ····················· 19
1.4 插入元素的设置 ····················· 20
1.4.1 插入符号 ······························ 20
1.4.2 插入公式 ······························ 22
1.4.3 插入并设置艺术字样式 ············ 27
1.4.4 插入并设置图片格式 ··············· 29
1.4.5 插入并设置 SmartArt 图形样式 ··· 31
1.4.6 应用文本框 ··························· 33
1.5 文档表格的高级操作··············· 35
1.5.1 创建与编辑文档表格 ··············· 35
1.5.2 设置文档表格格式 ·················· 38
1.5.3 表格的数据处理 ····················· 40
1.6 打印和保护文档 ····················· 41
1.6.1 打印预览 ······························ 41
1.6.2 打印文档 ······························ 44
1.6.3 设置只读文档 ························ 45
1.6.4 设置文档加密 ························ 47
1.6.5 设置文档权限 ························ 47
练一练 ·········································· 50
模块 2 文档处理的综合操作
2.1 文档样式的应用····················· 54
2.1.1 应用内置样式 ························ 55
2.1.2 新建样式 ······························ 55
2.1.3 修改样式 ······························ 57
2.1.4 删除样式 ······························ 57
2.2 模板的应用··························· 57
2.2.1 新建模板 ······························ 58
2.2.2 修改模板 ······························ 59
2.2.3 套用模板 ······························ 59
2.3 长文档的处理························ 60
2.3.1 创建主控文档、子文档 ············ 60
2.3.2 插入题注、书签、批注 ············ 63
2.3.3 创建格式化封面、目录 ············ 66
2.4 使用 Word 域 ························ 68
2.5 控件和宏功能的简单应用 ········ 70
2.5.1 添加控件 ······························ 70
2.5.2 控件的简单应用 ····················· 73
目 录
CONTENTS
MS Office 2016高级应用
·ii ·
MS Office 2016高级应用
2.5.3 宏功能 ································· 74
2.6 审阅与修订文档 ····················· 77
2.6.1 使用审阅功能 ························ 77
2.6.2 使用修订功能 ························ 81
2.7 邮件合并······························ 85
2.7.1 使用功能区按钮完成邮件合并
操作 ···································· 85
2.7.2 利用邮件合并向导完成邮件合并
操作 ··································· 90
练一练 ·········································· 92
模块 3 数据表格处理的基本
操作
3.1 工作表的格式设置与编排 ········ 96
3.1.1 单元格的操作 ························ 96
3.1.2 行与列的操作 ························ 97
3.1.3 工作表的操作 ························ 99
3.1.4 设置单元格格式 ····················100
3.2 数据分析与管理···················· 106
3.2.1 工作表数据的输入、编辑和
修改 ···································106
3.2.2 数据排序与筛选 ···················· 112
3.2.3 应用条件格式 ······················· 118
3.2.4 分类汇总 ·····························121
3.2.5 合并计算 ·····························124
3.2.6 数据分列 ·····························126
3.2.7 快速填充 ·····························128
3.2.8 删除重复值 ··························129
3.2.9 数据验证 ·····························130
3.2.10 应用迷你图 ··························132
3.2.11 创建与应用数据透视表和数据
透视图 ································135
3.3 图表的运用·························· 143
3.3.1 创建图表 ·····························143
3.3.2 图表的基本操作 ····················145
3.3.3 图表的修饰 ··························147
3.3.4 多个工作表的联动操作 ···········152
3.4 数据文档的保护···················· 154
3.4.1 保护电子表格文件 ·················155
3.4.2 保护工作簿的结构、窗口 ········157
3.4.3 保护工作表的内容、对象 ········158
3.4.4 保护单元格元素 ····················160
练一练 ·········································162
模块 4 数据表格处理的综合
操作
4.1 图表的扩展应用···················· 166
4.1.1 设置图表的格式 ····················166
4.1.2 数据图表的扩展应用 ··············169
4.2 工作簿间的链接···················· 172
4.2.1 定义单元格名称 ····················172
4.2.2 工作簿间的链接使用 ··············173
4.3 函数和公式的高级运用 ·········· 174
4.3.1 使用公式 ·····························174
4.3.2 公式中的运算符及其优先级 ·····175
4.3.3 单元格的引用方式 ·················177
4.3.4 使用函数 ·····························179
4.3.5 复制函数或公式 ····················182
4.3.6 审核公式 ·····························183
4.4 数组的使用 ·························· 186
4.4.1 什么是数组 ··························186
4.4.2 数组的类型以及显示方式 ········187
4.4.3 数组的运算 ··························188
4.5 高级数据分析······················· 191
目录 CONTENTS
· iii·
4.5.1 数值格式设置 ·······················191
4.5.2 单变量求解 ···························192
4.5.3 单变量分析 ···························193
4.5.4 双变量分析 ···························195
4.5.5 数据的模拟分析 ·····················196
4.5.6 数据预测 ······························201
4.5.7 控件的简单应用 ·····················208
4.5.8 宏功能的简单应用 ··················224
4.5.9 导入外部数据 ························226
4.5.10 使用 PowerPivot 管理数据
模型的基本操作 ···················231
练一练 ·········································238
模块 5 演示文稿的制作与
美化
5.1 演示文稿的基本操作·············· 240
5.1.1 设置幻灯片的版式 ·················240
5.1.2 文本操作 ·····························241
5.2 演示文稿的页面设置·············· 246
5.2.1 页面设置 ·····························246
5.2.2 设置幻灯片的背景 ·················250
5.2.3 视图的应用 ··························254
5.2.4 使用母版 ·····························255
5.3 演示文稿的插入元素·············· 259
5.3.1 插入与设置表格或图表 ···········260
5.3.2 插入与设置图片 ····················267
5.3.3 插入与设置 SmartArt 图形 ········269
5.3.4 插入与设置动作按钮 ··············274
5.3.5 插入与设置超链接 ·················276
5.3.6 插入与设置音频或视频 ···········277
5.4 动画及放映设置···················· 283
5.4.1 动画效果 ·····························283
5.4.2 切换效果 ·····························287
5.4.3 放映幻灯片 ··························288
5.5 保护与导出演示文稿·············· 290
5.5.1 保护演示文稿 ·······················290
5.5.2 导出演示文稿 ·······················291
练一练 ·········································296
模块 6 办公软件的联合
应用
6.1 软件间的信息共享················· 300
6.1.1 Word 与 PowerPoint 之间的
协作 ··································300
6.1.2 Excel 与 PowerPoint 之间的
协作 ··································306
6.1.3 Word 与 Excel 之间的协作 ········310
6.2 应用外部文件和数据·············· 312
6.2.1 在 Word 中插入声音和
视频文件 ····························312
6.2.2 在 Excel 中插入声音
和视频文件 ··························313
6.2.3 在 PowerPoint 中插入声音
和视频文件 ·························313
6.3 在各种办公软件中转换文件格式
········································· 315
6.3.1 在 Word 中转换文件格式 ·········315
6.3.2 在 Excel 中转换文件格式 ·········315