EXCEL、WEXCEL、WORD和PPT在管理中的实战运用（Practical application of EXCEL, WEXCEL, WORD and PPT in management）

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