本书根据“注重实践、突出应用”的指导思想编写,主要内容包括 Word 2010 高级应用、 Excel 2010 高级应用、PowerPoint 2010高级应用和 Outlook与 VBA应用。每章中都安排了具体案例,对主要知识点、案例进行了视频讲解,通过详细的案例操作帮助读者掌握相关知识和培养相关技能。本书为浙江省普通高校“十三五”新形态教材,可作为应用型本科院校和职业院校计算机公共课教材,也可作为各类培训机构的培训教材和自学者参考书。
张银南,男,副教授,作为副主编参与了6部高等学校教材的编写工作,作为参编人员参与了多部高等学校教材的编写工作。《软件工程基础教程》(副主编)、《软件工程原理与应用》(副主编,高等职业教育十一五规划教材)、《计算机绘图基础》(副主编, 浙江省高等教育重点建设教材)、《C语言程序设计》(副主编,浙江省高等教育重点建设教材)、《C++程序设计(第2版)》(副主编)、《C语言程序设计》(主编,科学出版社优秀教材二等奖)等
第 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制作“微课件”演示
文稿···························