正版 WPS Office 高级应用与设计(配套视频课程) 唐永华 电子工业

第一篇 初识WPS Office 章 体验全新的WPS Office ······································································.2 1.1 WPS Office 一站式办公――WPS 首页 ····················································.2 1.2 在WPS 中新建、访问和管理文档 ·························································.7 1.2.1 新建文档 ················································································.7 1.2.2 访问文档 ················································································.8 1.2.3 管理文档 ··············································································.14 1.3 WPS 的文档标签和工作窗口 ······························································.16 1.3.1 文档标签 ··············································································.16 1.3.2 标签和独立窗口的切换 ····························································.19 1.3.3 利用窗口管理标签 ··································································.19 1.4 WPS 云办公云服务 ··········································································.21 1.4.1 WPS 云空间 ··········································································.22 1.4.2 云同步 ·················································································.23 1.4.3 WPS 网盘 ·············································································.26 1.4.4 历史版本管理与恢复 ·······························································.27 1.4.5 云回收站 ··············································································.28 1.5 云共享与协作 ·················································································.29 1.5.1 与他人分享文档 ·····································································.29 1.5.2 利用团队管理与组织文档 ·························································.30 1.5.3 多人同时编辑 ········································································.32 第二篇 利用WPS 创建电子文档 第2 章 创建与编辑文档 ···············································································.38 2.1 创建文档 ·······················································································.38 2.1.1 创建空白文档 ········································································.38 2.1.2 利用模板创建文档 ··································································.39 2.2 输入与编辑文本 ··············································································.41 2.2.1 输入文本 ··············································································.41 2.2.2 输入特殊符号 ········································································.42 2.2.3 输入公式 ··············································································.44 2.2.4 输入日期和时间 ·····································································.45 2.2.5 文本的简单编辑 ·····································································.46 2.3 查找和替换文本 ··············································································.48 2.3.1 查找文本 ··············································································.48 2.3.2 替换文本 ··············································································.49 2.3.3 定位文本 ··············································································.52 2.4 保存与打印文档 ··············································································.52 2.4.1 保存文档 ··············································································.52 2.4.2 打印文档 ··············································································.54 2.5 实用操作技巧 ·················································································.56 2.5.1 更改换行符删除空行 ·······························································.56 2.5.2 删除空白页 ···········································································.57 2.5.3 删除空格 ··············································································.57 2.5.4 小写数字转换为大写数字 ·························································.58 2.5.5 高频词的输入 ········································································.58 第3 章 WPS 文档排版 ················································································.60 3.1 设置WPS 文档的格式 ······································································.60 3.1.1 设置字符格式 ········································································.60 3.1.2 设置段落格式 ········································································.63 3.1.3 设置边框和底纹 ·····································································.65 3.1.4 设置项目符号和编号 ·······························································.67 3.1.5 设置文档分页、分节与分栏 ······················································.70 3.1.6 设置页眉、页脚与页码 ····························································.72 3.1.7 调整页面布局 ········································································.76 3.1.8 设置页面背景与页面水印 ·························································.77 3.1.9 实例练习 ··············································································.80 3.2 WPS 文档的图文混排 ·······································································.87 3.2.1 插入图片 ··············································································.88 3.2.2 插入形状 ··············································································.95 3.2.3 插入智能图形 ········································································.98 3.2.4 插入艺术字 ···········································································.99 3.2.5 插入文本框 ··········································································.100 3.2.6 实例练习 ·············································································.101 3.3 在文档中编辑表格 ··········································································.107 3.3.1 创建表格 ·············································································.107 3.3.2 编辑表格 ·············································································.110 3.3.3 表格格式化 ··········································································.114 3.3.4 表格与文本的相互转换 ···························································.115 3.3.5 表格数据转化成图表 ······························································.117 3.3.6 实例练习 ·············································································.119 第4 章 长文档的编辑 ················································································.123 4.1 样式的创建和使用 ··········································································.123 4.1.1 在文档中应用样式 ·································································.123 4.1.2 创建新样式 ··········································································.124 4.1.3 修改样式 ·············································································.125 4.2 在文档中添加引用的内容 ·································································.125 4.2.1 插入脚注和尾注 ····································································.125 4.2.2 插入题注 ·············································································.126 4.2.3 插入交叉引用 ·······································································.127 4.3 创建文档目录 ················································································.128 4.3.1 利用内置目录样式创建目录 ·····················································.128 4.3.2 更新目录 ·············································································.129 4.3.3 自定义目录样式创建目录 ························································.129 4.4 文档的审阅和管理 ··········································································.132 4.4.1 拼写检查 ·············································································.133 4.4.2 使用批注 ·············································································.134 4.4.3 修订内容 ·············································································.135 4.4.4 文档安全 ·············································································.138 4.5 实例练习 ······················································································.139 第5 章 通过邮件合并批量处理文档 ······························································.153 5.1 邮件合并的基础 ·············································································.153 5.2 邮件合并应用实例 ··········································································.153 第三篇 通过WPS 创建并处理电子表格 第6 章 WPS 创建表格基础 ········································································.160 6.1 工作簿和工作表 ·············································································.160 6.1.1 WPS 表格的术语 ···································································.160 6.1.2 工作簿的基本操作 ·································································.161 6.1.3 工作表的基本操作 ·································································.164 6.1.4 实用操作技巧 ·······································································.167 6.2 输入和编辑数据 ·············································································.169 6.2.1 直接输入数据 ·······································································.169 6.2.2 填充有规律的数据 ·································································.170 6.2.3 设置输入数据的有效性 ···························································.172 6.2.4 实用操作技巧 ·······································································.173 6.3 表格的编辑和格式化 ·······································································.174 6.3.1 行列操作 ·············································································.174 6.3.2 设置单元格格式 ····································································.176 6.3.3 套用单元格样式 ····································································.179 6.3.4 套用表格样式 ·······································································.180 6.3.5 应用条件格式 ·······································································.182 6.4 工作表的打印输出 ··········································································.186 6.4.1 页面设置 ·············································································.186 6.4.2 设置打印区域 ·······································································.188 6.4.3 打印预览与打印 ····································································.189 6.5 实例练习 ······················································································.190 第7 章 使用公式与函数计算数据 ·································································.193 7.1 公式的使用 ···················································································.193 7.1.1 公式的组成 ··········································································.193 7.1.2 公式中的运算符 ····································································.193 7.1.3 公式的输入与编辑 ·································································.194 7.1.4 实例练习 ·············································································.195 7.1.5 实用操作技巧 ·······································································.196 7.2 单元格引用 ···················································································.198 7.2.1 相对引用 ·············································································.198 7.2.2 保证引用 ·············································································.198 7.2.3 混合引用 ·············································································.199 7.2.4 引用其他工作表数据 ······························································.199 7.3 在公式中使用定义名称 ····································································.200 7.3.1 定义名称 ·············································································.200 7.3.2 将定义的名称用于公式 ···························································.202 7.4 公式审核 ······················································································.203 7.4.1 显示公式 ·············································································.203 7.4.2 更正公式中的错误 ·································································.204 7.5 函数的使用 ···················································································.204 7.5.1 函数的结构 ··········································································.204 7.5.2 插入函数 ·············································································.204 7.5.3 常用函数的应用 ····································································.206 7.6 实例练习 ······················································································.214 第8 章 图表在数据分析中的应用 ·································································.216 8.1 创建标准图表 ················································································.216 8.1.1 图表类型 ·············································································.216 8.1.2 创建图表 ·············································································.217 8.1.3 编辑图表 ·············································································.218 8.1.4 格式化图表 ··········································································.225 8.2 创建组合图表 ················································································.228 8.3 实例练习 ······················································································.228 第9 章 数据处理与分析 ·············································································.234 9.1 导入外部数据 ················································································.234 9.1.1 导入文本文件 ·······································································.234 9.1.2 分列显示 ·············································································.236 9.1.3 合并计算 ·············································································.238 9.2 数据排序 ······················································································.239 9.2.1 单个字段排序 ·······································································.239 9.2.2 多个字段排序 ·······································································.239 9.2.3 格式排序 ·············································································.241 9.2.4 自定义排序 ··········································································.243 9.3 数据筛选 ······················································································.245 9.3.1 自动筛选 ·············································································.245 9.3.2 自定义筛选 ··········································································.249 9.3.3 不错筛选 ·············································································.250 9.4 数据分类汇总 ················································································.253 9.4.1 插入分类汇总 ·······································································.253 9.4.2 创建分级显示 ·······································································.256 9.4.3 插入嵌套分类汇总 ·································································.260 9.5 数据透视表和数据透视图 ·································································.263 9.5.1 创建数据透视表 ····································································.263 9.5.2 筛选数据透视表 ····································································.268 9.5.3 使用切片器筛选数据 ······························································.270 9.5.4 显示报表筛选项 ····································································.271 9.5.5 显示明细数据 ·······································································.273 9.5.6 设置字段名称及值 ·································································.274 9.5.7 设置透视表样式 ····································································.276 9.5.8 创建数据透视图 ····································································.277 9.5.9 删除数据透视表或数据透视图 ··················································.278 第四篇 使用WPS 制作演示文稿 第10 章 创建演示文稿 ··············································································.280 10.1 创建演示文稿的途径 ······································································.280 10.1.1 创建空白演示文稿 ·······························································.280 10.1.2 WPS 演示工作窗口 ······························································.281 10.1.3 利用模板创建演示文稿 ·························································.282 10.2 幻灯片的基本操作 ·········································································.283 10.2.1 设置幻灯片的大小和方向 ······················································.283 10.2.2 插入和删除幻灯片 ·······························································.284 10.2.3 复制或移动幻灯片 ·······························································.285 10.2.4 添加幻灯片编号 ··································································.285 10.2.5 添加幻灯片日期和时间 ·························································.286 10.2.6 幻灯片的分节 ·····································································.286 10.2.7 幻灯片的隐藏和显示 ····························································.288 10.3 演示文稿的视图 ············································································.289 第11 章 演示文稿的设计和制作 ··································································.291 11.1 幻灯片母版和版式的应用 ································································.291 11.1.1 创建幻灯片母版 ··································································.291 11.1.2 幻灯片版式的应用 ·······························································.293 11.1.3 套用幻灯片母版/版式 ···························································.294 11.2 应用幻灯片配色方案与背景 ·····························································.296 11.2.1 应用幻灯片配色方案 ····························································.296 11.2.2 应用幻灯片背景 ··································································.297 11.3 演示文稿内容的编辑 ······································································.300 11.3.1 添加文本 ···········································································.300 11.3.2 插入图片和形状 ··································································.305 11.3.3 插入智能图形 ·····································································.311 11.3.4 插入表格 ···········································································.315 11.3.5 插入音频 ···········································································.315 11.3.6 插入视频 ···········································································.317 11.4 演示文稿的动画效果设置 ································································.320 11.4.1 设置幻灯片内容的动画效果 ···················································.320 11.4.2 设置幻灯片切换的动画效果 ···················································.327 11.4.3 超链接 ··············································································.328 第12 章 演示文稿的放映与共享 ··································································.331 12.1 演示文稿的放映 ············································································.331 12.1.1 幻灯片放映控制 ··································································.332 12.1.2 应用排练计时 ·····································································.333 12.1.3 自定义放映 ········································································.334 12.1.4 手机遥控放映 ·····································································.335 12.1.5 放映时使用墨迹标记幻灯片 ···················································.336 12.2 演示文稿的共享 ············································································.337 12.2.1 输出为PDF ········································································.337 12.2.2 输出为视频 ········································································.338 12.2.3 文件打包 ···········································································.339 12.3 打印演示文稿及讲义 ······································································.340 第13 章 实例―制作答辩演示文稿 ·······························································.341 13.1 利用母版统一答辩演示文稿外观 ······················································.341 13.1.1 统一答辩演示文稿的外观 ······················································.341 13.1.2 统一答辩演示文稿的字体 ······················································.342 13.1.3 添加幻灯片编号 ··································································.343 13.2 输入答辩演示文稿的内容 ································································.344 13.2.1 输入标题和目录 ··································································.344 13.2.2 插入图片 ···········································································.348 13.2.3 插入形状 ···········································································.348 13.2.4 插入智能图形 ·····································································.351 13.3 为答辩演示文稿添加动画效果··························································.352 13.3.1 为形状和文本框添加进入效果 ················································.352 13.3.2 为文本添加退出效果 ····························································.354 13.4 为答辩演示文稿添加切换效果··························································.355 13.5 为答辩演示文稿添加交互设置··························································.356 13.5.1 为目录设置超链接 ·······························································.356 13.5.2 添加返回目录动作按钮 ·························································.356 附录A 全国计算机等级考试二级WPS Office 试题及答案 ·································.358

本书以WPS Office 2019 为基础，主要分为四篇，内容包括初识WPS Office、利用WPS 创建电子文档、通过WPS 创建并处理电子表格、使用WPS制作演示文稿，涵盖了《全国计算机等级考试二级WPS Office不错应用与设计考试大纲（2021 年版）》中要求的核心内容。本书注重WPS Office 基础知识的系统性，更强调实用性和应用性，既有丰富的理论知识，又有大量难易适中、涉及广泛、贴近实际生活和工作的实例，突出“应用”、强化“技能”。本书提供的教学微课视频，覆盖课程的全部内容，方便读者反复观看和学习课程相关内容。本书可以作为高等院校WPS Office 不错应用课程的教材，也可以作为全国计算机等级考试一、二级WPS Office 不错应用与设计的复习用书，还可以作为各类计算机培训机构的培训用书和计算机爱好者的自学用书。