Super User Advanced Excel Training - Power Charts

It’s not enough to just know how to make a chart – it needs to look good too! This
class gets you started with the basics and how to best layout your data for
effective charts. You’ll learn all different types of formatting techniques and
ways to enhance the chart to make it pop! Our instructor will show you how to
insert your chart into a document or slide.

Prerequisites: Excel Basic or equivilant experience

At the completion of this course, participants will be able to perform the following tasks:

Creating Charts

• Using Charts
• Creating Charts
• Moving and Resizing Charts
• Identifying Chart Elements
• Changing the Chart Type
• Changing the Plot Direction
• Removing/Adding a Legend
• Moving the Legend
• Charting Non-adjacent Ranges
• Changing the Chart Range
• Changing the Data Source
• Changing the Chart Location
• Working with Sparklines
• Formatting a Sparkline
• Printing a Chart
  

Formatting Charts

• Format charts
• Add chart titles
• Format chart elements
• Change the text orientation
• Add a data table
• Create an exploded pie chart
• Adjust the 3-D view
• Delete a chart

Using Advanced Charting Features

• Add and remove gridlines
• Format gridlines
• Format an axis
• Change the axis scaling
• Format the data series
• Add data from different worksheets
• Use a secondary axis
• Change data series chart types
• Add a trendline
• Create a chart template
• Apply a chart template