电子工业出版社-网上书店

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

第一篇 长文档管理 
项目 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

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

本书配套资源下载

对不起，暂无音视频资源！

WPS办公应用（中级）（第2版）