WPS Office 2019完全自学教程 word 网盘 高速 下载地址大全 免费

本书以 WPS Office 2019 软件为平台，从办公人员的工作需求出发，结合大量典型案例，全面讲解了 WPS Office 2019 的文字编辑、表格应用、演示文稿等办公组件的功能和操作，以帮助读者轻松高效地完成办公任务。 本书以“完全精通 WPS Office”为出发点，以“用好 WPS Office”为目标来安排内容，全书共分为 6 篇，21 章。第 1 篇为快速入门篇，全面讲解 WPS Office 2019 的基本操作；第 2 篇为 WPS 文字编辑篇；第 3 篇为 WPS 表格应用篇；第4 篇为 WPS 演示文稿篇；第 5 篇为 WPS 其他组件应用篇；第 6 篇为 WPS 案例实战篇。 本书既适合办公室小白、刚毕业或即将毕业的学生学习，还可以作为广大职业院校、计算机培训班的教学参考用书。

第 1 篇 快速入门篇 第1章 初识 WPS Office 2019 办公软件 ······································· 1 1.1 认识 WPS Office 2019 ··········1 1.1.1 认识 WPS 文字························· 1 1.1.2 认识 WPS 表格························· 2 1.1.3 认识 WPS 演示文稿 ·················· 2 1.1.4 认识 PDF ································ 2 1.1.5 认识流程图 ····························· 2 1.1.6 认识脑图································· 2 1.1.7 认识图片设计 ·························· 2 1.1.8 认识表单································· 3 1.2 WPS Office 2019的新增功能 ··········································3 ★新功能 1.2.1 整合桌面图标 ·············· 3 ★新功能 1.2.2 整合任务窗格············· 3 ★新功能 1.2.3 增加全局搜索功能······ 3 ★新功能 1.2.4 统一窗口标签切换 ······ 4 ★新功能 1.2.5 新增流程图与 思维导图 ································ 4 ★新功能 1.2.6 内置 PDF 阅读工具······ 4 ★新功能 1.2.7 内置网页浏览器·········· 5 ★新功能 1.2.8 内置丰富的模板库······ 5 ★新功能 1.2.9 随心选择皮肤功能 ······ 5 ★新功能 1.2.10 加入表单设计功能······ 5 1.3 安装并启动WPS Office 2019·························5 1.3.1 实战：安装 WPS Office 2019······ 6 1.3.2 启动与关闭 WPS Office 2019······· 6 1.3.3 注册并登录 WPS Office 2019 账户······································· 7 1.4 熟悉 WPS Office 2019 ··········8 1.4.1 认识 WPS Office 2019 的工作界面···································· 8 ★重点 1.4.2 新建 WPS Office 2019组件······································· 9 ★重点 1.4.3 保存 WPS Office 2019组件······································· 9 1.4.4 打开 WPS Office 2019 组件·······10 1.5 自定义 WPS 工作界面·········10 1.5.1 实战：在快速访问工具栏中添加或删除按钮······················11 1.5.2 实战：在新建选项卡中创建 常用工具组 ····························11 1.5.3 隐藏或显示功能区···················12 1.5.4 居中显示功能区按钮················12 1.6 文件的备份与安全 ··············13 ★重点 1.6.1 实战：手动备份文档······13 1.6.2 打开与删除备份······················14 1.6.3 将文档保存在云端···················14 1.6.4 为文档设置打开和编辑密码······14 1.7 使用 WPS 转换格式 ············15 ★重点 1.7.1 实战：将文档输出为PDF ······································15 1.7.2 实战：将文档输出为图片·········15 1.7.3 实战：将 PDF 输出为 PPT ········16 妙招技法··································16 技巧 01 清除文档历史记录 ··················17 技巧 02 快速打开多个文档 ··················17 技巧 03 自定义皮肤和外观 ··················17 技巧 04 使用 WPS 账号加密·················18 技巧 05 更改快速访问工具栏的位置······18 第 2 篇 WPS 文字编辑篇 第2章 办公文档的录入与编辑·············20 2.1 WPS 文字的视图设置··········20 2.1.1 认识 WPS 文字的视图··············20 2.1.2 实战：切换合适的视图模式······21 2.2 录入文档内容·····················22 ★重点 2.2.1 实战：录入活动通知文档 ·······························22 2.2.2 实战：在通知文档中插入 特殊符号 ·······························23 2.2.3 实战：在通知文档中快速输入当前日期·························24 2.2.4 实战：在文档中录入数学 公式······································24 2.3 编辑文档内容·····················25 ★重点 2.3.1 选中文档内容···············25 2.3.2 复制、剪切与删除文本············ 26 2.3.3 撤销与恢复文本······················27 ★重点 2.3.4 实战：查找与 替换文本 ·······························27 妙招技法··································29 技巧 01 快速删除多余空行 ··················29 技巧 02 快速将文字转换为繁体············29 技巧 03 快速输入大写中文数字··················29 技巧 04 输入生僻字的技巧 ··················30 技巧 05 将文字替换为图片 ··················30 设置办公文档的格式 ················32 3.1 设计文字的方法 ·················32 3.1.1 标题文字的设计······················32 3.1.2 正文文字的设计······················33 3.2 设置字符格式·····················33 3.2.1 设置字符格式的方法················33 ★重点 3.2.2 实战：设置公告的字体和字号 ····························35 3.2.3 实战：设置公告的文字颜色······35 3.2.4 实战：设置公告的特殊字形······36 3.2.5 实战：设置公告的字符间距······37 3.3 设置段落格式·····················37 ★重点 3.3.1 设置公告的段落缩进······38 3.3.2 实战：设置公告的对齐方式······38 3.3.3 实战：设置公告的段间距和行间距···································39 3.3.4 实战：使用【文字工具】快速排版混乱文档·························40 3.3.5 设置特殊的中文版式················40 3.4 设置项目符号和编号···········41 ★重点 3.4.1 实战：为制度文件 添加项目符号 ························ 41 3.4.2 实战：为制度文件添加编号······42 妙招技法··································42 技巧 01 为多音字添加拼音 ··················43 技巧 02 在重要文字下方添加着重号······43 技巧 03 设置自动编号的起始值为“3”······43 技巧 04 使用特殊符号作为项目符号······44 技巧 05 快速将英文单词的首字母更改为大写 ····························45 创建与编辑表格·······················46 4.1 了解表格的使用技巧···········46 4.1.1 熟悉表格的构成元素················46 4.1.2 创建表格的思路与技巧·············47 4.1.3 表格设计与优化技巧················47 4.2 创建表格的方法 ·················49 ★重点 4.2.1 实战：拖动鼠标快速创建来访人员登记表················49 ★重点 4.2.2 实战：指定行数与列数创建工会活动采购表··············· 49 4.2.3 实战：手动绘制员工档案表······50 4.2.4 实战：通过模板插入工作总结表···································50 4.3 编辑表格的方法 ·················51 4.3.1 实战：在员工档案表中 输入内容 ·······························51 4.3.2 选择员工档案表中的表格对象······51 4.3.3 在员工档案表中添加与删除 行和列···································52 ★重点 4.3.4 实战：合并与拆分档案表中的单元格···················54 4.3.5 实战：调整采购表的行高与列宽···································54 4.3.6 实战：为采购表绘制斜线表头······································55 4.4 美化表格的方法 ·················55 4.4.1 实战：为员工档案表设置文字方向 ·······························55 4.4.2 实战：为员工档案表设置文字对齐方式·························56 ★重点 4.4.3 实战：为采购表应用内置样式·························56 4.4.4 实战：为采购表自定义边框和底纹····································· 57 妙招技法··································58 技巧 01 表格拆分方法·························58 技巧 02 重复表格标题·························58 技巧 03 让单元格大小随内容增减而变化···································58 技巧 04 在表格中进行计算 ··················59 技巧 05 对表格中的内容进行排序 ·······59 图文编排美化文档 ···················60 5.1 WPS 中的图文应用·············60 5.1.1 多媒体元素在文档中的应用 ······60 5.1.2 图片选择的注意事项················61 5.1.3 设置图片的环绕方式················62 5.2 在海报中插入图片 ··············63 5.2.1 实战：在海报中插入图片·········63 5.2.2 实战：设置图片的格式 ············64 5.3 在文档中使用形状图形········67 ★重点 5.3.1 实战：在海报中绘制形状 ·······························67 5.3.2 设置形状的样式······················67 5.3.3 在形状中添加文字···················69 5.4 在文档中使用文本框···········69 ★重点 5.4.1 实战：在海报中绘制文本框···································70 5.4.2 编辑海报中的文本框················70 5.5 在文档中使用艺术字···········72 ★重点 5.5.1 实战：在海报中插入艺术字···································72 5.5.2 编辑海报中的艺术字················72 5.6 在文档中使用智能图形········74 ★重点 5.6.1 实战：在公司简介中插入智能图形·························74 5.6.2 编辑智能图形 ·························74 5.7 在文档中使用功能图···········76 ★重点 5.7.1 实战：制作产品 条形码···································76 5.7.2 实战：制作二维码···················76 妙招技法··································78 技巧 01 压缩图片大小·························78 技巧 02 将图片裁剪为其他形状············78 技巧 03 对齐多个形状·························79 技巧 04 一次性保存文档中的所有图片 ·······························79 技巧 05 绘制水平线条·························79 文档的高级编排······················81 6.1 了解样式和模板 ·················81 6.1.1 了解样式································81 6.1.2 样式的作用 ····························81 6.1.3 设置样式的小技巧···················82 6.1.4 模板文件································82 6.2 使用样式编排文档 ··············82 ★重点 6.2.1 实战：为通知应用样式······································82 6.2.2 实战：新建自定义样式············ 83 ★重点 6.2.3 更改和删除样式············84 6.3 为文档应用模板 ·················85 ★重点 6.3.1 实战：使用内置模板创建固定资产申购表················85 6.3.2 实战：新建自定义模板 ············85 6.4 为文档创建封面和目录········89 ★重点 6.4.1 实战：为投标书创建封面 ·······························89 ★重点 6.4.2 实战：为投标书创建目录 ·······························90 6.4.3 实战：编辑投标书的目录·········90 6.5 在文档中插入题注与脚注······91 6.5.1 实战：在文档中插入题注·······91 6.5.2 实战：为古诗添加脚注 ············92 6.5.3 实战：为古诗添加尾注············ 93 6.6 使用邮件合并功能 ··············93 ★重点 6.6.1 实战：使用邮件合并功能批量创建通知书················93 6.6.2 管理收件人列表······················95 6.7 文档的审阅与修订 ··············95 ★重点 6.7.1 实战：为论文添加和删除批注 ·······························95 ★重点 6.7.2 实战：修订计划书文档······································96 6.7.3 实战：修订的更改和显示·········97 6.7.4 实战：使用审阅功能··············97 妙招技法··································98 技巧 01 快速统计文档字数 ··················98 技巧 02 将字体嵌入文件······················98 技巧 03 根据样式提取目录 ··················99 技巧 04 将目录转换为普通文本············99 技巧 05 脚注和尾注互换······················99 +++本章小结······························· 100 第7章 文档的页面设置与打印···········101 7.1 了解页面设置··················· 101 7.1.1 认识页面的基本结构·············· 101 7.1.2 WPS 分节符的妙用················ 101 7.1.3 编排注意事项 ······················· 102 7.2 设置文档的背景 ··············· 103 7.2.1 实战：为文档添加水印 ·········· 103 ★重点 7.2.2 实战：为文档添加边框···································· 104 7.2.3 实战：为文档设置页面颜色··································· 104 7.2.4 实战：使用纹理作为页面背景··································· 105 7.3 设置页面布局··················· 105 ★重点 7.3.1 实战：设置页面边距··································· 105 7.3.2 实战：设置页面方向 ············· 106 7.3.3 实战：设置页面大小 ············· 106 7.4 设置页眉、页脚和页码······ 107 ★重点 7.4.1 实战：为公司规章制度 文档添加页眉和页脚············· 107 7.4.2 实战：为公司规章制度文档 添加页码 ····························· 108 7.5 打印文档························· 109 ★重点 7.5.1 实战：预览与打印 文档···································· 109 7.5.2 打印文档的部分页················· 110 7.5.3 双面打印文档 ······················· 110 妙招技法·································110 技巧 01 为文档预留装订线区域 ········ 110 技巧 02 设置奇偶页不同的页眉和页脚·····································111 技巧 03 让页码从指定数值开始编号······111 技巧 04 打印文档的背景颜色 ··············111 技巧 05 打印隐藏的文字···················· 112 本章小结································112 第 3 篇 WPS 表格应用篇 第8章 WPS 表格数据的录入与编辑 ····································113 8.1 认识 WPS 表格··················113 8.1.1 认识工作簿 ·························· 113 8.1.2 认识工作表 ·························· 114 8.1.3 认识行与列 ·························· 114 8.1.4 工作簿的视图应用················· 114 8.2 工作表的基本操作 ·············117 ★重点 8.2.1 新建与删除工作表······· 117 8.2.2 移动与复制工作表················· 117 8.2.3 重命名工作表 ······················· 118 8.2.4 隐藏和显示工作表················· 119 ★重点 8.2.5 更改工作表标签颜色···································· 119 8.3 行与列的基本操作 ············ 120 ★重点 8.3.1 选择行和列················ 120 ★重点 8.3.2 设置行高和列宽·········· 120 8.3.3 插入与删除行与列················· 121 8.3.4 移动和复制行与列················· 122 8.3.5 隐藏与显示行和列················· 123 8.4 单元格的基本操作 ············ 124 ★重点 8.4.1 选择单元格················ 124 ★重点 8.4.2 实战：插入单元格 ······ 124 8.4.3 删除单元格 ·························· 125 8.4.4 移动与复制单元格················· 125 ★重点 8.4.5 实战：合并与取消合并单元格 ·························· 126 8.5 输入表格数据··················· 127 ★重点 8.5.1 实战：在员工档案表中输入姓名 ····························· 127 ★重点 8.5.2 实战：在员工档案表中输入员工编号······················· 128 ★重点 8.5.3 实战：在员工档案表中输入日期 ····························· 129 8.5.4 实战：在员工档案表中插入特殊符号 ····························· 130 8.5.5 在工作表中填充数据·············· 130 8.5.6 导入数据与刷新数据·············· 132 8.6 设置表格样式··················· 133 8.6.1 实战：设置记录表文本格式·······134 ★重点 8.6.2 实战：设置工资表的数据格式 ····························· 134 8.6.3 实战：设置工资表的对齐方式···································· 135 8.6.4 实战：设置工资表的边框和底纹样式 ····························· 135 8.6.5 实战：为工资表应用单元格样式···································· 136 ★新功能 8.6.6 实战：为工资表应用表格样式 ····························· 136 8.7 设置数据有效性 ··············· 136 ★重点 8.7.1 实战：只允许在单元格中输入整数················· 137 ★重点 8.7.2 实战：为数据输入设置下拉列表······················· 137 8.7.3 实战：限制重复数据的输入······138 8.7.4 设置输入信息提示················· 139 8.7.5 设置出错警告提示················· 139 妙招技法································ 139 技巧 01 怎样输入身份证号 ················ 139 技巧 02 快速在多个单元格中输入 相同数据 ····························· 140 技巧 03 快速填充所有空白单元格······· 140 技巧 04 巧妙输入位数较多的员工 编号···································· 141 技巧 05 如何自动填充日期值 ············· 141 本章小结······························· 141 第9章 对电子表格数据进行分析········142 9.1 认识数据分析··················· 142 9.1.1 数据分析······························ 142 9.1.2 数据排序的规则···················· 142 9.1.3 数据筛选的几种方法·············· 143 9.1.4 分类汇总的要点···················· 144 9.2 使用条件格式··················· 144 ★重点 9.2.1 实战：在销售表中突出显示符合条件的数据·············· 145 ★重点 9.2.2 实战：在销售表中选取销售额前 3 的数据················· 145 ★重点 9.2.3 实战：使用数据条、色阶和图标集显示数据·········· 146 9.2.4 新建条件格式 ······················· 147 9.2.5 编辑和删除条件格式·············· 149 9.3 排序数据························· 150 ★重点 9.3.1 实战：对成绩表进行简单排序 ····························· 150 9.3.2 实战：对成绩表进行多条件排序···································· 151 9.3.3 在成绩表中自定义排序条件································· 151 9.4 筛选数据························· 152 ★重点 9.4.1 实战：在销量表中进行自动筛选······················· 152 9.4.2 实战：在销量表中自定义筛选···································· 153 9.4.3 实战：在销量表中高级筛选···································· 153 9.4.4 取消筛选······························ 154 9.5 分类汇总数据··················· 155 ★重点 9.5.1 实战：对业绩表进行简单分类汇总················ 155 9.5.2 实战：对业绩表进行高级分类汇总 ····························· 156 9.5.3 对业绩表进行嵌套分类汇总···································· 157 9.6 合并计算数据··················· 158 9.6.1 实战：合并计算销售情况表································· 158 9.6.2 实战：合并计算销售汇总表的多个工作表 ······················ 158 妙招技法································ 159 让数据条不显示单元格数值···································· 159 只在不合格的单元格上显示图标集 ·························· 160 技巧 利用筛选功能快速删除空白行································· 161 技巧 在文本筛选中使用通配符进行模糊筛选····················· 162 技巧按单元格颜色进行筛选·········· 162 本章小结······························· 162 第 10 章 使用公式和函数计算数据········163 10.1 认识公式与函数·············· 163 10.1.1 认识公式···························· 163 10.1.2 认识运算符························· 163 10.1.3 认识函数···························· 164 10.1.4 认识数组公式······················ 166 10.2 认识单元格引用·············· 166 10.2.1 实战：相对引用、绝对引用和混合引用 ·························· 167 ★重点 10.2.2 实战：同一工作簿中引用单元格 ·························· 169 10.2.3 引用其他工作簿中的单元格································· 170 10.2.4 定义名称代替单元格地址······ 170 10.3 使用公式计算数据··········· 171 ★重点 10.3.1 实战：在销量表中输入公式 ····························· 171 ★重点 10.3.2 公式的填充与复制······ 172 10.3.3 公式的编辑与删除 ··············· 173 10.3.4 使用数组公式计算数据········· 173 10.3.5 编辑数组公式······················ 174 10.4 使用公式的常见问题········ 175 10.4.1 #### 错误 ··························· 175 10.4.2 NULL! 错误 ························ 175 10.4.3 #NAME? 错误 ····················· 175 10.4.4 #NUM! 错误························ 175 10.4.5 #VALUE! 错误····················· 175 10.4.6 #DIV/0! 错误 ······················· 175 10.4.7 #REF! 错误 ························· 176 10.4.8 #N/A 错误··························· 176 10.5 使用函数计算数据··········· 176 ★重点 10.5.1 实战：使用 SUM 函数计算总销售额······················· 176 ★重点 10.5.2 实战：使用 AVERAGE函数计算平均销售额··········· 177 10.5.3 实战：使用 COUNT 函数统计单元格个数 ·························· 177 ★重点 10.5.4 实战：使用 MAX 函数计算销量最大值···················· 178 ★重点 10.5.5 实战：使用 MIN 函数计算销量最小值···················· 179 10.5.6 实战：使用 RANK 函数计算排名···································· 179 10.5.7 实战：使用 PMT 函数计算定期支付金额······················· 180 10.5.8 实战：使用 IF 函数进行条件判断 ····························· 180 10.5.9 根据身份证号码提取生日和性别···································· 181 妙招技法································ 182 技巧 01 怎样保护公式不被修改·········· 182 技巧 02 如何将公式隐藏起来 ············· 182 技巧 03 追踪引用单元格与追踪从属单元格 ····························· 183 技巧 04 用错误检查功能检查公式······· 184 技巧 05 快速查找需要的函数 ············· 184 本章小结······························· 185 第 11 章 使用图表统计与分析数据········186 11.1 认识图表························ 186 11.1.1 图表的组成························· 186 11.1.2 图表的类型························· 186 11.2 创建与编辑图表·············· 190 ★重点 11.2.1 实战：为销售表创建图表 ····························· 190 11.2.2 实战：移动销售表图表位置···································· 191 11.2.3 实战：调整销售表图表的大小···································· 191 ★新功能 11.2.4 实战：更改销售表图表的类型 ·························· 192 11.2.5 实战：更改销售表图表数据源································· 192 11.3 调整图表的布局·············· 193 ★重点 11.3.1 实战：为销售图表添加数据标签······················· 193 11.3.2 实战：为销售图表添加趋势线································· 193 11.3.3 实战：快速布局销售图表······ 194 11.3.4 实战：更改销售图表的颜色···································· 194 ★新功能 11.3.5 实战：为销售图表应用图表样式······················· 195 妙招技法································ 195 技巧 01 设置条件变色的数据标签······· 195 技巧 02 制作可以选择的动态数据图表···································· 196 技巧 03 让扇形区独立于饼图之外······· 197 技巧 04 在图表中筛选数据 ················ 197 技巧 05 将图表保存为图片 ················ 198 本章小结······························· 198 第 12 章 使用数据透视表和数据透视图 ·································199 12.1 认识数据透视表·············· 199 12.1.1 数据透视表························· 199 12.1.2 图表与数据透视图的区别······ 200 12.1.3 透视表数据源设计四大准则···································· 200 12.1.4 如何制作标准的数据源········· 201 12.2 创建数据透视表·············· 203 ★重点 12.2.1 实战：为业绩表创建数据透视表 ·························· 203 ★重点 12.2.2 实战：调整业绩透视表中的布局 ····························· 204 ★新功能 12.2.3 实战：为业绩透视表应用样式································ 205 12.3 在数据透视表中分析数据 ······································ 205 ★重点 12.3.1 实战：在业绩透视表中排序数据 ·························· 205 ★重点 12.3.2 实战：在业绩透视表中筛选数据 ·························· 206 ★新功能 12.3.3 实战：使用切片器筛选数据 ····························· 206 12.4 创建数据透视图·············· 207 ★重点 12.4.1 实战：使用数据透视表创建数据透视图···················· 207 12.4.2 实战：在数据透视图中筛选数据 ····························· 208 12.4.3 隐藏数据透视图的字段按钮···································· 208 妙招技法································ 209 技巧 01 让数据透视表中的空白单元格显示为 0····················· 209 技巧 02 手动更新数据透视表中的数据···································· 210 技巧 03 在数据透视表中显示各数据占总和的百分比······················· 210 技巧 04 在项目之间添加空行 ············· 210 技巧 05 在多个数据透视表中共享切片器································· 211 本章小结······························· 212 第 13 章 WPS 表格的保护与打印 ·········213 13.1 保护工作表和工作簿········ 213 ★重点 13.1.1 为工作簿设置保护密码 ····························· 213 13.1.2 为工作表设置密码 ··············· 214 13.1.3 实战：凭密码编辑工作表的不同区域 ·························· 214 13.2 工作表的页面设置··········· 215 ★重点 13.2.1 实战：为工作表添加页眉和页脚 ···························· 215 13.2.2 设置工作表的页面格式········· 216 13.2.3 实战：为工作表设置背景图片···································· 216 13.3 打印工作表 ···················· 217 ★重点 13.3.1 实战：预览及打印工作表································· 217 13.3.2 只打印工作表的部分区域······ 217 妙招技法································ 218 技巧 01 如何在打印的纸张中打印行号和列标································· 218 技巧 02 缩放打印工作表···················· 218 技巧 03 避免打印工作表中的错误值······219 技巧 04 重复打印标题行···················· 219 技巧 05 强制在某个单元格处开始分页打印 ····························· 219 本章小结······························· 220 第 4 篇 WPS 演示文稿篇 第 14 章 WPS 演示文稿的创建与编辑 ····································221 14.1 怎样才能做好演示文稿 ······································ 221 14.1.1 演示文稿的组成元素与设计理念 ····························· 221 14.1.2 演示文稿图文并存的设计技巧 ····························· 222 14.1.3 演示文稿的布局设计 ············ 223 14.1.4 演示文稿的色彩搭配 ············ 225 14.2 幻灯片的基本操作··········· 227 ★重点 14.2.1 实战：创建演示文稿···································· 228 14.2.2 选择幻灯片························· 229 ★重点 14.2.3 添加和删除总结演示文稿中的幻灯片·············· 229 14.2.4 移动和复制演示文稿中的幻灯片································· 230 14.2.5 更改演示文稿中的幻灯片版式···································· 231 14.3 幻灯片的编辑与美化 ······ 231 14.3.1 设置演示文稿的幻灯片大小···································· 232 14.3.2 更改演示文稿的幻灯片配色···································· 232 14.3.3 实战：更改演示文稿的幻灯片背景 ·························· 232 ★新功能 14.3.4 为演示文稿幻灯片应用设计方案······················· 233 ★新功能 14.3.5 实战：使用“魔法”制作咨询演示文稿················· 233 14.4 在幻灯片中插入对象········ 234 ★重点 14.4.1 实战：在商品介绍幻灯片中插入图片················· 234 ★重点 14.4.2 实战：在商品介绍幻灯片中插入智能图形 ·········· 236 ★重点 14.4.3 实战：在商品介绍幻灯片中插入表格················· 237 14.4.4 实战：在商品介绍幻灯片中插入图表 ····························· 237 14.4.5 在幻灯片中插入音频和视频···································· 238 14.5 WPS 演示文稿的母版设计 ······································ 240 ★重点 14.5.1 实战：创建幻灯片的母版···································· 240 14.5.2 为幻灯片母版应用主题 ··········· 243 14.5.3 使用幻灯片母版创建演示文稿···································· 243 妙招技法································ 244 技巧 01 隐藏幻灯片母版中的形状······· 244 技巧 02 设置声音的淡入和淡出·········· 244 技巧 03 将字体嵌入演示文稿··············· 245 技巧 04 调整幻灯片中的声音大小······· 245 技巧 05 在幻灯片中裁剪视频文件······· 245 本章小结······························· 246 第 15 章 WPS 演示文稿的动画设置 ······247 15.1 添加动画的作用·············· 247 15.1.1 设置动画的原因··················· 247 15.1.2 分清动画的种类··················· 247 15.1.3 添加动画的注意事项 ············ 248 15.2 设置幻灯片的切换效果 ······249 ★重点 15.2.1 实战：选择幻灯片的切换效果 ····························· 249 ★重点 15.2.2 设置幻灯片切换速度和声音································· 250 15.2.3 实战：设置幻灯片切换方式···································· 250 15.2.4 实战：删除幻灯片的切换效果···································· 250 15.3 设置对象的切换效果········ 250 ★重点 15.3.1 实战：添加对象进入动画效果······················· 251 ★新功能 15.3.2 实战：为同一对象添加多个动画效果 ·········· 251 15.3.3 编辑动画效果······················ 252 ★新功能 15.3.4 实战：设置动态数字动画效果······················· 254 ★重点 15.3.5 删除幻灯片中的动画效果···································· 254 15.4 设置幻灯片的交互效果 ······255 15.4.1 实战：在幻灯片中插入其他文件···································· 255 ★重点 15.4.2 在幻灯片中插入超链接································· 256 15.4.3 编辑和删除超链接 ··············· 256 15.4.4 通过动作按钮创建链接········· 257 妙招技法································ 258 技巧 01 如何让鼠标经过某个对象时执行操作 ····························· 258 技巧 02 制作自动消失的字幕 ············· 258 技巧 03 制作闪烁文字效果 ················ 260 技巧 04 制作拉幕式幻灯片 ················ 260 技巧 05 使用叠加法逐步填充表格······· 261 本章小结······························· 262 第 16 章 WPS 演示文稿的放映与输出 ····································263 16.1 了解演示文稿的放映········ 263 16.1.1 了解演示文稿的放映方式······ 263 16.1.2 做好放映前的准备工作········ 264 16.2 演示文稿的放映设置········ 264 ★重点 16.2.1 实战：设置演示文稿的放映方式 ·························· 265 16.2.2 指定幻灯片的播放 ··············· 265 16.2.3 设置幻灯片的换片方式········· 266 16.2.4 设置幻灯片的放映时间········· 266 16.3 演示文稿的放映控制········ 267 ★重点 16.3.1 实战：开始放映培训演示文稿 ····························· 267 16.3.2 实战：在放映幻灯片时控制播放过程 ····························· 270 16.4 演示文稿的输出和打印 ······271 ★重点 16.4.1 实战：将总结演示文稿输出为视频文件·············· 271 16.4.2 实战：将总结演示文稿输出为图片文件 ·························· 273 16.4.3 实战：将总结演示文稿输出为 PDF 文件 ························· 273 16.4.4 实战：将总结演示文稿转为WPS 文字文档······················ 274 ★重点 16.4.5 实战：打包总结演示文稿···································· 275 ★重点 16.4.6 实战：打印总结演示文稿···································· 275 妙招技法································ 276 技巧 01 隐藏声音图标······················· 276 技巧 02 取消以黑屏幻灯片结束·········· 276 技巧 03 在放映幻灯片时如何隐藏鼠标指针 ····························· 277 技巧 04 如何在放映时禁止弹出右键菜单···································· 277 技巧 05 为幻灯片设置黑 / 白屏··········· 277 本章小结······························· 277 第 5 篇 WPS 其他组件应用篇 WPS Office 2019除常用的3个组件外，还可以创建PDF文件、使用流程图制作工作流程、组织结构图等，也可以使用脑图快速完成销售总结、设计思路的制作。此外，还可以使用图片设置制作海报、邀请函、祝福卡等。 第 17 章 WPS 的其他组件应用·············278 17.1 使用 PDF 功能创建文件 ······································ 278 ★新功能 17.1.1 新建 PDF 文件 ······· 278 17.1.2 查看 PDF 文件····················· 280 17.1.3 为 PDF 文件设置高亮 ··········· 282 17.1.4 为 PDF 文件添加签名 ··········· 283 17.1.5 将多个 PDF 文件合并为一个···································· 285 17.2 使用流程图创建公司组织结构图··································· 285 ★新功能 17.2.1 新建流程图文件······ 285 17.2.2 编辑流程图························· 286 17.2.3 美化流程图························· 288 ★重点 17.2.4 实战：在 WPS 文字中插入流程图 ·························· 290 17.3 使用脑图创建工作 总结 ······································ 291 ★新功能 17.3.1 新建脑图文件········291 17.3.2 编辑脑图···························· 292 17.3.3 美化脑图···························· 293 ★重点 17.3.4 实战：在演示文稿中插入脑图 ····························· 295 17.4 使用图片设计制作创意图片 ······································ 296 ★新功能 17.4.1 制作海报··············· 296 ★新功能 17.4.2 制作邀请函 ··········· 298 ★新功能 17.4.3 制作名片··············· 299 17.5 使用表单工具进行网络互动 ······································ 300 ★新功能 17.5.1 通过新建表单创建商品订购表···················· 300 ★新功能 17.5.2 通过模板创建培训签到表 ·························· 303 妙招技法································ 303 技巧 01 将脑图另存为图片 ················ 303 技巧 02 匹配流程图图形的高度和宽度···································· 304 技巧 03 为脑图添加超链接 ················ 304 技巧 04 为海报应用自定义背景·········· 305 技巧 05 使用抠图功能去除图片背景···································· 305 本章小结······························· 306 第 6 篇 WPS 案例实战篇 第 18 章 WPS 在行政与文秘工作中的应用 ····································307 18.1 用 WPS 文字制作参会邀请函··································· 307 18.1.1 制作参会邀请函··················· 308 18.1.2 美化参会邀请函··················· 311 18.1.3 使用邮件合并完善邀请函······ 312 18.2 用 WPS 表格制作公司员工信息表····························· 314 18.2.1 新建员工信息表文件 ············ 314 18.2.2 录入员工基本信息 ··············· 314 18.2.3 编辑单元格和单元格区域······ 315 18.2.4 设置字体、字号和对齐方式···································· 316 18.2.5 美化员工信息表··················· 317 18.3 用 WPS 演示文稿制作企业宣传幻灯片 ······················ 317 18.3.1 创建演示文稿文件 ··············· 318 18.3.2 设置幻灯片母版··················· 319 18.3.3 制作幻灯片封面··················· 320 18.3.4 制作目录···························· 322 18.3.5 制作“发展历程”幻灯片······ 323 18.3.6 制作“全国分支”幻灯片······ 324 18.3.7 制作“设计师团队” 幻灯片································· 325 18.3.8 制作“团队介绍”幻灯片······ 325 18.3.9 制作“项目介绍”幻灯片······ 326 18.3.10 制作“主要业务”幻灯片································· 327 18.3.11 制作“企业理念”幻灯片································· 328 18.3.12 制作封底幻灯片················· 328 18.3.13 设置幻灯片的播放·············· 328 本章小结······························· 329 第 19 章 WPS 在市场与销售工作中的应用 ····································330 19.1 用 WPS 文字制作市场 调查报告································ 330 19.1.1 设置报告页面样式 ··············· 331 19.1.2 为调查报告设计封面 ············ 331 19.1.3 使用样式规范正文样式········· 333 19.1.4 插入图表丰富文档 ··············· 334 19.1.5 插入页码与目录··················· 336 19.2 用 WPS 表格制作产品定价分析表··································· 336 19.2.1 新建产品定价分析表 ············ 337 19.2.2 筛选表格数据······················ 339 19.2.3 使用公式计算成本 ··············· 340 19.3 用 WPS 演示文稿制作年度 销售报告································ 343 19.3.1 在幻灯片母版中设计版式······ 344 19.3.2 为封面幻灯片设置文本效果···································· 345 19.3.3 制作幻灯片目录··················· 346 19.3.4 绘制形状制作幻灯片 ············ 347 19.3.5 制作收益分析表格 ··············· 350 19.3.6 插入图表分析数据 ··············· 351 19.3.7 播放幻灯片························· 351 本章小结······························· 352 第 20 章 WPS 在人力资源工作中的应用 ····································353 20.1 用 WPS 文档制作公司员工手册································ 353 20.1.1 制作封面···························· 354 20.1.2 输入内容并设置格式 ············ 356 20.1.3 提取目录···························· 357 20.1.4 设置页眉与页脚··················· 357 20.1.5 打印员工手册······················ 359 20.2 用 WPS 表格制作员工培训计划表····························· 359 20.2.1 录入表格数据······················ 360 20.2.2 设置表格格式······················ 361 20.2.3 调整表格列宽······················ 362 20.2.4 设置表格页面格式 ··············· 362 20.2.5 添加页眉与页脚··················· 363 20.3 用 WPS 演示文稿制作员工入职培训演示文稿················ 364 20.3.1 根据模板新建演示文稿········· 365 20.3.2 添加幻灯片内容··················· 366 20.3.3 在幻灯片中插入智能图形······ 367 20.3.4 使用“魔法”匹配幻灯片设计···································· 368 20.3.5 设置幻灯片切换效果 ············ 369 本章小结······························· 370 第 6 篇 WPS 案例实战篇 第1篇 WPS 在财务会计工作中的应用 ····································371 21.1 用 WPS 文字制作盘点工作流程图····························· 371 21.1.1 插入与编辑智能图形 ············ 372 21.1.2 插入文本框完善智能图形······ 373 21.1.3 插入艺术字制作标题 ············ 374 21.2 用 WPS 表格制作员工工资统计表····························· 375 21.2.1 创建员工基本工资管理表······ 376 21.2.2 创建奖惩管理表··················· 378 21.2.3 创建考勤统计表··················· 379 21.2.4 创建加班统计表··················· 380 21.2.5 编制工资统计表··················· 381 21.2.6 按部门汇总工资数据 ············ 385 21.2.7 实现任意员工工资数据查询···································· 386 21.2.8 打印工资表························· 388 21.2.9 打印工资条························· 390 21.3 用 WPS 演示文稿制作年度财务总结报告演示文稿············· 391 21.3.1 设计幻灯片母版··················· 392 21.3.2 输入标题文本······················ 393 21.3.3 在幻灯片中插入表格 ············ 394 21.3.4 使用图片美化幻灯片 ············ 395 21.3.5 在幻灯片中插入图表 ············ 396 21.3.6 在幻灯片中插入形状 ············ 397 21.3.7 设置幻灯片动画和切换 效果···································· 397 本章小结······························· 399 附录 A WPS 文字快捷键········ 400 附录 B WPS 表格快捷键········ 402 附录 C WPS 演示文稿 快捷键··································· 405

凤凰高新教育专注于高质量图书出版，集团总裁为知名图书策划人及内容创作者，曾任五月花学院（现希望教育集团）教研总监，负责教学、教材研发和老师培训，具有丰富的教学经验，常年对政企机构做专业培训，培训的企业包括仁和集团、成都军区、箭牌口香糖四川分公司、中国水电七局等。对Office、平面设计、辅助设计等有深入研究和独到见解，策划出版了多本畅销书，包括《案例学——Photoshop商业广告设计》《Word/Excel/PPT2016三合一完全自学教程》《精进PPT——PPT设计思维、技术与实践》等，广受读者的认可和好评。

暂无其它内容！

暂时还没有人为这本书评论！