xyz 軟體補給站

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