Creating and Modifying Charts & Graphs - SS05

General Description

A picture is worth a thousand words, so what is a graph worth? Present your data graphically using Microsoft Excel's powerful charting tools.

Target Audience

This session is intended for participants wishing to improve on their existing basic working knowledge of Microsoft Excel.

Pre-requisites

Participants should be able to use standard features of Microsoft Excel including how to enter, select and format data and move around a worksheet.

Duration

3 hours

Learning Outcomes

• Create simple and effective graphs using the chart wizard
• Create and work with various types of graphs
• Select an appropriate graph type for various data types
• Change the chart type
• Print a chart
• Move, copy, resize and delete charts
• Change the colours, fonts and layout of a graph
• Change the appearance of graphs
• Set graph options
• Import and plot data from a CSV and TXT file
• Add data labels to a graph