办公软件应用

办公软件应用 In this paper, by shimeili999 contribution Powerpoint documents may be a poor experience at the WAP end. It is recommended that you choose TXT, or download the source file to the native view. Office software application skills Speaker: zhou junjie: human resources department YGSOFT Inc. A combination of OFFICE and OFFICE software PowerPoint The Word OFFICE Excel Access Outlook 2 directory ppt 关于艾滋病ppt课件精益管理ppt下载地图下载ppt可编辑假如ppt教学课件下载triz基础知识ppt WORD EXCEL Q&A 3 directory PPT WORD EXCEL Q&A 4 PPT Powerpoint presentation skills 5 The main points of the PPT production The target Define the goals, objects, and presentation of the powerpoint logic Use the rigor of logic design Through the design of each page layout, make the overall beauty of the PPT, show its goal with better results layout Typography of the layout Use a variety of tools to support its business logic. By analyzing the business logic, select the best mode of output, making the point of the powerpoint presentation prominent and progressive making style After accumulation, forming style 6 The main points of the PPT production What is the target for what people want to achieve 7 Bullet points - goals Application scope of work progress report target record process, sum up experience and problems, to list the next step plan According to the existing problems, propose solutions, implementation plan, for the upper, the customer approval Let the training objects to understand the project progress schedule, work task list, cost budget,... ... Object management one or a few people management one or a few people a non-professional professional management one or a few people display personal review panel Individual review panel report dozens of people a few hundred individuals review panel Scheme demonstration Training program For PPT goals, objects and places, choose different goals, objects and places, according to the goal of logic, layout and space, logic, layout and space, in order to achieve the best effect of 8 The main point of powerpoint: logic PPT to have a clear, concise logic, so use "and" best PPT to have a clear, concise logic, so, had better use "with" or "progressive" two categories Be clear and progressive "logic. Logic relationship. Must be through the different levels" title "layered, marked the entire powerpoint presentation logic relationship Must be "title" stratified by different levels, indicating the PPT PPT by using the principle of the pyramid logical combing logic relations 9 The main point of the powerpoint presentation -- the logic of the pyramid 10 The main points of powerpoint: layout A single slide layout should have free space, want to have a sense of balance. A single slide layout should have free space, want to have a sense of balance. PPT have a title page, the text, the end page three slides; Structuring them, there is a title page, body, and end page slides; Structured, they reflect your logic have a title page Between each chapter, insert a blank slide or title slide, between each chapter, insert a blank slide or slides, title makes can reflect the administrative levels between sections By category, by category, hierarchical structured content 11 Bullet points - layout Chart: chart: 1, use charts in charts, graphs can express the problem of hard to describe, can cause strong words describe the effect of 2, associate images cannot too much, too bright-coloured, seeks flowery easily dispersed the viewer's attention processing A product sales August 1, 2003 50,000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000, 000 38,536, 32,165, 32,32,32,655, 23,11,511,563 12 Bullet points - layout Text 1, the recommendation USES song body and black body character, the display effect of other type is not good 2, the title, body should choose different size, otherwise apply color distinction No. 20, no. 10, no. 20, no. 20, no The official script of the song body is a black body Song typeface Song typeface Song typeface Song typeface Song typeface Song typeface Song typeface Official script Official script Official script Official script Official script Official script Official script Regular script Regular script Regular script Regular script Regular script Regular script Regular script blackbody blackbody blackbody blackbody blackbody blackbody blackbody 13 Bullet points - layout Color 1, the whole powerpoint, including the chart, preferably not more than 4 colors. 2, foreground and background should be contrasting colors 14 The point of powerpoint: style Learn from good PPT style, layout and color. Learn from good PPT style, layout and color. The style of the PPT Collecting material, collecting materials, establish the toolkit Through layout, layout design, through the layout, the design of the layout, form their own unique style 15 PPT Powerpoint presentation skills 16 Powerpoint presentation skills Make good use of the template Follow the content prompt wizard to create new builds based on the existing presentation Save the skills WEB page - extract image pot-template PPS - automatically show jpg-images to make the presentation small 17 Powerpoint presentation skills Turn the slide into word document and turn the slide into word Send function Count the words and paragraphs "The file" goes to the property, "to the statistics." Add a powerpoint presentation to your "powerpoint" "Tools", "options", "edit", "can cancel operands" 18 Powerpoint presentation skills Mother's version of use The personalized mother page inserts the page header... Quickly call other slides and call other slides "Insert" to "slide (from file)" The tree structure diagram is made by using a powerpoint presentation "Insert", "picture", "org chart" 19 Powerpoint presentation skills Select multiple objects quickly The triangle arrow to the right of the "drawing" toolbar goes to "add or delete" to "draw" to "select multiple pairs of images" Insert the diagram into the object Insert EXCEL into powerpoint - automatic thumbnail effects 20 Powerpoint presentation skills Change the default color of the link text "Format", "slide design", "edit color scheme..." "Self-definition" Flexible background "Format", "background", "ignore mother's background image" Use the image file as the project symbol "Format", "item symbol and number", "picture" 21 Powerpoint presentation skills Window mode plays the powerpoint window mode Hold Alt and press "D", "V" The powerpoint editor shows two non-mis-edited screenings Hold down Ctrl and click on the "slide show" menu In the powerpoint, the view happens to switch The Shift key 22 Powerpoint presentation skills Switch only by using the arrow keys The task pane - "slide switch" - cancel "click", "every" all slides "tools" - > "option - > view - > cancel" right-click on the shortcut menu "to apply to Quick fix slide The digital key + enter. Returns to the first slide from any location: press the left mouse button and stay for more than two seconds 23 Powerpoint presentation skills Easy to hide part of the slide Click on the slide to hide, right mouse right to "hide the slide" Use the brush to do the tag and click the right mouse button, "pointer option - drawing" Automatic black and white screen "B" key black screen "W" key white screen Use the combination key to generate content profiles to select multiple slides to Alt + shift + s 24 directory PPT WORD EXCEL Q&A 25 WORD of the operation skills A save/close multiple open file SHIFT quick access to commonly used document "tools - > custom" - > "command" - > "built-in menu" - > "work" delete: "Ctrl + Alt + - (dash)" quickly switch between multiple documents "tool to custom, the command" - > "all orders" - > "NextWindow", "PrevWindow" 26 WORD of the operation skills Quickly find file "file - > open" - > "tools" - > "find" quick to convert the case Numbers "insert - digital input in the Chinese year".through "insert - > date and time" 27 WORD of the operation skills Quickly copy the text Selected text, hold down the Ctrl key and hold the left mouse button drag and drop Quickly checked all repeat the word in the document "edit - > search" - to enter search words or phrases - "highlight all found in the scope of the project" - > "for all" using the F8 key selected text quickly press F8 function keys (or double-click the "extension" in the status bar text), activate the "extension" state (the "extension" button in the status bar into activated form) 28 WORD of the operation skills Create a style peculiar horizontal line And press the enter key to enter the following symbol. 3 a hyphen to generate fine black line 3 underline generated bold black line = = = 3 = "generated double fine black line # # # # 3 Wells with thin line between a bold black line * * * the asterisk involves three line ~ ~ ~ 3 approximately equal to generate wavy lines 29 WORD of the operation skills Quickly return the position Shift + F5 from the last edit to replace the text "*" with a wildcard "*" for multiple characters, "?" Said a character "edit - > replace" - "to find the content" enter the wildcard - using the mouse to click "replaced by" - > "advanced" - set format - all replaced. Use autotext automate repetitive typing job Choose the words - "autotext" - "new" 30 WORD of the operation skills Quickly build up, subscript: "Ctrl + = (equals)"; The superscript: "Ctrl + shift+ + (+)" makes your column header visible "table to header row" and "Ctrl + Shift + Enter" at the top of the table. 31 WORD of the operation skills Let the word count results displayed on the screen at any time "tools - > word count" - > "display toolbar" button layout adjustment tool Hold down the Alt key and drag the toolbar button Add a hyperlink to a toolbar button "tools - > custom" - > right click on the toolbar "insert hyperlinks" - > "assigned hyperlinks to open" - > "search scope to choose the need to add" link (can be application, a clamp, specific file) 32 WORD of the operation skills Protect form mail merge page layout 33 directory PPT WORD EXCEL Q&A 34 The operation of the EXCEL skills The basic function in the menu bar Shortcuts usage Settings: & representative Alt, ^ representative Ctrl PivotTable worksheet protection commonly used functions 35 Q&A Software drives management services close to the user YGSOFT Inc. Service hotline: 8 00-8 3 0-3 30 0 36 one