Wuhan Optical Valley Bird International Executive Training

Computer Knowledge · windows operating · Chinese and English typing, Wubi input method, etc. · internet-based word2003 / 2007/2010 word processing Wuhan word processing text training new features introduced · Add preset format · immediate application of the new look for documents Easily avoid spelling mistakes * Shared Documents · quickly compare two versions of a document · Find and delete documents hidden metadata and personal information ? Adding digital signature to a document or signature rows and prevent changes to the document and the final version of the document * business information to connect Wuhan excle spreadsheet training basic text editing operations · · a variety of ways to select and view the selected text * Paste of use · review, comments and revisions under different views · View Gavin windows side by side comparison · Spell checking, grammar and word count · Find and Replace Advanced Find and Replace wildcards to find and replace formatting find and replace special characters Find and Replace Wuhan ppt slides training typesetting and layout · · formatted document page layout setting method ? Create a header and how to set page footer · · How to add borders and shading to the document · Add footnote endnote · Simplified and Traditional conversion functions ? Set Bullets and Numbering ? Styles and Templates integrated application Calendar · Create a directory Wuhan ppt slides training form application forms and create and format charts formula · table · table calculation · Table AutoFormat · Add graphic objects · table in the table layout · charts and documents produced results table shuffling · · making contact Karl homemade excel2003 / 2007/2010 spreadsheet, word text Wuhan calendar · · Install Equation Editor Equation Editor · Calendar · math processing training new features introduced · office theme and excel conditional formatting style * Rich Easily write formulas Improved sorting New methods and filtering features new charts look · Easy to use PivotTable ? New file format - better printing experience · shared chart · · fast connection to an external data sharing work training Wuhan excle spreadsheet workbook worksheet Use the worksheet to strengthen the group's establishment · Mobile Copy Input Method and worksheet worksheet group data: The Move and Copy * worksheets between workbooks with mobile copy / different between workbooks: Background Fill / hide worksheet and worksheet fields Hide / split window and freeze Split Window / worksheet data entry skills / Auto Fill / ranks exchange / data in different formats fast input method Wuhan ppt slides training formulas and functions · formulas using operators: Arithmetic operators / comparison / Text operator / dereference operator * cell references: a different worksheet references / absolute references / relative references / mixed references · Function instance: if / count / rand / sumif Wuhan ppt slides training GraphChart application to create a chart: Select the chart type / specified data source / set chart options / OK chart location chart data and treatment: add / remove chart data / change the order of the data series / Chart text editor ? Set the chart format: Move the chart, copy and delete / Chart Zoom / change the chart type / formatted / title of each chart elements, data labels Wuhan ppt slides trained to use the database * Filters: Auto Filter / Custom Filter / Advanced Filter · Sort by: Simple sort / sort by multiple columns / row sorting / custom sorting · subtotal: Create subtotals / create nested multilevel subtotals / outline worksheet / remove subtotals · PivotTable: Create a calculated field / draw dynamic charts powerpoint2003 / 2007/2010 slide Wuhan word processing word word processing training · Text Input and edit various views of a slide file format, based on the contents of the logical structure · New Presentation Wizard prompts Wuhan Training ppt slide layout changes · edit Master · Slide Master Handout Master * * Notes Master * * Application header and footer color schemes · custom color scheme * transfer slide color scheme * Application design templates * Application of other design templates ? Create new templates · Custom Background Wuhan training ppt slides produce special effects (2 hours) * Rehearse · Hide Slide Show · · Set custom slide transition mode settings · animate · Slide piece Wuhan ppt slide presentation skills training to create a table charting slide · slide · excel spreadsheet data embedded · · can simply introducing updated in real time using data excel data into · · Establishment chart data directly into excel data sheet ? Between excel and data tables built using · Art Photos Links · graphics · Drawing toolbar processing ? Establishing organizational structure Artistic word · · call other auxiliary production tools · chart, color settings