本书精选具有代表性的实用案例，图文并茂地讲解了各案例的详细操作步骤。每个案例中任务要求的设置都能体现章节的主要知识点。各个案例之间循序渐进、由易到难，具有层次性和针对性。本书共分为两部分，第一部分为办公软件高级应用，包含 Word高级应用、Excel高级应用、 PowerPoint高级应用；第二部分为多媒体技术应用，包含多媒体技术基础、图像编辑与处理 Photoshop、动画设计与制作 Flash、音频编辑与处理 Audition和视频编辑与集成 Premiere。本书可作为高等院校的“办公软件高级应用”“多媒体应用”“计算机应用高级教程”等课程的实践教材，也可作为其他技术人员的自学参考书

叶苗群，女，讲师，就职于宁波大学，大学毕业后一直在宁波大学就职，主要教授计算机基础及办公自动化等课程的教学。

第一部分 办公软件高级应用 第 1章 Word高级应用···········································································3 1.1 Word 2010相关知识 ..........................................................................................3 1.1.1视图......................................................................................................3 1.1.2 样式......................................................................................................6 1.1.3 目录......................................................................................................9 1.1.4索引 ...................................................................................................12 1.1.5脚注与尾注........................................................................................16 1.1.6页眉与页脚........................................................................................16 1.1.7题注与交叉引用................................................................................16 1.1.8分节 ...................................................................................................17 1.1.9 域........................................................................................................18 1.2案例一 制作高校录取通知书......................................................................23 1.3 案例二 多人协同编辑文档..........................................................................31 1.4 案例三 索引与书签 .....................................................................................36 1.5 案例四 毕业论文综合排版..........................................................................42 1.6 案例五 Word VBA制作选择题.....................................................................56 习题..........................................................................................................................62 第 2章 Excel高级应用······································································· 64 2.1 Excel 2010相关知识 ........................................................................................64 2.1.1 单元格引用........................................................................................64 2.1.2 数组公式............................................................................................64 2.1.3 高级筛选............................................................................................65 2.1.4数据透视表与透视图........................................................................66 2.1.5常用函数............................................................................................68 2.2案例一学生成绩统计.................................................................................83 2.3案例二教工信息管理.................................................................................92 2.4案例三个人理财管理...............................................................................101 2.5案例四手机市场调查问卷.......................................................................106 2.6案例五学生成绩管理系统.......................................................................114 习题........................................................................................................................123 第 3章 PowerPoint高级应用 ·························································· 127 3.1PowerPoint 2010相关知识 .................................................................................127 3.1.1演示文稿和幻灯片..........................................................................127 3.1.2主题..................................................................................................128 3.1.3母版..................................................................................................129 3.1.4动画..................................................................................................129 3.2案例一 宁波东钱湖简介 ................................................................................ 130 3.3案例二 计算机基础考试 ................................................................................ 141 习题........................................................................................................................148 第二部分 多媒体技术应用 第 4章 多媒体技术基础···································································· 152 4.1多媒体技术的基本概念 ...............................................................................152 4.1.1媒体 .................................................................................................152 4.1.2多媒体技术......................................................................................153 4.2 多媒体计算机系统.......................................................................................154 4.2.1 多媒体硬件系统..............................................................................154 4.2.2 多媒体软件系统...............................................................................155 4.3 多媒体中的媒体元素及特征.......................................................................156 4.4 多媒体数据压缩技术...................................................................................157 4.5 多媒体技术应用软件...................................................................................159 习题........................................................................................................................159 第 5章 图像编辑与处理——Photoshop ········································· 161 5.1 图像基础知识 ...............................................................................................161 5.1.1 图形和图像......................................................................................161 5.1.2 图像的基本属性 ..............................................................................163 5.1.3 色彩..................................................................................................163 5.1.4 颜色模式..........................................................................................164 5.1.5 图像数字化 ......................................................................................166 5.1.6 图像文件格式 ..................................................................................167 5.1.7 图像编辑软件..................................................................................169 5.2 Photoshop CS5相关知识..............................................................................169 5.2.1 常用工具...........................................................................................169 5.2.2图层...................................................................................................177 5.2.3 路径...................................................................................................181 5.2.4 图像的变换.......................................................................................183 5.2.5蒙版...................................................................................................186 5.2.6通道...................................................................................................192 5.2.7Photoshop快捷键..............................................................................195 5.3 案例一 快乐小天使...................................................................................196 5.4 案例二 显示器广告...................................................................................204 5.5 案例三 特效边框.......................................................................................207 5.6 案例四 雨景效果.......................................................................................210 5.7 案例五 动态水波效果...............................................................................212 5.8 案例六 渐隐的图像效果...........................................................................219 5.9 案例七 光盘盘贴.......................................................................................221 5.10 案例八 旋转文字 .....................................................................................223 5.11 案例九 汽车海报 ......................................................................................225 5.12 案例十 雄鹰展翅 .....................................................................................228 习题........................................................................................................................230 第 6章 动画设计与制作——Flash ················································· 234 6.1 动画基础知识 ...............................................................................................234 6.1.1 动画基本概念..................................................................................234 6.1.2 动画的原理......................................................................................234 6.1.3 动画的分类......................................................................................235 6.1.4 动画制作流程..................................................................................235 6.1.5 动画文件格式 ..................................................................................236 6.1.6 动画制作软件 ..................................................................................237 6.2 Flash CS5.5相关知识....................................................................................237 6.2.1 Flash界面 .........................................................................................237 6.2.2帧.......................................................................................................240 6.2.3图层...................................................................................................242 6.2.4元件...................................................................................................243 6.2.5对象...................................................................................................244 6.2.6 逐帧动画...........................................................................................245 6.2.7 形状补间动画...................................................................................245 6.2.8传统补间动画...................................................................................246 6.2.9补间动画...........................................................................................247 6.2.10引导动画 ........................................................................................248 6.2.11遮罩动画........................................................................................250 6.2.12 Flash快捷键 ...................................................................................252 6.3 案例一旋转的风车...................................................................................253 6.4 案例二动态书写文字...............................................................................258 6.5 案例三图片遮罩效果...............................................................................262 6.6 案例四放大镜...........................................................................................264 6.7 案例五 红星闪闪.......................................................................................269 6.8 案例六月球绕地球转...............................................................................271 6.9 案例七兔子跑步.......................................................................................274 6.10 案例八 移动的球 .....................................................................................278 6.11 案例九 文字特效 ......................................................................................280 6.12 案例十 拼图游戏 .....................................................................................282 习题........................................................................................................................287 第 7章 音频编辑与处理——Audition ··········································· 291 7.1 音频基础知识................................................................................................291 7.1.1 音频的基本概念..............................................................................291 7.1.2 音频数字化......................................................................................292 7.1.3 音频文件格式..................................................................................293 7.1.4 常用声音编辑软件..........................................................................295 7.2Adobe Audition CS6简介..............................................................................296 7.3案例 古诗录制编辑配乐.............................................................................297 习题........................................................................................................................305 第 8章 视频编辑与集成——Premiere ··········································· 307 8.1 视频基础知识 ...............................................................................................307 8.1.1 视频概述..........................................................................................307 8.1.2 视频的采集和处理..........................................................................308 8.1.3 视频信息表示..................................................................................308 8.1.4 视频文件格式..................................................................................309 8.1.5 常用的视频编辑软件......................................................................311 8.2 Adobe Premiere CS6简介 ............................................................................311 8.3 案例一十二生肖视频制作.......................................................................312 8.4 案例二微机组装.......................................................................................322 习题........................................................................................................................327 参考文献································································································ 329