本书是一本指导初学者学习Excel2016/PowerPoint2016的入门书籍。书中详细地介绍了初学者学习Excel2016/PowerPoint2016必须掌握的基础知识、使用方法和操作技巧，并对初学者在使用Excel2016/PowerPoint2016时经常遇到的问题进行了专业的指导，以免初学者在起步的过程中走弯路。全书共17章，前10章为Excel部分，后7章为PowerPoint部分。第1章为对Excel2016/PowerPoint2016的认识，然后是表格的基本操作，表格中数据的输入与美化，筛选数据，公式与函数的应用，运用图表、数据透视图或数据透视表分析数据，高效办公技巧等，第10章为Excel的综合实例，帮助读者巩固Excel部分的知识。在PowerPoint部分介绍了基础操作，美化演示文稿，运用幻灯片母版设计风格统一的演示文稿，向幻灯片对象添加多媒体对象与超链接，添加动画效果增强演示文稿感染力，以及幻灯片的放映、输出与打印，最后一章也是综合实例，学习巩固PowerPoint所学的知识。
本书适合Excel2016/PowerPoint2016初级者阅读，同时对作为有经验的使用者也有很高的参考价值。
Excel/PPT 2016办公专家从入门到精通
李明富 编著
图解操作+同步练习+办公技巧+多媒体教学Office办公专家的精心解惑！
本书精华
轻松学习 本书配备了412个实例文件及69段共计144分钟的多媒体教学视频，便于读者通过实际动手操作增强学习效果。
超值附赠 赠送3000个办公常用Office模板、五笔电子速查字典（内含10000个五笔编码）、价值29元的绿色免安装超小体积五笔打字练习软件。
延伸阅读 赠送价值39元的《电脑日常维护与故障排除》电子书，220分钟的Excel数据处理与分析和293分钟的Excel行政与文秘应用教学视频。
高手解惑 全书191个重点知识、82个知识补充和15个实例演练均来自数位Office达人多年的实操经验和心得体会，如同办公专家在您身边。
云下载说明
步骤01 扫描关注微信公众号。打开手机微信，点击“发现”，再点击“扫一扫”，进入“二维码/ 条码”页面，将手机对准封面上的二维码扫描，识别后进入“详细资料”页面，点击“关注”。
步骤02 获取资料下载地址和密码。在公众号主页面中点击左下角的键盘切换按钮。在输入框中输入“578048”，点击“发送”按钮，即可获取云空间资料的下载地址和访问密码。
步骤03 打开资料下载页面。在计算机上打开网页浏览器，在浏览器地址栏中输入并打开上一步获取的下载地址，在资料下载页面中输入上一步获取的访问密码，单击“提取文件”按钮。
步骤04 下载文件。在要下载的文件名后单击“下载”按钮，即可将其下载到计算机中。不要选择下载文件夹。若页面中提示选择“高速下载”还是“普通下载”，请选择“普通下载”。
步骤05 解压文件。下载并保存文件后，如果下载的文件为压缩包，则需使用7-Zip、WinRAR等解压软件解压。
投稿热线：(010) 88379604
客服热线：(010) 88379426 88361066
购书热线：(010) 68326294 88379649 68995259
华章网站：www.hzbook.com
网上购书：www.china-pub.com
数字阅读：www.hzmedia.com.cn
随着办公自动化和信息化程度的提高，熟练使用微软Office已成为职场人士必备的技能。本书以Office初级和中级用户的学习需求为立足点，以Office 2016为软件平台，通过大量详尽的操作讲解，帮助读者直观地掌握Excel和PowerPoint两大核心组件，并能在实际工作中娴熟应用，快速制作出专业、美观的报表、图表和幻灯片。
◎内容结构
全书共17章，可分为3个部分。
第1章为基础部分，主要介绍Excel 2016和PowerPoint 2016的用户界面及个性化设置。
第2～10章为Excel部分，讲解了Excel 2016的基本操作，数据的输入与美化，数据的筛选、排序与汇总，公式、函数、图表与数据透视表（图）的使用，数据分析工具与高级功能；随后对Excel的常用办公技巧进行总结，并通过一个综合实例来巩固和提高所学。
第11～17章为PowerPoint部分，讲解了PowerPoint 2016的基本操作，演示文稿的美化与外观的快速统一，多媒体对象、超链接、动画效果与切换效果的添加与设置，演示文稿的放映、输出与打印；最后同样通过一个综合实例来巩固和提高所学。
◎编写特色
★内容全面，紧贴实际：本书精选两大组件在实际工作中最常用的功能，通过从实际办公场景中提炼出的大量典型实例进行讲解，并用详尽、通俗的文字配以屏幕截图，直观、清晰地展示操作效果，易于理解和掌握。
★边学边练，自学无忧：办公软件的学习重在实践。本书的云空间资料完整收录了书中全部实例的相关素材文件和配套操作视频，读者按照书中的讲解，结合观看视频和动手操作，学习效果立竿见影。
◎读者对象
本书面向Office初级和中级用户，不仅适合初涉职场的新人从零开始自学Office操作，而且适合有一定基础的商务办公人士掌握更多实用技能，还可作为大中专院校、社会培训机构或企业入职培训的教材。
由于编者水平有限，在编写本书的过程中难免有不足之处，恳请广大读者指正批评，除了扫描二维码添加订阅号获取资讯以外，也可加入QQ群227463225与我们交流。
编者
2017年7月
计算机/办公
本书以Office 2016 为软件平台，以实现高效办公为出发点，通过从实际工作场景中提炼出的大量典型实例，系统而全面地讲解了Excel 和PowerPoint 两大组件在办公中的应用，帮助读者快速晋级办公达人。
本书结构编排合理、图文并茂、实例丰富，不仅适合初入职场的新人从零开始自学Office 操作，而且适合有一定基础的商务办公人士掌握更多实用技能，还可作为大中专院校、社会培训机构或企业入职培训的教材。
前言
如何获取云空间资料
第1章 快速了解Excel/PPT
1.1 Excel/PPT的启动与退出 ···············9
1.2 认识Excel/PPT的用户界面 ············11
1.3 让Excel/PPT视图更合理 ···············13
1.3.1 改变窗口的显示比例 ·················· 13
1.3.2 新建窗口 ································· 15
1.3.3 拆分窗口 ································· 16
1.4 个性化设置·································16
1.4.1 更改账户主题 ··························· 17
1.4.2 自定义功能区选项卡 ·················· 17
1.4.3 设置自动保存时间间隔 ··············· 19
1.4.4 设置默认工作表数目 ·················· 19
实例演练： 设置符合工作需要的 Excel工作环境·················19
第2章 Excel 2016基本操作
2.1 认识工作簿、工作表和单元格 ········22
2.2 工作簿的基本操作 ·······················23
2.2.1 工作簿的新建与打开 ·················· 23
2.2.2 工作簿的保存与另存 ·················· 25
2.3 工作表的基本操作 ·······················27
2.3.1 选择工作表 ······························ 27
2.3.2 重命名工作表 ··························· 28
2.3.3 移动与复制工作表 ····················· 28
2.3.4 插入与删除工作表 ····················· 30
2.3.5 给工作表标签添加颜色 ··············· 31
2.4 单元格的基本操作 ·······················32
2.4.1 选择与命名单元格 ····················· 32
2.4.2 移动与复制单元格 ····················· 34
2.4.3 插入与删除单元格 ····················· 35
2.4.4 合并单元格与取消合并 ··············· 37
实例演练：制作缺勤记录表 ···················38
第3章 数据的输入与美化
3.1 基础数据的输入 ··························40
3.1.1 输入文本型数据 ························ 40
3.1.2 输入时间和日期 ························ 41
3.1.3 使用自动填充功能 ····················· 42
3.2 单元格数据的格式化 ····················45
3.2.1 设置数字格式 ··························· 45
3.2.2 设置文字格式 ··························· 46
3.2.3 设置文字对齐方式 ····················· 48
3.2.4 调整行高和列宽 ························ 49
3.3 工作表的美化 ·····························50
3.3.1 设置表格边框 ··························· 50
3.3.2 设置底纹图案 ··························· 52
3.3.3 套用预设格式 ··························· 53
实例演练：制作公司考勤表 ···················54
第4章 数据的筛选、排序及分类汇总
4.1 记录单的应用······························ 56
4.1.1 添加记录 ································· 56
4.1.2 查找记录 ································· 57
4.1.3 删除记录 ································· 58
4.2 数据的排序································· 60
4.2.1 单一条件排序 ··························· 60
4.2.2 多条件排序 ······························ 61
4.2.3 按笔画排序 ······························ 62
4.2.4 自定义排序 ······························ 63
4.3 数据的筛选································· 64
4.3.1 简单筛选 ································· 64
4.3.2 搜索筛选 ································· 65
4.3.3 颜色筛选 ································· 66
4.3.4 复杂筛选 ································· 66
4.3.5 高级筛选 ································· 67
4.4 数据的分类汇总··························· 70
4.4.1 创建单项汇总表 ························ 70
4.4.2 创建多项汇总表 ························ 72
4.4.3 创建嵌套分类汇总 ····················· 73
4.4.4 删除分类汇总 ··························· 74
4.4.5 分组显示汇总 ··························· 74
实例演练：员工绩效排名与等级 ·············76
第5章 公式和函数的应用
5.1 公式的基础应用 ··························79
5.1.1 输入公式 ································· 79
5.1.2 编辑公式 ································· 80
5.1.3 复制公式 ································· 81
5.2 相对引用和绝对引用 ····················83
5.3 函数的应用·································84
5.3.1 逻辑函数的应用 ························ 84
5.3.2 统计函数的应用 ························ 86
5.3.3 财务函数的应用 ························ 90
实例演练：快速计算药品金额 ················95
第6章 图表的使用
6.1 认识图表的类型与作用 ·················96
6.1.1 图表的组成 ······························ 96
6.1.2 图表的类型与作用 ····················· 96
6.2 创建与更改图表 ··························98
6.2.1 创建图表 ································· 98
6.2.2 更改图表类型 ··························· 100
6.2.3 更改图表数据源 ························ 101
6.2.4 移动图例位置 ··························· 102
6.2.5 更改图表布局 ··························· 103
6.3 图表元素的添加与格式化 ··············104
6.3.1 添加图表标题 ··························· 104
6.3.2 添加坐标轴标题 ························ 105
6.3.3 数据标签 ································· 108
6.3.4 数据表 ···································· 110
6.4 美化图表····································111
6.4.1 套用图表样式 ··························· 111
6.4.2 更改图表配色 ··························· 111
6.4.3 自定义图表样式 ························ 112
实例演练：创建气温走势图 ···················115
第7章 数据透视表与透视图的使用
7.1 创建数据透视表 ··························119
7.2 设置数据透视表布局与数据格式 ·····122
7.2.1 调整数据透视表字段布局 ············ 122
7.2.2 更改数据透视表的计算方式与数字格式 ··················· 123
7.3 插入切片器筛选数据 ····················125
7.4 根据数据透视表创建数据透视图 ·····126
实例演练： 创建数据透视表分析采购清单······················127
第8章 Excel数据分析 和高级功能
8.1 数据审核································132
8.1.1 数据有效性验证 ························ 132
8.1.2 圈释无效数据 ··························· 137
8.2 模拟运算表与单变量求解 ··············137
8.2.1 单变量模拟运算表 ····················· 137
8.2.2 双变量模拟运算表 ····················· 139
8.2.3 单变量求解 ······························ 140
8.3 方案分析····································141
8.3.1 方案的创建 ······························ 141
8.3.2 方案的显示 ······························ 143
8.3.3 方案的管理 ······························ 144
实例演练：制定合理的销售方案 ·············145
第9章 Excel常用办公技巧
9.1 数据的查找与替换 ·······················149
9.1.1 数据的查找 ······························ 149
9.1.2 数据的替换 ······························ 151
9.2 多人协同工作 ·····························153
9.2.1 共享工作簿 ······························ 153
9.2.2 设置有效编辑区 ························ 154
9.2.3 添加批注 ································· 156
9.2.4 显示与隐藏批注 ························ 157
9.3 高效查看工作表中的数据 ··············158
9.3.1 隐藏和显示工作表中的行/列 ········ 158
9.3.2 窗口的冻结 ······························ 159
9.4 Excel中数据的保护技巧 ················160
9.4.1 隐藏工作表 ······························ 160
9.4.2 加密工作表 ······························ 161
9.5 工作表的打印设置 ·······················162
9.5.1 工作表的打印设置 ····················· 163
9.5.2 打印工作表 ······························ 164
实例演练：设置并共享销售明细表 ··········165
第10章 制作企业日常费用表
10.1 创建与管理日常费用表 ················168
10.1.1 数据的输入与编辑 ···················· 168
10.1.2 工作表的格式设置 ···················· 171
10.1.3 突出重要的数据 ······················· 172
10.2 计算与分析表格中的数据 ·············173
10.2.1 计算日常费用表中的数据··········· 173
10.2.2 显示需要的数据 ······················· 174
10.2.3 统计同一类别的费用 ················· 176
10.3 图形化日常费用表 ······················178
10.3.1 图表的创建与编辑 ···················· 178
10.3.2 美化图表 ································ 180
10.4 数据的安全管理 ·························182
10.4.1 检查工作簿问题 ······················· 182
10.4.2 保护工作簿 ····························· 183
第11章 PowerPoint 2016 基本操作
11.1 创建演示文稿 ····························185
11.1.1 使用快捷菜单创建空白演示文稿···185
11.1.2 基于模板创建演示文稿 ·············· 186
11.2 保存演示文稿 ····························187
11.2.1 将演示文稿保存在原来位置 ········ 187
11.2.2 将演示文稿保存在其他位置 ········ 188
11.3 编辑幻灯片中的文本 ···················188
11.3.1 利用占位符输入文本 ················· 188
11.3.2 在文本框内输入文本 ················· 190
11.3.3 使用自选图形输入文本 ·············· 191
11.3.4 选择与删除文本 ······················· 193
11.3.5 移动与复制文本 ······················· 194
11.3.6 查找与替换文本 ······················· 197
11.4 设置文本格式 ····························198
11.4.1 在功能区设置文本格式 ·············· 198
11.4.2 通过对话框设置文本格式 ··········· 200
11.4.3 使用浮动工具栏设置文本格式 ····· 201
11.5 设置段落格式 ····························202
11.5.1 设置文本对齐方式 ···················· 202
11.5.2 设置文本段落缩进 ···················· 203
11.5.3 设置行间距和段间距 ················· 204
11.5.4 设置项目符号与编号 ················· 205
11.6 幻灯片的操作 ····························208
11.6.1 添加和删除幻灯片 ···················· 208
11.6.2 复制与粘贴幻灯片 ···················· 209
11.7 调整幻灯片顺序 ·························210
实例演练：制作年终工作总结演示文稿 ····210
第12章 用图片和图形美化演示文稿
12.1 插入图片······························ 215
12.1.1 插入计算机中的图片 ················· 215
12.1.2 插入联机图片 ·························· 216
12.1.3 插入屏幕截图 ·························· 216
12.2 设置图片格式 ····························217
12.2.1 按比例裁剪图片 ······················· 217
12.2.2 更正图片亮度与对比度·············· 218
12.2.3 校正图片的颜色 ······················· 220
12.2.4 设置图片大小和位置 ················· 223
12.2.5 更改图片样式 ·························· 225
12.3 使用SmartArt图形制作图示 ··········226
12.3.1 插入SmartArt图形 ···················· 226
12.3.2 为SmartArt图形添加形状和文本···227
12.3.3 更改SmartArt图形布局并美化 ···· 229
12.3.4 将SmartArt图形转换为文本或形状 ·················· 230
12.4 插入自选图形并美化 ···················231
12.4.1 插入自选图形 ·························· 231
12.4.2 在图形中添加文字 ···················· 232
12.4.3 更改图形形状 ·························· 233
12.4.4 为图形添加阴影效果 ················· 234
12.4.5 为图形添加三维效果 ················· 235
实例演练：美化公司简介演示文稿 ··········235
第13章 快速统一演示文稿的外观
13.1 设置演示文稿的主题 ···················239
13.1.1 为演示文稿设置默认主题··········· 239
13.1.2 自定义演示文稿的主题·············· 240
13.2 母版和版式的基本操作 ················241
13.2.1 认识母版和版式 ······················· 241
13.2.2 添加母版或版式 ······················· 242
13.2.3 复制母版或版式 ······················· 244
13.2.4 重命名母版或版式 ···················· 245
13.2.5 删除母版或版式 ······················· 246
13.3 设置母版和版式的布局结构 ··········247
13.3.1 设置母版的格式 ······················· 247
13.3.2 设置版式的布局 ······················· 249
13.3.3 设置版式的主题效果 ················· 251
13.3.4 设置版式的背景 ······················· 251
13.4 更改幻灯片背景 ·························252
13.4.1 应用幻灯片背景样式 ················· 252
13.4.2 自定义幻灯片背景样式·············· 253
实例演练：快速创建公司简介演示文稿 ····254
第14章 添加多媒体对象与超链接
14.1 插入音频文件 ····························259
14.1.1 插入PC上的音频文件 ··············· 259
14.1.2 插入录制的音频 ······················· 260
14.1.3 控制音频文件的播放 ················· 261
14.2 插入视频文件 ····························262
14.2.1 在幻灯片中插入视频文件··········· 262
14.2.2 调整视频文件画面效果·············· 263
14.2.3 控制视频文件的播放 ················· 268
14.3 添加超链接······························· 271
14.3.1 创建超链接 ····························· 271
14.3.2 更改或删除超链接 ···················· 272
14.3.3 应用动作创建超链接 ················· 273
实例演练：制作景点介绍演示文稿 ··········275
第15章 让幻灯片动起来
15.1 为幻灯片中的对象添加动画效果 ····280
15.1.1 为对象添加预设动画 ················· 280
15.1.2 为对象添加自定义动画·············· 281
15.2 设置动画的播放 ·························286
15.2.1 设置动画的开始方式 ················· 286
15.2.2 设置动画的持续时间 ················· 287
15.2.3 设置动画的延迟时间 ················· 288
15.2.4 设置动画的播放顺序 ················· 289
15.3 为幻灯片添加预设切换效果 ··········291
15.3.1 使用三维图形效果进行切换········ 291
15.3.2 设置幻灯片的切换方向·············· 292
15.3.3 设置幻灯片的切换声音·············· 293
15.3.4 设置幻灯片的换片方式·············· 293
实例演练：旅游方案之景点介绍 ·············294
第16章 演示文稿的放映、输出及打印
16.1 幻灯片的放映设置 ······················299
16.1.1 启动幻灯片放映 ······················· 299
16.1.2 设置放映方式 ·························· 300
16.1.3 自定义放映 ····························· 302
16.2 将演示文稿输出为指定类型的文件···················· 303
16.2.1 将演示文稿创建为 PDF/XPS文档 ··················· 303
16.2.2 将演示文稿创建为视频·············· 305
16.2.3 将演示文稿打包成CD ··············· 307
16.2.4 将演示文稿保存为图片·············· 309
16.3 演示文稿的加密保护 ···················310
16.4 演示文稿的打印设置 ···················312
实例演练：打包并加密演示文稿 ·············317
第17章 制作招商方案演示文稿
17.1 创建风格统一的演示文稿 ·············320
17.2 编辑幻灯片内容························· 321
17.2.1 在幻灯片中输入与编辑文本········ 321
17.2.2 在幻灯片中插入与编辑图形········ 323
17.2.3 在幻灯片中插入与编辑SmartArt图形 ·················· 326
17.3 让幻灯片内容动起来 ···················329
17.3.1 设置幻灯片对象的动画效果········ 329
17.3.2 多媒体对象的添加与调整··········· 335
17.4 放映并共享幻灯片 ······················340
17.4.1 自定义幻灯片放映 ···················· 340
17.4.2 保护演示文稿 ·························· 341
17.4.3 发布幻灯片 ····························· 342
