CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APGRAPH - Graphs in Word and Excel

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students create graphs in Excel and then learn to link and embed graphs into Word documents.

Click here for a printer-friendly version of this page

Prerequisites

Excel Level 1 and Word Level 1 or equivalent knowledge

Detailed Class Syllabus

Picture your Excel data in a chart

Create charts quickly with the F11 key and the Chart Wizard

Identify chart components

Emphasize a single data range with a pie chart

Create a pie chart

Work with pie chart options

Change a chart’s location

Track data over time

Create column charts

Create line charts

Save chart settings

Spice up your reports with charts

Include an embedded chart object

Include a linked chart object

Discover the differences between embedding and linking

Add some zing to Word documents 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

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

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

Use visuals in your graphs

Add a company logo to your Excel graph

Add visuals to an MS Graph chart

Customize visuals using Word

Remove visuals from a data series