本書根據(jù)“注重實踐、突出應(yīng)用”的指導(dǎo)思想編寫,主要內(nèi)容包括 Word 2010 高級應(yīng)用、 Excel 2010 高級應(yīng)用、PowerPoint 2010高級應(yīng)用和 Outlook與 VBA應(yīng)用。每章中都安排了具體案例,對主要知識點、案例進(jìn)行了視頻講解,通過詳細(xì)的案例操作幫助讀者掌握相關(guān)知識和培養(yǎng)相關(guān)技能。本書為浙江省普通高校“十三五”新形態(tài)教材,可作為應(yīng)用型本科院校和職業(yè)院校計算機(jī)公共課教材,也可作為各類培訓(xùn)機(jī)構(gòu)的培訓(xùn)教材和自學(xué)者參考書。
張銀南,男,副教授,作為副主編參與了6部高等學(xué)校教材的編寫工作,作為參編人員參與了多部高等學(xué)校教材的編寫工作!盾浖こ袒A(chǔ)教程》(副主編)、《軟件工程原理與應(yīng)用》(副主編,高等職業(yè)教育十一五規(guī)劃教材)、《計算機(jī)繪圖基礎(chǔ)》(副主編, 浙江省高等教育重點建設(shè)教材)、《C語言程序設(shè)計》(副主編,浙江省高等教育重點建設(shè)教材)、《C++程序設(shè)計(第2版)》(副主編)、《C語言程序設(shè)計》(主編,科學(xué)出版社優(yōu)秀教材二等獎)等
第 1篇 Word高級應(yīng)用 ···························1第 1章 Word 2010基本操作 ·····················2
本章要點·······································2案例展示·······································2基本知識講解·································3
1.1 Word 2010的窗口組成 ············3
1.2視圖模式 ·····························5案例和任務(wù)····································7案例 1新建“西冷文學(xué)社招新通知”文檔·······························7案例 2根據(jù)模板創(chuàng)建“求職簡歷”文檔····························· 14
任務(wù)制作“檔案管理制度”文檔 ··· 18本章小結(jié)····································· 20疑難解析(問與答) ······················ 20習(xí)題 ········································· 20
第 2章編輯文檔格式 ·······························23
本章要點····································· 23案例展示····································· 23基本知識講解······························· 25
2.1 設(shè)置字符格式
····················· 25
2.2 段落對齊方式
····················· 25
2.3 段落縮進(jìn)
··························· 25
2.4 附加段落控制
····················· 25
案例和任務(wù)·································· 26案例 1編輯“招聘啟事”文檔 ····· 26案例 2制作“使用說明書”文檔 ··· 29任務(wù)編輯“合作協(xié)議書”文檔 ···· 33
本章小結(jié)····································· 35疑難解析(問與答) ······················ 35
習(xí)題 ········································· 35
第 3章 Word圖形和表格處理··················38
本章要點····································· 38案例展示····································· 38基本知識講解······························· 39
3.1 選定圖形對象
····················· 39
3.2 環(huán)繞樣式
··························· 40
3.3
SmartArt圖形類型················ 40
3.4 設(shè)置表格尺寸
····················· 41
案例和任務(wù)·································· 41案例 1制作“產(chǎn)品介紹”文檔 ····· 41案例 2制作“面試流程指南”
文檔····························· 48案例 3制作“職工工資表”文檔····························· 55
任務(wù)制作“電子小報”文檔 ······· 61本章小結(jié)····································· 63疑難解析(問與答) ······················ 64習(xí)題 ········································· 64
第 4章 Word 2010文檔排版 ···················67
本章要點····································· 67案例展示····································· 67基本知識講解······························· 69
4.1
Word 2010中文檔紙張的規(guī)格································· 69
4.2 頁邊距
······························ 69
4.3樣式 ································· 70案例和任務(wù)·································· 71
案例 1制作“新網(wǎng)站推廣方案”文檔····························· 71
案例 2排版和打印“房地產(chǎn)市場調(diào)查報告”文檔 ·············· 78任務(wù)編輯排版“財務(wù)部工作計劃”
文檔 ······························· 85本章小結(jié)····································· 87疑難解析(問與答) ······················ 87習(xí)題 ········································· 88
第 5章 Word長文檔編輯排版··················91
本章要點····································· 91案例展示····································· 91基本知識講解······························· 92
5.1 Word文本的選定技巧 ··········· 92
5.2 Word的分隔符 ···················· 92案例和任務(wù)·································· 92案例 1編排“學(xué)生手冊”長文檔 ·························· 92案例 2編排和審!爱厴I(yè)論文”長文檔 ·························· 98任務(wù)編輯“個人信貸業(yè)務(wù)崗位
培訓(xùn)教材”文檔 ···············109本章小結(jié)····································114疑難解析(問與答) ·····················115習(xí)題 ········································116
第 6章制作批量處理文檔 ·····················122
本章要點····································122案例展示····································122基本知識講解······························123
6.
1郵件合并或數(shù)據(jù)文檔設(shè)置 ·····123
6.2數(shù)據(jù)文檔類型
····················123
案例和任務(wù)·································123案例 1制作邀請函 ···················123案例 2制作信封 ······················127任務(wù)制作并發(fā)送“成績單”
郵件 ······························128本章小結(jié)····································130疑難解析(問與答) ·····················130習(xí)題 ········································130
第 2篇 Excel高級應(yīng)用 ······················ 133第 7章 Excel 2010基本操作 ·················134
本章要點··································· 134案例展示··································· 134基本知識講解····························· 135
Excel 2010的窗口組成 ··············· 135案例和任務(wù)································ 137案例 1創(chuàng)建“年級周考勤表”工作簿 ························ 137案例 2制作“客戶資料表”電子
表格··························· 142案例 3打印“生產(chǎn)記錄表” ······ 145任務(wù)創(chuàng)建“人事檔案表” ········ 148本章小結(jié)··································· 151疑難解析(問與答) ···················· 151習(xí)題 ······································· 152
第 8章編輯表格數(shù)據(jù) ·····························154
本章要點··································· 154案例展示··································· 154基本知識講解····························· 155
Excel的編輯功能 ······················ 155案例和任務(wù)································ 158案例 1制作“學(xué)生入學(xué)信息表”
································· 158案例 2美化“課程表” ············ 162案例 3編輯“采購記錄表” ······ 165任務(wù)制作“蔬菜銷售表” ········ 169本章小結(jié)··································· 172疑難解析(問與答) ···················· 172習(xí)題 ······································· 173
第 9章 Excel數(shù)據(jù)計算與管理 ···············176
本章要點··································· 176案例展示··································· 176基本知識講解····························· 177
9.1
Excel公式與函數(shù) ··············· 177
9.2
Excel數(shù)據(jù)管理 ·················· 182
案例和任務(wù)·································183案例 1計算“成績總評分?jǐn)?shù)”表格數(shù)據(jù) ······················183案例 2計算“比賽打分成績表”表格數(shù)據(jù) ······················185案例 3管理“足球出線的確認(rèn)”數(shù)據(jù)····························191任務(wù)計算和管理“學(xué)生成績
登記表” ························198本章小結(jié)····································208疑難解析(問與答) ·····················208習(xí)題 ········································208
第 10章 Excel圖表分析 ························214
本章要點····································214案例展示····································214基本知識講解······························215
10.1圖表的有關(guān)術(shù)語 ················215
10.2數(shù)據(jù)透視表與數(shù)據(jù)透視圖 ····216案例和任務(wù)·································216案例 1制作“房產(chǎn)銷售業(yè)績表”圖表····························216案例 2分析“職工業(yè)績考核”表格····························221任務(wù) 1用圖表分析“學(xué)生期末成績表” ······················224任務(wù) 2用圖表分析“停車情況
記錄表” ······················231本章小結(jié)····································239疑難解析(問與答) ·····················239習(xí)題 ········································240
第 3篇 PowerPoint高級應(yīng)用 ·············249第 11章 PowerPoint 2010基本操作 ······250
本章要點····································250基本知識講解······························250 PowerPoint 2010概述··················250案例和任務(wù)·································251
案例 1創(chuàng)建“項目報告”演示文稿····························251
案例 2編輯“電子通知”演示文稿··························· 257任務(wù)制作“課程簡介”演示
文稿 ····························· 260本章小結(jié)··································· 262疑難解析(問與答)···················· 262習(xí)題 ······································· 262
第 12章形式多樣的幻燈片 ···················264
本章要點··································· 264基本知識講解 ····························· 264嵌入對象和 SmartArt圖形··········· 264案例和任務(wù)································ 264
案例 1編輯“公司會議”演示文稿··························· 264案例 2制作“生日賀卡”演示文稿··························· 268任務(wù)制作“活動匯報”演示
文稿 ····························· 271本章小結(jié)··································· 272疑難解析(問與答) ···················· 273習(xí)題 ······································· 273
第 13章演示文稿的動態(tài)效果與放映輸出 ······ 274
本章要點··································· 274基本知識講解 ····························· 274設(shè)置動態(tài)效果 ·························· 274案例和任務(wù)································ 275
案例 1制作“學(xué)唐詩”演示文稿··························· 275案例 2編輯“電子相冊”演示文稿··························· 280任務(wù) 1制作“浪漫婚禮”演示文稿··························· 284任務(wù) 2制作“微課件”演示
文稿···························