OFFICE高级应用教程/张银南

本书根据“注重实践、突出应用”的指导思想编写，主要内容包括 Word 2010 高级应用、 Excel 2010 高级应用、PowerPoint 2010高级应用和 Outlook与 VBA应用。每章中都安排了具体案例，对主要知识点、案例进行了视频讲解，通过详细的案例操作帮助读者掌握相关知识和培养相关技能。本书为浙江省普通高校“十三五”新形态教材，可作为应用型本科院校和职业院校计算机公共课教材，也可作为各类培训机构的培训教材和自学者参考书。

第 1篇 Word高级应用 ···························1第 1章 Word 2010基本操作 ·····················2 本章要点·······································2案例展示·······································2基本知识讲解·································3 1.1 Word 2010的窗口组成 ············3 1.2视图模式 ·····························5案例和任务····································7案例 1新建“西冷文学社招新通知”文档·······························7案例 2根据模板创建“求职简历”文档····························· 14 任务制作“档案管理制度”文档 ··· 18本章小结····································· 20疑难解析（问与答） ······················ 20习题 ········································· 20 第 2章编辑文档格式 ·······························23 本章要点····································· 23案例展示····································· 23基本知识讲解······························· 25 2.1 设置字符格式 ····················· 25 2.2 段落对齐方式 ····················· 25 2.3 段落缩进 ··························· 25 2.4 附加段落控制 ····················· 25 案例和任务·································· 26案例 1编辑“招聘启事”文档 ····· 26案例 2制作“使用说明书”文档 ··· 29任务编辑“合作协议书”文档 ···· 33 本章小结····································· 35疑难解析（问与答） ······················ 35 习题 ········································· 35 第 3章 Word图形和表格处理··················38 本章要点····································· 38案例展示····································· 38基本知识讲解······························· 39 3.1 选定图形对象 ····················· 39 3.2 环绕样式 ··························· 40 3.3 SmartArt图形类型················ 40 3.4 设置表格尺寸 ····················· 41 案例和任务·································· 41案例 1制作“产品介绍”文档 ····· 41案例 2制作“面试流程指南” 文档····························· 48案例 3制作“职工工资表”文档····························· 55 任务制作“电子小报”文档 ······· 61本章小结····································· 63疑难解析（问与答） ······················ 64习题 ········································· 64 第 4章 Word 2010文档排版 ···················67 本章要点····································· 67案例展示····································· 67基本知识讲解······························· 69 4.1 Word 2010中文档纸张的规格································· 69 4.2 页边距 ······························ 69 4.3样式 ································· 70案例和任务·································· 71 案例 1制作“新网站推广方案”文档····························· 71 案例 2排版和打印“房地产市场调查报告”文档 ·············· 78任务编辑排版“财务部工作计划” 文档 ······························· 85本章小结····································· 87疑难解析（问与答） ······················ 87习题 ········································· 88 第 5章 Word长文档编辑排版··················91 本章要点····································· 91案例展示····································· 91基本知识讲解······························· 92 5.1 Word文本的选定技巧 ··········· 92 5.2 Word的分隔符 ···················· 92案例和任务·································· 92案例 1编排“学生手册”长文档 ·························· 92案例 2编排和审校“毕业论文”长文档 ·························· 98任务编辑“个人信贷业务岗位 培训教材”文档 ···············109本章小结····································114疑难解析（问与答） ·····················115习题 ········································116 第 6章制作批量处理文档 ·····················122 本章要点····································122案例展示····································122基本知识讲解······························123 6. 1邮件合并或数据文档设置 ·····123 6.2数据文档类型 ····················123 案例和任务·································123案例 1制作邀请函 ···················123案例 2制作信封 ······················127任务制作并发送“成绩单” 邮件 ······························128本章小结····································130疑难解析（问与答） ·····················130习题 ········································130 第 2篇 Excel高级应用 ······················ 133第 7章 Excel 2010基本操作 ·················134 本章要点··································· 134案例展示··································· 134基本知识讲解····························· 135 Excel 2010的窗口组成 ··············· 135案例和任务································ 137案例 1创建“年级周考勤表”工作簿 ························ 137案例 2制作“客户资料表”电子 表格··························· 142案例 3打印“生产记录表” ······ 145任务创建“人事档案表” ········ 148本章小结··································· 151疑难解析（问与答） ···················· 151习题 ······································· 152 第 8章编辑表格数据 ·····························154 本章要点··································· 154案例展示··································· 154基本知识讲解····························· 155 Excel的编辑功能 ······················ 155案例和任务································ 158案例 1制作“学生入学信息表” ································· 158案例 2美化“课程表” ············ 162案例 3编辑“采购记录表” ······ 165任务制作“蔬菜销售表” ········ 169本章小结··································· 172疑难解析（问与答） ···················· 172习题 ······································· 173 第 9章 Excel数据计算与管理 ···············176 本章要点··································· 176案例展示··································· 176基本知识讲解····························· 177 9.1 Excel公式与函数 ··············· 177 9.2 Excel数据管理 ·················· 182 案例和任务·································183案例 1计算“成绩总评分数”表格数据 ······················183案例 2计算“比赛打分成绩表”表格数据 ······················185案例 3管理“足球出线的确认”数据····························191任务计算和管理“学生成绩 登记表” ························198本章小结····································208疑难解析（问与答） ·····················208习题 ········································208 第 10章 Excel图表分析 ························214 本章要点····································214案例展示····································214基本知识讲解······························215 10.1图表的有关术语 ················215 10.2数据透视表与数据透视图 ····216案例和任务·································216案例 1制作“房产销售业绩表”图表····························216案例 2分析“职工业绩考核”表格····························221任务 1用图表分析“学生期末成绩表” ······················224任务 2用图表分析“停车情况 记录表” ······················231本章小结····································239疑难解析（问与答） ·····················239习题 ········································240 第 3篇 PowerPoint高级应用 ·············249第 11章 PowerPoint 2010基本操作 ······250 本章要点····································250基本知识讲解······························250 PowerPoint 2010概述··················250案例和任务·································251 案例 1创建“项目报告”演示文稿····························251 案例 2编辑“电子通知”演示文稿··························· 257任务制作“课程简介”演示 文稿 ····························· 260本章小结··································· 262疑难解析（问与答）···················· 262习题 ······································· 262 第 12章形式多样的幻灯片 ···················264 本章要点··································· 264基本知识讲解 ····························· 264嵌入对象和 SmartArt图形··········· 264案例和任务································ 264 案例 1编辑“公司会议”演示文稿··························· 264案例 2制作“生日贺卡”演示文稿··························· 268任务制作“活动汇报”演示 文稿 ····························· 271本章小结··································· 272疑难解析（问与答） ···················· 273习题 ······································· 273 第 13章演示文稿的动态效果与放映输出 ······ 274 本章要点··································· 274基本知识讲解 ····························· 274设置动态效果 ·························· 274案例和任务································ 275 案例 1制作“学唐诗”演示文稿··························· 275案例 2编辑“电子相册”演示文稿··························· 280任务 1制作“浪漫婚礼”演示文稿··························· 284任务 2制作“微课件”演示 文稿···························

"随着计算机技术日新月异的发展，计算机办公软件的应用已经融入到我们日常工作、学习和生活中。目前应用型高校大多数都开设了与办公软件应用相关的课程，“Office 高级应用”已成为许多高校计算机公共课的热门课程之一。本书根据“注重实践、突出应用”的指导思想，采用案例和项目式教学的形式编写，其目的是让学生在实践操作中掌握 Office 应用技术。 本书作为浙江省高校“十三五”第二批新形态教材建设项目，在原有教材的基础上，融入了“互联网 +教育”的理念，采用新的教育技术，将核心内容做成微课形式，编写新形态教材，以嵌入二维码的纸质教材为载体，嵌入讲解视频，拓展数字资源，搭建网络教学平台，融入数据分析等实用知识，部分内容以补充知识方式进行拓展。 本书具有如下特色： . 通俗易懂，实践操作性强。本书既有理论知识的讲解，又有成熟的实践案例，知识点介绍简洁明了，实践操作讲解详尽，对主要知识点、案例进行了视频讲解，既适合教师课堂讲授，也适合学生自学。 . 联系实际，实用性强。本书所涉及的案例和习题均来源于实际工作与生活，熟练掌握这些案例与习题，可以应用其中的解题思路和方法来提高实际办公效率和高质量地应用相应办公软件。 . 内容丰富，结构清晰。本书可作为高等院校、高职院校办公自动化课程的教材或参考书，也可作为各类社会人员学习办公软件的自学读本。 全书分 3篇，共 13章。第 1篇为 Word高级应用，内容包括：第 1章 Word 2010基本操作、第 2章编辑文档格式、第 3章 Word图形和表格处理、第 4章 Word 2010文档排版、第 5章 Word长文档编辑排版和第 6章制作批量处理文档；第 2篇为 Excel高级应用，内容包括：第 7章 Excel 2010基本操作、第 8章编辑表格数据、第 9章 Excel数据计算与管理和第 10章 Excel图表分析；第 3篇为 PowerPoint高级应用，内容包括：第 11章 PowerPoint 2010基本操作、第 12 章形式多样的幻灯片和第 13 章演示文稿的动态效果与放映输出。全书每个章节讲解相关的知识和技能，以实例为主线进行任务实施和总结。 本书提供电子教案，并给出了书中所有案例对应的相关素材文档及视频讲解，这些资源均可以从出版社网站下载，网址为： www.hxedu.com.cn；也可以联系作者：张银南， zyn96@163.com或向出版社编辑（ hzh@phei.com.cn）索取。 本书由浙江科技学院张银南任主编，并负责全书的规划、统稿及各章的修改。龚婷完成第 1章和第 4章的编写工作，琚洁慧完成第 2章、第 3章和第 6章的编写工作，朱梅完成第 5章的编写工作，张银南完成第 7章至第 10章的编写工作，马杨珲完成第 11章至第 13章的编写工作，另外，陈萌（宁波工程学院）、唐云廷（宁波理工学院）、林征（温州医科大学）参与部分章节编写。参加本书视频录制的有张银南、龚婷、琚洁慧、马杨珲、朱梅、庄儿、楼宋江等。浙江大学城市学院作为联合申报单位，提供了部分材料，谢红霞老师参与了编写、校对工作。本教材的出版得到了罗朝盛教授的大力支持，在此一并表示感谢！ 由于时间仓促，加上编者水平所限，书中难免存在疏漏之处，我们真诚希望得到广大读者的批评指正。 编者 2019年 6月"