oit_content_123204 - University Technology Training Center...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
University Technology Training Center MS Office 2007: Working Between Applications
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
04.22.09 UNIVERSITY TECHNOLOGY TRAINING CENTER MS Office 2007: Working Between Applications © 2009 Regents of the University of Minnesota University Technology Training Center All Rights Reserved uttc.umn.edu The University of Minnesota is committed to the policy that all persons shall have equal access to its programs, facilities, and employment without regard to race, color, creed, religion, national origin, sex, age, marital status, disability, public assistance status, veteran status, or sexual orientation. This publication/material can be made available in alternative formats for people with disabilities. Direct requests to: University Technology Training Center 190 Shepherd Labs 100 Union Street Southeast Minneapolis, MN 55455 612.625.1300 uttc@umn.edu
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
UNIVERSITY TECHNOLOGY TRAINING CENTER I Table of Contents LESSON 1 1 LINKING AN EXCEL CHART TO A WORD FILE 1 Copy and Paste to Link an Excel Chart to a Word Doc 3 Reformat an Excel Chart in Word 4 Update Chart Data 5 Update a Link Location 8 Open a Word Doc Containing a Link 10 Transporting Linked Files 11 LESSON 2 13 PASTING A CHART WITHOUT A LINK 13 Copy and Paste a Chart as a Picture 14 Apply a Picture Style 14 Link a Chart and Break the Link 15 Format a Chart using Word’s Chart Tools 15 Embed a Chart (Including Its Workbook) 16 Edit an Embedded Chart 16 LESSON 3 19 CONVERTING A WORD TABLE TO EXCEL 19 Copy and Paste a Word Table into Excel 20 Format a Worksheet 21 Text to Columns 23 Separate Delimited Text to Columns 24 Sort data 26 Separate Fixed Width Data to Columns 27 Practice: Text to Columns 28 LESSON 4 31 FORMATTING DATA AS AN EXCEL TABLE 31 Format as Table 32 Change a table format 33 Change the Zoom View 33 Add New Data to a Table 34 Delete a Table Row 34 Filter Data 34 Count the Number of Records 35 Sort a filtered list 35 Remove a filter 36 Practice: Filter and Count Records 37
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
LESSON 1: LINKING AN EXCEL CHART TO A WORD FILE II U NIVERSITY TECHNOLOGY TRAINING CENTER LESSON 5 39 MERGING LETTERS, LABELS, AND DIRECTORIES 39 Merging Overview 40 The Mailings Tab 40 Working with Fields 41 Merging Letters 41 Sorting Merge Recipients 44 Selectively Including Merge Data 46 Using Preview Results for Merging 48 Formatting Merged Text 49 Practice: Selectively Include Data 50 Merging Directories 53 Practice: Merge Labels 57 LESSON 6 63 CONVERTING A WORD DOCUMENT TO A PRESENTATION 63 Setting up a Word document for multiple uses 64 Bringing a Word Document into PowerPoint 65 Organizing a Presentation 65 Practice: Cleaning up PowerPoint Text 68 Applying Layouts 69 Resetting Slides 69 Using Smart Art 70 Practice: SmartArt 72 Linking an Excel Spreadsheet into PowerPoint 73 Copy and Paste SmartArt into PowerPoint 75 Practice: Linking a Chart to PowerPoint 76 LESSON 7 77 USING THEMES FOR A CONSISTENT LOOK 77 Themes 78 View the Theme of a Preexisting Document 78 Applying a Design Theme in
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 101

oit_content_123204 - University Technology Training Center...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online