《电脑办公自动化实例教程(第五版)(微课版)》

第 1 章 电脑办公自动化概述..................... 1
1.1 办公自动化基础知识················2
1.1.1 办公自动化的概念················· 2
1.1.2 办公自动化的功能················· 2
1.1.3 办公自动化的特点················· 2
1.1.4 办公自动化所需条件·············· 3
1.2 办公自动化技术支持················4
1.2.1 办公自动化硬件平台·············· 4
1.2.2 办公自动化软件系统·············· 5
1.2.3 使用鼠标与键盘···················· 5
1.3 办公文件的管理方法················6
1.3.1 合理分类···························· 7
1.3.2 规范命名···························· 7
1.3.3 快速检索···························· 8
1.3.4 权限设置···························· 8
1.4 实例演练 ······························8
1.4.1 使用快捷键管理文件与文件夹···· 8
1.4.2 设置禁止修改办公文件内容······ 9
1.5 习题·································· 10
第 2 章 Windows 10 办公基础.................11
2.1 Windows 10 系统桌面 ············· 12
2.1.1 管理桌面图标 ···················· 12
2.1.2 使用任务栏和虚拟桌面 ········· 13
2.1.3 使用分屏功能 ···················· 15
2.1.4 使用 Ribbon 界面 ················ 16
2.1.5 使用开始菜单 ···················· 20
2.1.6 使用操作中心 ···················· 23
2.1.7 使用搜索窗口 ···················· 23
2.2 办公文件的移动和复制 ··········· 24
2.3 系统环境的个性化设置 ··········· 25
2.3.1 自定义桌面主题·················· 25
2.3.2 自定义锁屏界面·················· 27
2.3.3 设置屏幕保护程序··············· 28
2.4 系统账户设置······················· 28
2.4.1 Windows 10 账户基础知识······ 28
2.4.2 注册 Microsoft 账户·············· 29
2.4.3 从本地账户切换至
 Microsoft 账户 ···················· 29
2.4.4 设置 Windows 10 登录模式 ····· 29
2.5 系统任务管理······················· 32
2.6 重要资料的备份与还原 ··········· 34
2.6.1 文件备份与还原·················· 34
2.6.2 系统映像备份与还原 ············ 38
2.7 系统重置与保护···················· 39
2.7.1 系统重置 ·························· 39
2.7.2 系统保护 ·························· 40
2.8 实例演练 ···························· 41
2.8.1 更改系统的日期和时间·········· 41
2.8.2 使用 Windows 10 自带工具 ····· 41
2.9 习题·································· 42
第 3 章 电脑办公软件和设备...................43
3.1 安装与卸载电脑软件·············· 44
3.1.1 在电脑中安装软件 ··············· 44
3.1.2 卸载电脑中的软件 ··············· 45
3.2 使用办公软件······················· 46
3.2.1 使用 Microsoft Edge 浏览器····· 46
3.2.2 使用文件下载软件 ··············· 50
3.2.3 使用文件检索软件 ··············· 51
3.2.4 使用文件压缩软件 ··············· 52
3.2.5 使用文件格式转换软件·········· 53
3.2.6 使用图片处理软件 ··············· 54
3.2.7 使用 PDF 编辑软件 ·············· 56
3.2.8 使用电子邮件管理软件·········· 57
3.2.9 使用电子笔记管理软件·········· 61
3.2.10 使用 Microsoft Office
 办公软件························· 65
3.2.11 使用 WPS Office 办公软件····· 69
3.3 使用办公设备······················· 72
3.3.1 使用打印机和扫描仪 ············ 73
3.3.2 使用移动存储设备 ··············· 73
3.4 实例演练 ···························· 74
电脑办公自动化实例教程(第五版)(微课版)
VI
3.4.1 使用插件强化
 Microsoft Edge 功能 ············· 74
3.4.2 使用 WPS 写作模式辅助
 编辑文档·························· 75
3.5 习题·································· 76
第 4 章 制作 Word 办公文档................... 77
4.1 Word 2016 办公基础··············· 78
4.1.1 Word 2016 主要应用············· 78
4.1.2 Word 2016 工作界面············· 78
4.1.3 Word 2016 视图模式············· 79
4.1.4 Word 2016 基本设置············· 80
4.2 制作入职通知······················· 83
4.2.1 新建空白文档 ···················· 83
4.2.2 保存文档·························· 83
4.2.3 输入文本内容 ···················· 84
4.2.4 编辑文本内容 ···················· 86
4.2.5 设置文本格式 ···················· 90
4.2.6 设置段落格式 ···················· 92
4.2.7 使用文本样式 ···················· 94
4.2.8 将文档保存为模板··············· 96
4.3 制作考勤管理制度················· 97
4.3.1 使用模板创建文档··············· 97
4.3.2 选择性粘贴文本·················· 97
4.3.3 设置项目符号和编号············ 99
4.3.4 使用表格·························101
4.3.5 设置页眉和页脚·················106
4.3.6 设置文档比较 ···················108
4.3.7 使用修订模式 ···················109
4.3.8 设置文档保护 ··················· 110
4.4 实例演练 ··························· 112
4.4.1 制作房屋租赁协议·············· 112
4.4.2 制作电子收据单················· 113
4.5 课后习题 ··························· 114
第 5 章 排版与打印办公文档..................115
5.1 Word 排版基础知识··············· 116
5.1.1 Word 文档排版原则············· 116
5.1.2 Word 文档排版流程·············116
5.1.3 Word 排版操作技巧·············118
5.2 排版公司宣传单··················· 120
5.2.1 文档页面设置··················· 120
5.2.2 设置页面背景··················· 123
5.2.3 设置图文混排文档 ············· 124
5.2.4 使用自选图形··················· 128
5.2.5 使用艺术字······················ 131
5.2.6 使用文本框······················ 132
5.2.7 增加空白页······················ 133
5.2.8 设置页面边框··················· 134
5.3 排版商业计划书··················· 135
5.3.1 制作章节标题··················· 135
5.3.2 使用 SmartArt 图形············· 136
5.3.3 使用图表 ························ 138
5.3.4 制作文档目录··················· 139
5.3.5 制作文档封面··················· 141
5.3.6 设置分栏版式··················· 141
5.3.7 添加题注 ························ 142
5.3.8 设置交叉引用··················· 143
5.4 打印 Word 文档···················· 144
5.4.1 快速打印文档··················· 144
5.4.2 打印指定的页··················· 144
5.4.3 缩小打印文档··················· 144
5.4.4 双面打印文档··················· 145
5.5 实例演练 ··························· 146
5.5.1 制作研究报告··················· 146
5.5.2 制作活动入场券················ 149
5.6 习题·································150
第 6 章 制作 Excel 电子表格 .................151
6.1 Excel 2016 办公基础·············· 152
6.1.1 Excel 2016 主要功能··········· 152
6.1.2 Excel 2016 工作界面··········· 152
6.1.3 Excel 的三大元素·············· 153
6.2 制作员工通讯录··················· 154
6.2.1 创建工作簿······················ 154
6.2.2 保存工作簿······················ 154
VII
6.2.3 操作工作表······················154
6.2.4 输入与编辑数据·················158
6.2.5 操作行与列······················163
6.2.6 操作单元格······················169
6.2.7 格式化表格······················171
6.2.8 使用【记录单】添加数据 ·····174
6.3 制作销售情况汇总表············· 175
6.3.1 设置标题跨列居中··············176
6.3.2 设置合并单元格·················176
6.3.3 输入日期与时间·················177
6.3.4 设置数据的数字格式···········179
6.3.5 在多个单元格中
 同时输入数据 ···················180
6.3.6 复制单元格格式·················181
6.3.7 设置单元格填充颜色···········181
6.3.8 查找和替换数据·················181
6.3.9 隐藏与锁定单元格··············183
6.3.10 打印电子表格··················184
6.4 实例演练 ··························· 185
6.4.1 制作员工信息采集表···········185
6.4.2 制作财务支出统计表···········187
6.5 习题·································188
第 7 章 计算与分析表格数据................. 189
7.1 使用公式 ··························· 190
7.1.1 公式的基础知识·················190
7.1.2 公式的输入与修改··············192
7.1.3 公式的复制与填充··············193
7.1.4 公式的保护与隐藏··············194
7.2 使用函数 ··························· 196
7.2.1 函数的基础知识·················196
7.2.2 函数的学习方法·················198
7.2.3 函数的输入······················199
7.2.4 函数的修改与删除··············200
7.2.5 嵌套函数·························201
7.3 数据的简单分析··················· 202
7.3.1 数据表的规范化处理···········202
7.3.2 数据排序·························203
7.3.3 数据筛选·························206
7.3.4 分类汇总 ························ 210
7.3.5 使用数据透视表·················211
7.3.6 使用可视化图表················ 212
7.4 实例演练 ··························· 213
7.4.1 使用函数汇总指定商品
 月销量··························· 213
7.4.2 使用函数统计多个
 工作表数据······················ 214
7.4.3 创建动态可视化数据图表····· 215
7.5 习题·································216
第 8 章 制作 PowerPoint 演示文稿........217
8.1 PowerPoint 2016 办公基础······· 218
8.1.1 PowerPoint 2016 主要功能 ···· 218
8.1.2 PowerPoint 2016 工作界面 ···· 218
8.1.3 PowerPoint 2016 基础操作 ···· 219
8.2 制作产品介绍演示文稿 ·········· 222
8.2.1 快速创建内容框架 ············· 222
8.2.2 设置幻灯片母版················ 223
8.2.3 使用图片 ························ 227
8.2.4 使用形状 ························ 229
8.2.5 使用文本框······················ 231
8.2.6 使用 SmartArt 图形············· 232
8.2.7 使用动画 ························ 233
8.2.8 使用声音 ························ 236
8.2.9 使用视频 ························ 237
8.2.10 设置内容跳转链接············ 239
8.2.11 打包演示文稿·················· 240
8.2.12 放映演示文稿 ················· 241
8.3 制作工作总结演示文稿 ·········· 241
8.3.1 套用模板生成文档 ············· 241
8.3.2 使用表格 ························ 243
8.3.3 使用图表 ························ 245
8.3.4 使用动作按钮··················· 248
8.3.5 设置邮件链接··················· 249
8.3.6 设置页眉和页脚················ 250
8.3.7 设置自定义放映················ 251
8.3.8 导出演示文稿··················· 252
8.4 实例演练 ··························· 252
电脑办公自动化实例教程(第五版)(微课版)
VIII
8.4.1 制作视频播放控制按钮 ········252
8.4.2 为演示文稿录制旁白···········253
8.4.3 设置压缩演示文稿文件 ········254
8.5 课后习题 ··························· 254
第 9 章 Python 自动化办公................... 255
9.1 Python 自动化办公基础·········· 256
9.1.1 安装 Python ······················256
9.1.2 使用 Python 工具················256
9.1.3 编写 Python 程序················258
9.1.4 输入/输出 Python 程序 ·········258
9.1.5 运行 Python 程序················260
9.2 Excel 表格自动化处理············ 262
9.2.1 使用 xlrd 读取 Excel
 工作簿数据······················262
9.2.2 使用 xlwt 将数据写入
 Excel 工作簿·····················264
9.2.3 使用 xlutils 修改工作簿数据····264
9.3 Word 文档自动化处理············ 266
9.3.1 快速创建 Word 文档············266
9.3.2 读取 Word 文档中的段落 ······267
9.3.3 在 Word 文档中写入文字 ······268
9.3.4 在 Word 文档中写入图片 ······268
9.4 PPT 文件自动化处理 ············· 269
9.4.1 快速创建 PPT 文件·············269
9.4.2 向幻灯片中插入文本···········270
9.4.3 向幻灯片中插入图片···········271
9.5 实例演练 ··························· 272
9.6 习题·································274
第 10 章 电脑系统安全管理.................. 275
10.1 管理 Windows 服务············· 276
10.1.1 Windows 服务概述···········276
10.1.2 Windows 服务的
 启动与停止··················· 277
10.1.3 Windows 服务的
 添加与删除··················· 278
10.2 用户账户控制 ···················· 278
10.2.1 UAC 概述 ···················· 279
10.2.2 配置 UAC 规则·············· 279
10.2.3 开启/关闭 UAC·············· 280
10.3 设置 Windows 安全中心········ 281
10.4 设置 Windows 防火墙··········· 282
10.4.1 开启与关闭 Windows
 防火墙 ························ 282
10.4.2 配置 Windows 防火墙
 网络位置 ····················· 284
10.4.3 允许程序或功能通过
 Windows Defender 防火墙··· 284
10.4.4 配置 Windows 防火墙出站与
 入站规则······················· 285
10.5 使用 BitLocker 启动器加密····· 287
10.5.1 BitLocker 概述················· 287
10.5.2 加密 Windows 分区··········· 289
10.6 应用程序控制策略··············· 290
10.6.1 AppLocker 概述 ··············· 290
10.6.2 AppLocker 默认规则类型···· 291
10.6.3 开启 Application ldentity
 服务····························· 294
10.6.4 创建 AppLocker 规则········· 294
10.7 实例演练·························· 297
10.7.1 设置禁用不必要的服务 ······ 297
10.7.2 重置 Windows 防火墙 ········ 299
10.7.3 熟悉 Windows 10 系统命令·· 300
10.8 习题·····························