In Excel 2010: Charts in Depth, Dennis Taylor shows how to
analyze and communicate 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. Exercise files
are included with the course.
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
Download File Size:432.6 MB