Excel 2007: Charts in Depth

with Dennis Taylor
please wait ...
Excel 2007: Charts in Depth
Video duration: 0s 3h 36m Intermediate

Viewers:

In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.

Topics include:
  • Identifying the plot area, chart area, gridlines, legends, and more
  • Selecting the right chart type
  • Creating charts instantly with shortcuts
  • Choosing a layout
  • Dealing with empty and hidden cells
  • Switching rows and columns for a different view of the data
  • Moving and resizing a chart
  • Inserting pictures and shapes
  • Adding labels to a chart
  • Analyzing existing and future data with trendlines
  • Changing a chart's data source
  • Printing charts
Subject:
Business
Software:
Excel
Author:

Welcome

- [Voiceover] Hi, I'm Dennis Taylor and welcome to Excel 2007 Charts In Depth. Creating charts is one of Excels most powerful yet easy to use features. You'll see huge improvements in the visual quality of charts. They have a vast array of color and design choices not available in older versions of Excel. In this course, we'll be looking at the concepts underlying charts and give you the tools to implement those concepts. I'll show you how to create standard useful charts very quickly, and then how to fine tune those charts with a variety of tools and features.

We'll see how to give greater impact to your charts with pictures and shapes, and then examine the most effective use of titles, labels, legends, axis and grid lines. We'll look at analytic tools that help you make sense of the chart's data. If you're not using charts, then you're missing out on one of the most popular and easy to use features of Excel. So join me in Excel 2007 Charts In Depth.

please wait ...