IUPUI

This workshop lasts 3 hours, and is part of the certificate series Excel 2010 End-User This workshop will help participants develop skills required to create effective and accurate charts. Intended for those already comfortable with using Excel, participants will create various types of charts and apply elements and formats. Chart templates and SmartArt graphics will be covered. This workshop also covers how to insert charts into PowerPoint slides.     What You'll learn Available Downloads

• understand charting terminology

• select appropriate chart types for a specific set of data

• create basic chart types, including column, pie, line, XY Scatter, and bar charts

• add a trendline and equation to the XY Scatter chart

• apply custom formats to charts and chart elements

• save and apply a chart template

• add shapes and SmartArt graphics to charts

• apply themes to charts

• insert Excel charts into a PowerPoint presentation

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• enter text and numbers into a worksheet

• perform calculations with formulas and functions

• format cells and worksheets

• select ranges of data

If you don't have those skills, consider first taking the workshop:

• Excel 2010: The Basics