




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、EXCEL、WEXCEL、WORD和PPT在管理中的实战运用(Practical application of EXCEL, WEXCEL, WORD and PPT in management)training number:training program:Curriculum backgroundAccording to authoritative organization statistics, ordinary users only average 20% of the application software functions, once effectiveSoftware sk
2、ills training increases productivity by 25%, equivalent to 2000% of training roi. Effective training will be largeIt improves the efficiency of the trained staff and saves a lot of work time (which probably prevents a lot of overtime work).Excel, WORD and PPT are powerful tools, they use them for va
3、rious data management and analysis, documentTemplate, process, and the establishment of an eye-catching, extraordinary presentation of the report has become our daily workRong yi. This course is designed to enable students to master Excel in the financial, personnel, sales and other management workA
4、pplication and advanced technology, in the future work, less detours, with half the effort. Rich examples and classroom exercises make learningThe staff will rapidly increase their use of Excel, WORD and PPT within two days and will be convincing in their daily workEfficiency.Thought of thought, tho
5、ught of thought - thought of thoughtCurriculum contentObjective: to use the advanced functions and skills of EXCEL, to manage and optimize data structures, and to perform efficient data analysis,Report statisticsFirst, build table skillsMake sure the data is valid (accurate)Data validity settingsWhy
6、 are there some unnecessary lines printed out?Two, data security chapterSpecifies the protection of the specified cellWorksheet protectionWorkbook protectionOverall protection of documentsAutomatic save settingsThree, advanced application of the chartChart making of special effectsWhat chart would b
7、e better to use in situations?The making of composite drawingThe manufacture of biaxial drawingsFour, function examples explainRelative references, absolute references, and mixed references in formulas and functionsFunction nesting example to explainEach instance of the function class explains sever
8、al typical functions such as IF, SumifCountif, Rank, and query lettersFive, data management and analysisData breakdown and consolidation, ANNAutomatic sorting and custom sortingAutomatic filtering and advanced screeningEstablish nested taxonomyHow many sheets of similar structure are merged into a s
9、ingle table?Six. PivotTableBuild a PivotTable report based on the wizardAdd or delete management itemsUpdate PivotTable dataCustom data fieldCreate a regular and non interactive chart based on data in the PivotTableGoal: proficiency in the use of MS software in Office Word, rapid production of stand
10、ardized documents, and document templatesProcess oriented, able to share Word software and other software of Office to share information and cooperate with each other.The emphasis is on improving the skills of using Word software in practical work and improving work efficiency.The first chapter give
11、s custom mail to one hundred contactsPrepare contact listCreate a letter documentMerge the contact information into the correspondence documentCustomize the mail for each contactThe second chapter deals with the special processing of long documentsAdd headers and footers to the documentBookmark in a
12、 documentUse style to modify the format of the article in bulkQuickly jump to the specified location using the document structure diagramAdd directory to documentThe third chapter reviews documentsSend the document to the reviewerSet the revision statusAdd annotationEdit the content of the manuscrip
13、t using the revision statusThe fourth chapter deals with various advanced editing techniquesQuick setting document layoutMake each part of the document display different page formatsTo achieve, in order to simplify the generationInsert automatic drawingsAdvanced replacement, batch modificationJump f
14、rom one document to anotherDont copy how to insert other documents into the current documentI. overview of design techniquesThe PPT example demonstrates good PPT design guidelinesTwo basic skills of slide makingInterface introductionPresentation of various viewsCreate new slidesSlide layoutOutline p
15、roductionThree. Save and print the presentationFour, presentation style modificationRules of color matching between background and textSlide background settingsFive, powerful auxiliary meansIllustration rulesGraphical useDraw graphicsProcessing graphicsUse of picturesInsert clip artClip art changesC
16、hange directionThe use of artistic wordsNew art fontArt decorationSix, collaboration with other Office componentsInsert Excel chartInsert word formBuild linksSeven, the use of animation effectsCustom animation productionChart animationSlide switch animationTo use disposable fixed animation schemeExa
17、mples of several special animation effectsEight. Use background musicInsert music filesDefinition of musical timeNine, slide show skillsDemonstration skillsHide slidesAdjust the slide show sequenceCustom projectionTen, the overall perception of adjustment skillsIntegration and unification of various
18、 meansAdjust the sense of space, motion and ordertraining objects:The general manager, personnel manager, sales manager, production manager, financial manager and so on need to use Excel and PPT extensivelyPeople in all departments of the worktraining objectives:training fee: 1380 (unit: yuan) (Note
19、: price and course time, place, training channel, curriculum display page shall prevail. )instructor information:Chen Jun PMP engaged in education and training for thirteen years, more than 10 years of teaching practice on the skilled teaching skills. fromIn 1999, it began to focus on Microsofts fro
20、nt products. He lectured at the Microsoft classroom and the Microsoft MLC demo at Guangzhou.By the end of 1999, MS Office courses had been taught to improve office personnels computer application skills and office efficiencyFor fun,Has more than 2500 people from all walks of life who taught computer
21、 lessons by the participants alike.The training courses of OFFICE units are: Procter & Gamble, Mead Johnson, PHILPS, Ericsson, Jotun, the U.S. consulate in GuangzhouOcean paint and comfortable blade, Foshan Lehua Guangzhou Honda, KYOCERA Mita, Guangdong, Shenzhen, South Lijinji saltTian internationa
22、l container terminal, Guangdong mobile, Guangzhou Telecom, Hualing air-conditioning, real estate, radio Guangzhou Wenchong shipyard,Guangdong shipping group, Guangdong Development Bank and so on.Since 2003, new subjects have been added: Project Management & Ms Project. And talk about the modernizati
23、on of Microsoft classroomProject management &Project 2002/2003, in the past three years, more investment in the EPM direction, become the enterprise project managementManager EPM solution consultant.Characteristics of teaching:1., good at the function of the software and practical application of close integration, apply knowledge, digest2. vivid, easy to understand and love3., pay attention to the students feelings and feedback
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 【正版授权】 ISO/TR 24107:2024 EN Air quality - Validation of air quality measurement methods in the standardization process
- 【正版授权】 ISO 8000-115:2024 EN Data quality - Part 115: Master data: Exchange of quality identifiers: Syntactic,semantic and resolution requirements
- 2025年度地坪工程环保验收服务承包合同样本
- 2025年度汽车贷款担保合同会计处理与风险控制要点
- 2025年度法制副校长履职评价及激励措施合同
- 2025年度老旧城区拆除工程承包合同范本
- 2025感恩广场二期商铺投资合作协议
- 2025年白喉、百日咳、破伤风、乙肝四联制剂项目发展计划
- 文化机构安全隐患排查与防范计划
- 让孩子们爱上数学的活动安排计划
- 110KV送出线路工程施工组织设计方案和对策
- 二零二五年度大型自动化设备买卖合同模板2篇
- 城市交通系统中的空间正义问题-深度研究
- 2024版金矿居间合同协议书
- 2024年03月江苏2024年中国工商银行苏州分行社会招考笔试历年参考题库附带答案详解
- 2025年北师大新版高二物理上册阶段测试试卷
- 2024年青岛职业技术学院高职单招语文历年参考题库含答案解析
- GA/T 2145-2024法庭科学涉火案件物证检验实验室建设技术规范
- 2025内蒙古汇能煤化工限公司招聘300人高频重点提升(共500题)附带答案详解
- 《餐饮服务礼貌用语》课件
- 2025年中国融通资产管理集团限公司春季招聘(511人)高频重点提升(共500题)附带答案详解
评论
0/150
提交评论