COURSE DESCRIPTION FOR
INTEGRATE DATA AND GRAPHS INTO YOUR WORD 2000 DOCUMENTS USING EXCEL
DESCRIPTION
Did you know your great looking charts and graphs from
Excel can be used in Word as well? Discover a variety of techniques to create
graphs and charts in Excel and integrate them into Word documents. The class
is instructor-led and is full of hands-on activities. You can also bring
your own files to experiment with. Learn to:
- Incorporate Excel data and graphs into Word using various
methods and recognize the difference between linking and embedding.
- Dynamically update data in Excel graphs and customize
graphs to create effective documents.
- Use MS Graph to create charts.
- Use graphics and visuals with graphs in Word.
LENGTH
One four hour session.
PREREQUISITES
Word - Level 1 and Excel
- Introduction or equivalent knowledge. You must also have a good understanding
of basic Microsoft Windows, file management and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Add some zing with Excel charts and data
Incorporate Excel data into Word
Graph it!
Link an Excel graph and Word document
Create a new graph from Word
Change the look of a linked graph
Break it up
Lab Activity 2: Update Data and Customize your Excel graphs
Update a linked graph
Update an embedded graph
Add and automate captions
Work with titles
Change the colors and patterns of a graph
Lab Activity 3: Use MS Graph to create charts
Create a graph using MS Graph
Illustrate a graph by adding a text box
Rotate text in a chart title
Convert a Word table to a graph using MS Graph
Choose what data to include in a chart
Import data from an Excel worksheet into MS Graph
Lab Activity 4: Use visuals in your graphs
Add a company logo to your Excel graph
Add visuals to an MS Graph graph
Customize visuals using Word
Remove visuals from a data series
NECESSARY SOFTWARE AND HARDWARE
- An IBM or IBM-compatible computer equipped with Word
97 or 2000, Excel 97 or 2000 and MS Graph 97 or 2000.
- An installed printer driver. (Printers are not required;
however, you must have an installed printer driver to use Print Preview.)
OTHER EXCEL CLASSES
- Excel - Advanced. Master advanced formulas and other
advanced features including macros and pivot tables.
- Mini Power Sessions:
--Create And Manage A Worksheet Database Using Excel
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Save Time With Functions Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 
