How_to

| Microsoft Office 2007 | How-To of Microsoft Office 2007 | | | 8/8/2007 | Table of Contents Using this Manual 10 Disclaimer 10 Table of Contents 10 Changes/Modifications 10 Print 10 Microsoft Office Word 2007 11 Help 11 Toolbars 11 File Toolbar 11 Create a New Document 12 Open 13 Save 14 A New Document 14 An Existing Document 14 Save As 14 Print 15 Quick Access Toolbar 16 Add Items to Quick Access Toolbar 16 Create a New Document 18 Open 18 Save 18 A New Document 18 An Existing Document 19 Tabs 19 Home Tab 19 Clipboard 20 Font 20 Paragraph 20 Styles 20 Editing 21 Insert Tab 21 Pages 21 Tables 22 Illustrations 22 Links 22 Header & Footer 22 Text 23 Symbols 23 Page Layout Tab 23 Themes 23 Page Setup 24 Page Background 24 Paragraph 24 Arrange 25 References Tab 25 Table of Contents 25 Footnotes 25 Citations & Bibliography 26 Captions 26 Index 26 Table of Authorities 27 Mailings Tab 27 Create 27 Start Mail Merge 27 Write & Insert Fields 28 Preview Results 28 Finish 28 Review Tab 29 Proofing 29 Comments 29 Tracking 30 Changes 30 Compare 30 Protect 31 View Tab 31 Document Views 31 Show/Hide 31 Zoom 32 Window 32 Macros 32 Add-Ins Tab 33 Menu Commands 33 Pictures 33 Accessing the Format Tab 33 Format Tab 33 Adjust 33 Picture Styles 34 Arrange 34 Size 34 Microsoft Office Excel 2007 35 Help 35 Toolbars 35 File Toolbar 35 Quick Access Toolbar 36 Add Items to Quick Access Toolbar 36 Tabs 38 Home Tab 38 Clipboard 38 Font 38 Alignment 39 Number 39 Styles 39 Cells 40 Editing 40 Insert Tab 40 Tables 41 Illustrations 41 Charts 41 Links 41 Text 42 Page Layout Tab 42 Themes 42 Page Setup 43 Scale to Fit 43 Sheet Options 43 Arrange 43 Formulas Tab 44 Function Library 44 Defined Names 44 Formula Auditing 45 Calculation 45 Data Tab 45 Get External Data 46 Connections 46 Sort & Filter 46 Data Tools 47 Outline 47 Review Tab 47 Proofing 47 Comments 48 Changes 48 View Tab 48 Workbook Views 49 Show/Hide 49 Zoom 49 Window 50 Macros 50 Add-Ins Tab 50 Menu Commands 51 Microsoft Office PowerPoint 2007 51 Help 51 Toolbars 52 File Toolbar 52 Quick Access Toolbar 53 Add Items to Quick Access Toolbar 53 Tabs 55 Home Tab 55 Clipboard 55 Slides 55 Font 56 Paragraph 56 Drawing 56 Editing 57 Insert Tab 57 Tables 57 Illustrations 57 Links 58 Text 58 Media Clips 58 Design Tab 59 Page Setup 59 Themes 59 Background 59 Animations Tab 60 Preview 60 Animation 60 Transition to this Slide 61 Slide Show Tab 61 Start Slide Show 61 Set Up 61 Monitors 62 Review Tab 62 Proofing 62 Comments 63 Protect 63 View Tab 63 Presentation Views 63 Show/Hide 64 Zoom 64 Color/Grayscale 64 Window 65 Macros 65 Add-Ins Tab 65 Menu Commands 66 Microsoft Office Access 2007 66 Help 66 Toolbars 67 File Toolbar 67 Quick Access Toolbar 68 Add Items to Quick Access Toolbar 68 Tabs 70 Home Tab 70 Views 70 Clipboard 70 Font 71 Rich Text 71 Records 71 Sort & Filter 72 Find 72 Create Tab 72 Tables 73 Forms 73 Reports 73 Other 74 External Data Tab 74 Import 74 Export 75 Collect Data 75 SharePoint Lists 75 Database Tools Tab 76 Macro 76 Show/Hide 76 Analyze 77 Move Data 77 Database Tools 77 Add-Ins Tab 78 Menu Commands 78 Form Layout Tools 78 Format Tab 78 Views 79 Font 79 Formatting 79 Gridlines 80 Controls 80 AutoFormat 80 Using this Manual Please read the Disclaimer before using the information in this manual. Disclaimer While every reasonable precaution has been taken in the preparation of this document, neither the author nor Allen University assumes responsibility for damages resulting from the use of the information contained herein. The information contained in this document is believed to be accurate. However, no guarantee is provided. Use the information provided in this manual at your own risk. Table of Contents To go directly to a title listed in the Table of Contents, press and hold the Ctrl key on your keyboard and click on the title Changes/Modifications This manual is read-only. You will not be able to make any changes. If you see that there is something that needs to modified, please contact Information Technology. Print This manual can be printed for personal, educational use. Microsoft Office Word 2007 Help To access Help, click the in the top right-hand corner of the Microsoft Office Word 2007 screen. The Word Help box will open. Enter the search criteria. Toolbars File Toolbar The File Menu allows you to create a new document, open an existing document, save a document, print a document, prepare a document, send a document, publish a document, or close a document. A list of your recent documents will be displayed. Also, you can set Word Options and Exit Word. To see a list of File Menu options, click Create a New Document * Click and select * In the New Document dialog box that pops up, select Blank document * Click Create * A new document will open Open * Click and select * In the Open dialog box that pops up, navigate to the location of the file you want to open * Single-click on the file * The file’s name will appear in the File name field * Click Open * The document will open Save A New Document * Click and select * In the Save As dialog box that pops up, enter a name for the file in the File name field * Click Save * The document will save An Existing Document * Click and select * The document will save Save As * Click and select * In the Save As dialog box that pops up, enter a name for the file in the File name field or select a file name from the list of file names displayed * WARNING: If you select a name from the list of file names displayed, the original document will be overwritten (deleted) with the one you are currently saving * Click Save * The document will save Print * Click and select * In the Print dialog box that pops up, select a printer in the Name field * Select your print options * Click OK * The document will print to the printer you selected Quick Access Toolbar The Quick Access Toolbar gives you quick access to different functions. Add Items to Quick Access Toolbar * Click the next to the Quick Access Toolbar * Single-click on the item you want to add to the Quick Access Toolbar * If an item is not listed, single-click on More Commands * In the left pane, single-click on the items you want to add to the Quick Access Toolbar * Click Add * The items selected will appear in the right pane * Click OK * The box will close and the items selected will appear on the Quick Access Toolbar Create a New Document * Click on the Quick Access Toolbar * A new document will open Open * Click on the Quick Access Toolbar * In the Open dialog box that pops up, navigate to the location of the file you want to open * Single-click on the file * The file’s name will appear in the File name field * Click Open * The document will open Save A New Document * Click on the Quick Access Toolbar * In the Save As dialog box that pops up, enter a name for the file in the File name field * Click Save * The document will save An Existing Document * Click on the Quick Access Toolbar * The document will save Tabs In some cases, it may be necessary to click the or the to open up additional menu items. Home Tab Features: * * Clipboard * Font * Paragraph * Styles * Editing Clipboard Features: * * Paste * Cut * Copy * Format painter Font Features: * * Font * Font style (bold, italics, underline) * Font size * Font color * Underline style * Character spacing * Effects (subscript, superscript, strikethrough, engrave, etc) * Text highlight Paragraph Features: * * Bullets * Indentation * Sort * Show/Hide * Align text * Line spacing * Shading * Borders * Outline level * Pagination * Textbox options Styles Features: * Styles Editing Features: * * Find * Replace * Select Insert Tab Features: * * Pages * Tables * Illustrations * Links * Header & Footer * Text * Symbols Pages Features: * * Cover page * Blank page * Page break Tables Features: * * Tables Illustrations Features: * * Picture * Clip art * Shapes * SmartArt * Chart Links Features: * * Hyperlink * Bookmark * Cross-reference Header & Footer Features: * * Header * Footer * Page number Text Features: * * Text box * Quick parts * WordArt * Drop cap * Signature line * Date & time * Object Symbols Features: * * Equation * Symbol Page Layout Tab Features: * * Themes * Page setup * Page background * Paragraph * Arrange Themes Features: * * Themes * Colors * Fonts * Effects Page Setup Features: * * Margins * Orientation * Size * Columns * Breaks * Line numbers * Hyphenation * Paper size * Paper source * Section * Headers and footers * Page Page Background Features: * * Watermark * Page color * Page borders Paragraph Features: * * Indentation * Spacing * Pagination * Textbox option Arrange Features: * Position * Bring to front * Send to back * Text wrapping * Align * Group * Rotate References Tab Features: * * Table of contents * Footnotes * Citations & bibliography * Captions * Index * Table of authorities Table of Contents Features: * * Table of Contents * Add text * Update table Footnotes Features: * * Insert footnote * Insert endnote * Next footnote * Show notes * Format Citations & Bibliography Features: * * Insert citation * Manage sources * Style * Bibliography Captions Features: * * Insert caption * Insert Table of Figures * Update table * Cross-reference Index Features: * * Mark entry * Insert index * Update index Table of Authorities Features: * * Mark citation * Insert Table of Authorities * Update table Mailings Tab Features: * * Create * Start mail merge * Write & insert fields * Preview results * Finish Create Features: * * Envelopes * Labels Start Mail Merge Features: * * Start mail merge * Select recipients * Edit recipient list Write & Insert Fields Features: * * Highlight merge fields * Address block * Greeting line * Insert merge field * Rules * Match fields * Update labels Preview Results Features: * * Preview results * Find recipient * Auto check for errors Finish Features: * * Finish & merge Review Tab Features: * * Proofing * Comments * Tracking * Changing * Compare * Protect Proofing Features: * * Spelling & grammar * Research * Thesaurus * Translate * Translation ScreenTip * Set language * Word count Comments Features: * * New comment * Delete * Previous * Next Tracking Features: * * Track changes * Balloons * Final showing markup * Show markup * Reviewing pane Changes Features: * * Accept * Reject * Previous * Next Compare Features: * * Compare * Show source documents Protect Features: * * Protect document View Tab Features: * * Document views * Show/Hide * Zoom * Window * Macros Document Views Features: * * Print layout * Full screen reading * Web layout * Outline * Draft Show/Hide Features: * * Ruler * Gridlines * Message bar * Document map * Thumbnails Zoom Features: * * Zoom * 100% * One page * Two pages * Page width Window Features: * * New window * Arrange all * Split * View side by side * Synchronous scrolling * Reset window position * Switch windows Macros Features: * * Macros Add-Ins Tab Features: * * Menu command Menu Commands Features: * * Bluetooth Pictures Accessing the Format Tab * Single-click on the picture * The Picture Tools menu will display on the toolbar * Single-click on Format Format Tab Features: * * Adjust * Picture styles * Arrange * Size Adjust Features: * * Brightness * Contrast * Recolor * Compress pictures * Change picture * Reset picture Picture Styles Features: * * Picture shape * Picture border * Picture effects * Fill * Line color * Line style * Shadow Arrange Features: * * Position * Bring to front * Send to back * Text wrapping * Align * Group * Rotate Size Features: * * Crop * Height * Width * Scale * Alternative text Microsoft Office Excel 2007 Help To access Help, click the in the top right-hand corner of the Microsoft Office Excel 2007 screen. The Excel Help box will open. Enter the search criteria. Toolbars File Toolbar The File menu allows you to create a new workbook, open an existing workbook, save a workbook, print a workbook, prepare a workbook, send a workbook, publish a workbook, or close a workbook. A list of your recent documents will be displayed. Also, you can set Excel Options and Exit Excel. To see a list of File menu options, click Quick Access Toolbar The Quick Access Toolbar gives you quick access to different functions. Add Items to Quick Access Toolbar * Click the next to the Quick Access Toolbar * Single-click on the item you want to add to the Quick Access Toolbar * If an item is not listed, single-click on More Commands * In the left pane, single-click on the items you want to add to the Quick Access Toolbar * Click Add * The items selected will appear in the right pane * Click OK * The box will close and the items selected will appear on the Quick Access Toolbar Tabs In some cases, it may be necessary to click the or the to open up additional menu items. Home Tab Features: * * Clipboard * Font * Alignment * Number * Styles * Cells * Editing Clipboard Features: * * Paste * Cut * Copy * Format painter Font Features: * * Font * Font style (bold, italics, underline) * Font size * Font color * Underline style * Effects (subscript, superscript, strikethrough) * Border * Fill color Alignment Features: * * Text alignment * Orientation * Text control * Right-to-left * Increase/decrease indent * Wrap text * Merge & center Number Features: * * Number format * Accounting number format * Percent style * Comma style * Increase/decrease decimal Styles Features: * * Conditional formatting * Format as table * Normal, good, bad, and neutral * Data and model * Titles and headings * Themed cell styles Cells Features: * * Insert cells * Delete cells * Format Editing Features: * * AutoSum * Fill * Clear * Sort & filter * Find & select Insert Tab Features: * * Tables * Illustrations * Charts * Links * Text Tables Features: * * Insert PivotTable * Table Illustrations Features: * * Insert picture from file * Clip Art * Shapes * Insert SmartArt graphic Charts Features: * * Column * Line * Pie * Bar * Area * Scatter * Stock * Surface * Doughnut * Other charts Links Features: * * Insert hyperlink Text Features: * * Text box * Header & footer * WordArt * Signature line * Insert object * Symbol Page Layout Tab Features: * * Themes * Page setup * Scale to fit * Sheet options * Arrange Themes Features: * * Themes * Theme colors * Theme fonts * Theme effects Page Setup Features: * * Margins * Page orientation * Page size * Print area * Breaks * Background * Print titles Scale to Fit Features: * * Width * Height * Scale Sheet Options Features: * * View gridlines * Print gridlines * View headings * Print headings Arrange Features: * * Bring to front * Send to back * Selection pane * Align * Group * * Rotate Formulas Tab Features: * * Function library * Defined names * Formula auditing * Calculation Function Library Features: * * Insert function * AutoSum * Recently used * Financial * Logical * Text function * Date & time * Lookup & reference * Math & trig * Average * Count numbers * More functions Defined Names Features: * * Name manager * Define name * Use in formula * Create from selection Formula Auditing Features: * * Trace precedents * Trace dependents * Remove all errors * Show formulas * Error checking * Evaluate formula * Watch window Calculation Features: * * Calculation options * Calculate now * Calculate sheet Data Tab Features: * * Get external data * Connections * Sort & filter * Data tools * Outline Get External Data Features: * * Get external data from Access * Get external data from web * Get external data from text * Get external data from other sources * Get external data using an existing connection Connections Features: * * Refresh all * Connections * Data range properties * Edit links Sort & Filter Features: * * Sort * Filter * Clear * Reapply * Advanced Data Tools Features: * * Text to columns * Remove duplicates * Data validation * Consolidate * What-if analysis Outline Features: * * Group * Ungroup * Subtotal * Show detail * Hide detail Review Tab Features: * * Proofing * Comments * Changes Proofing Features: * * Spelling * Research * Thesaurus * Translate Comments Features: * * New comment * Delete comment * Previous * Next * Show/hide comment * Show all comments * Show ink Changes Features: * * Protect sheet * Protect workbook * Share workbook * Protect and share workbook * Allow users to edit ranges * Track changes View Tab Features: * * Workbook views * Show/hide * Zoom * Window * Macros Workbook Views Features: * * Normal view * Page layout view * Page break preview * Custom view * Toggle full screen view Show/Hide Features: * * Ruler * View gridlines * Message bar * Formula bar * View headings Zoom Features: * * Zoom * 100% * Zoom to selection Window Features: * * New window * Arrange all * Freeze panes * Split * Hide window * Unhide window * View side by side * Synchronous scrolling * Reset window position Macros Features: * * View macros Add-Ins Tab Features: * * Menu commands Menu Commands Features: * * Bluetooth Microsoft Office PowerPoint 2007 Help To access Help, click the in the top right-hand corner of the Microsoft Office PowerPoint 2007 screen. The PowerPoint Help box will open. Enter the search criteria. Toolbars File Toolbar The File menu allows you to create a new slideshow, open an existing slideshow, save a slideshow, print a slideshow, prepare a slideshow, send a slideshow, publish a slideshow, or close a slideshow. A list of your recent documents will be displayed. Also, you can set PowerPoint Options and Exit PowerPoint. To see a list of File menu options, click Quick Access Toolbar The Quick Access Toolbar gives you quick access to different functions. Add Items to Quick Access Toolbar * Click the next to the Quick Access Toolbar * Single-click on the item you want to add to the Quick Access Toolbar * If an item is not listed, single-click on More Commands * In the left pane, single-click on the items you want to add to the Quick Access Toolbar * Click Add * The items selected will appear in the right pane * Click OK * The box will close and the items selected will appear on the Quick Access Toolbar Tabs In some cases, it may be necessary to click the or the to open up additional menu items. Home Tab Features: * * Clipboard * Slides * Font * Paragraph * Drawing * Editing Clipboard Features: * * Paste * Cut * Copy * Format painter Slides Features: * * New slide * Layout * Reset * Delete slide Font Features: * * Font * Font size * Increase/decrease font size * Clear all formatting * Font style * Effects * Character spacing Paragraph Features: * * Bullets * Increase/decrease list level * Alignment * Line spacing * Text direction * Align text * Convert to SmartArt graphic Drawing Features: * * Shapes * Arrange * Shape quick style * Shape fill * Shape outline * Shape effects * Line color * Line style * Picture Editing Features: * * Find * Replace * Select Insert Tab Features: * * Tables * Illustrations * Links * Text * Media clips Tables Features: * * Table Illustrations Features: * * Insert picture from file * Clip art * New photo album * Shapes * Insert SmartArt graphic * Insert chart Links Features: * * Insert hyperlink * Action Text Features: * * Text box * Header & footer * WordArt * Date & time * Insert slide number * Symbol * Insert object Media Clips Features: * * Movie from file * Sound from file Design Tab Features: * * Page setup * Themes * Background Page Setup Features: * * Page setup * Slide orientation Themes Features: * * Themes * Theme colors * Theme fonts * Theme effects Background Features: * * Background styles * Hide background graphics Animations Tab Features: * * Preview * Animation * Transition to this slide Preview Features: * * Preview animations Animation Features: * * Animate * Custom animation Transition to this Slide Features: * * Transitions * Transition sound * Transition speed * Apply to all Slide Show Tab Features: * * Start slide show * Set up * Monitors Start Slide Show Features: * * Slide show from beginning * From current slide * Custom slide show Set Up Features: * * Set up show * Hide slide * Record narration * Rehearse timings * Use rehearsed timings Monitors Features: * * Resolution * Show presentation on * Use presenter view Review Tab Features: * * Proofing * Comments * Protect Proofing Features: * * Spelling * Research * Thesaurus * Translate * Language Comments Features: * * Show markup * Insert comment * Edit comment * Delete comment * Previous comment * Next comment Protect Features: * * Protect presentation View Tab Features: * * Presentation views * Show/hide * Zoom * Color/grayscale * Window * Macros Presentation Views Features: * * Normal view * Slide sorter view * Notes page view * Slide show * Slide master view * Handout master view * View notes master Show/Hide Features: * * Ruler * Gridlines * Message bar Zoom Features: * * Zoom * Fit to window Color/Grayscale Features: * * Color * Grayscale * Pure black and white Window Features: * * New window * Arrange all * Cascade windows * Move split * Switch windows Macros Features: * * View macros Add-Ins Tab Features: * * Menu commands Menu Commands Features: * * Bluetooth Microsoft Office Access 2007 Help To access Help, click the in the top right-hand corner of the Microsoft Office Word 2007 screen. The Word Help box will open. Enter the search criteria. Toolbars File Toolbar The File menu allows you to create a new database, open an existing database, save a database, print a database, manage a database, email a database, or publish a document. A list of your recent documents will be displayed. Also, you can set Access Options and Exit Access. To see a list of File menu options, click Quick Access Toolbar The Quick Access Toolbar gives you quick access to different functions. Add Items to Quick Access Toolbar * Click the next to the Quick Access Toolbar * Single-click on the item you want to add to the Quick Access Toolbar * If an item is not listed, single-click on More Commands * In the left pane, single-click on the items you want to add to the Quick Access Toolbar * Click Add * The items selected will appear in the right pane * Click OK * The box will close and the items selected will appear on the Quick Access Toolbar Tabs In some cases, it may be necessary to click the or the to open up additional menu items. Home Tab Features: * * Views * Clipboard * Font * Rich text * Records * Sort & filter * Find Views Features: * * View Clipboard Features: * * Cut * Copy * Paste * Format painter Font Features: * * Font * Font size * Font color * Cell effect * Gridlines * Background color * Gridline color * Border and line styles * Direction Rich Text Features: * * Increase/decrease list level * Left-to-right text direction * Bullets * Text highlight color Records Features: * * Refresh all * New * Save * Delete * Totals * Spelling * Row height * Column width Sort & Filter Features: * * Ascending * Descending * Clear all sorts * Filter * Selection * Advanced filter options * Toggle filter Find Features: * * Find * Replace * Go to * Select Create Tab Features: * * Tables * Forms * Reports * Other Tables Features: * * Table * Table templates * SharePoint lists * Table design Forms Features: * * Form * Split form * Multiple items * PivotChart * Blank form * Form wizard * Datasheet * PivotTable * Form design Reports Features: * * Report * Labels * Blank report * Report wizard * Report design Other Features: * * Query wizard * Query design * Macro External Data Tab Features: * * Import * Export * Collect data * SharePoint lists Import Features: * * Saved imports * Import Access database * Import Excel spreadsheet * Import SharePoint list * Import text file * Import XML file * ODBC database * HTML document * Outlook folder Export Features: * * Saved exports * Export to Excel spreadsheet * Export to SharePoint list * Export to RTF file * Export to text file * Export to Access database * Export to HTML document Collect Data Features: * * Create e-mail * Manage replies SharePoint Lists Features: * * Work online * Synchronize * Discard changes * Cache list data * Relink lists * Move to SharePoint Database Tools Tab Features: * * Macros * Show/hide * Analyze * More data * Database tools Macro Features: * * Visual Basic * Run macro * Create shortcut menu from macro * Convert form’s macros to Visual Basic Show/Hide Features: * * Relationships * Property sheet * Object dependencies * Message bar Analyze Features: * * Database documenter * Analyze performance * Analyze table Move Data Features: * * SQL server * Access database Database Tools Features: * * Linked table manager * Switchboard manager * Encrypt password * Add-ins * Make ACCDE Add-Ins Tab Features: * * Menu commands Menu Commands Features: * * Bluetooth Form Layout Tools Format Tab Features: * * Views * Font * Formatting * Gridlines * Controls * AutoFormat Views Features: * * Form view * Layout view * Design view Font Features: * * Font * Font size * Font style * Font color * Fill/back color * Alternate fill/back color * Conditional Formatting Features: * * Format * Apply currency format * Apply percent format * Apply comma number format * Increase/decrease decimals Gridlines Features: * * Gridlines * Width * Style * Color Controls Features: * * Logo * Title * Insert page numbers * Date & time * Line thickness * Line type * Line color * Add existing fields AutoFormat Features: * * AutoFormat