本书是《WPS 办公应用职业技能等级标准》（中级）与全国计算机等级考试（二级）的配套教材，包括长文档管理、演示文稿制作和表格数据运算3大模块9个项目，深入浅出地介绍了长文档编辑、排版美化、演示文稿编辑、演示文稿合成、动画制作、数据管理、公式函数、排序、筛选、分类汇总、合并、透视表等知识点与技能点，同时每个模块均介绍了WPS AI的相关功能，跟踪人工智能大模型技术的应用发展趋势，使学生掌握如何应用AI辅助办公、提高效率。 本书适用应用型本科院校、高等职业院校计算机相关专业学生和老师。

田启明，温州职业技术学院人工智能学院院长，党总支副书记，二级教授，入选教育部新时代职业学校名师培养对象、浙江省"万人计划”教学名师，主持建设国家双高专业群核心专业、国家骨干专业、国家教师教学创新团队、国家精品课程；主持建设浙江省第二批双高专业群、浙江省优势专业、浙江省示范实训基地、浙江省精品课程1门；主编11种教材（含国家级规划教材2种、工信部规划教材1种、省重点教材3种），副主编8种教材；公开发表论文二十多篇，主持或参与国家、省、市级课题近五十项。曾获1项国家教学成果一等奖、3项省教学成果一等奖、浙江省高校教师教学软件评比一等奖、浙江省高校科研成果三等奖，曾被评为浙江省专业带头人、浙江省首届教坛新秀、温州市"师德楷模”。

第一篇 长文档管理
项目 1 公司招聘启事文档的制作 ·························································.002
学习目标 ····················································································.002
项目效果 ····················································································.002
知识技能 ····················································································.003
1.1 视图的应用 ··········································································.003
1.3 图形的绘制 ··········································································.011
1.4 表格样式的设置 ····································································.015
1.5 表格工具的应用 ····································································.016
主要步骤 ····················································································.017
项目拓展 ····················································································.020
项目小结 ····················································································.021
综合练习 ····················································································.021
项目 2 网店策划论文的排版 ·······························································.024
学习目标 ·····················································································.24
项目效果 ·····················································································.24
知识技能 ·····················································································.25
2.1 项目符号和编号的设置 ····························································.25
2.2 多级编号的应用 ·····································································.27
2.3 分隔符的设置 ········································································.30
2.4 章节工具的应用 ·····································································.31
2.5 多页表格的设置 ·····································································.34
2.6 导航窗格的应用 ·····································································.35
主要步骤 ·····················································································.36
项目拓展 ·····················································································.38
项目小结 ·····················································································.40
综合练习 ·····················································································.40
项目 3 网店策划论文的美化 ·······························································.043
学习目标 ····················································································.043
项目效果 ····················································································.043
知识技能 ····················································································.044
3.1 修改与新建样式 ····································································.044
3.2 页眉、页脚的美化 ·································································.046
3.3 图表编号和目录的设置 ···························································.048
3.4 脚注和尾注的美化 ·································································.049
3.5 超链接与交叉引用的使用 ························································.050
3.6 参考文献与书签的设置 ···························································.052
3.7 AI 文档排版 ·········································································.054
主要步骤 ····················································································.055
项目拓展 ····················································································.057
项目小结 ····················································································.058
综合练习 ····················································································.059
第二篇 演示文稿制作
项目 4 公司简介演示文稿的制作 ·························································.064
学习目标 ····················································································.064
项目效果 ····················································································.064
知识技能 ····················································································.065
4.1 图片的处理 ··········································································.065
4.2 智能图形的应用 ····································································.069
4.3 表格的编辑 ··········································································.070
4.4 公式的编辑 ··········································································.072
4.5 幻灯片对齐工具 ····································································.073
4.6 版式与母版的设置 ·································································.074
主要步骤 ····················································································.076
项目拓展 ····················································································.083
项目小结 ····················································································.085
综合练习 ····················································································.086
项目 5 旅游景点演示文稿的制作 ·························································.088
学习目标 ····················································································.088
项目效果 ····················································································.088
知识技能 ····················································································.090
5.1 音频和视频的插入 ·································································.090
5.2 音频和视频的编辑 ·································································.094
5.3 音频超链接和视频超链接的设置 ···············································.095
5.4 动作链接的设置 ····································································.099
5.5 演示文稿的合并 ····································································.101
5.6 AI 生成演示文稿 ···································································.102
主要步骤 ····················································································.105
项目拓展 ····················································································.111
项目小结 ····················································································.112
综合练习 ····················································································.112
项目 6 毕业纪念册演示文稿制作 ·························································.115
学习目标 ····················································································.115
项目效果 ····················································································.115
知识技能 ····················································································.116
6.1 路径动画的设置与应用 ···························································.116
6.2 文本动画的设置与应用 ···························································.118
6.3 “动画窗格”的应用 ······························································.119
6.4 复杂动画的制作 ····································································.121
6.5 交互式动画的制作 ·································································.122
主要步骤 ····················································································.125
项目拓展 ····················································································.130
项目小结 ····················································································.131
综合练习 ····················································································.132
第三篇 表格数据运算
项目 7 学业成绩统计 ········································································.136
学习目标 ····················································································.136
项目效果 ····················································································.136
知识技能 ····················································································.138
7.1 单元格引用 ··········································································.138
7.2 公式 ···················································································.138
7.3 常用函数 ·············································································.139
7.4 公式套用 ·············································································.141
主要步骤 ····················································································.141
项目拓展 ····················································································.143
项目小结 ····················································································.144
综合练习 ····················································································.144
项目 8 星级寝室评比 ········································································.146
学习目标 ····················································································.146
项目效果 ····················································································.146
知识技能 ····················································································.146
8.1 数据类型 ·············································································.146
8.2 数据转换 ·············································································.147
8.3 填充 ···················································································.149
8.4 条件格式 ·············································································.150
8.5 数据有效性 ··········································································.151
8.6 下拉列表 ·············································································.152
主要步骤 ····················································································.152
项目拓展 ····················································································.155
项目小结 ····················································································.156
综合练习 ····················································································.157
项目 9 公益捐赠物品统计 ··································································.159
学习目标 ····················································································.159
项目效果 ····················································································.159
知识技能 ····················································································.161
9.1 排序 ···················································································.161
9.2 筛选 ···················································································.162
9.3 分类汇总 ·············································································.163
9.4 数据透视表 ··········································································.164
9.5 图表 ···················································································.165
9.6 数据合并 ·············································································.167
9.7 AI 表格················································································.169
主要步骤 ····················································································.170
项目拓展 ····················································································.173
项目小结 ····················································································.174
综合练习 ····················································································.174