Excel 2010: Charts
Excel 2010: Charts
MP4 | Video: 540p | Duration: 3:38:33 | English | Subtitles: VTT | 415.2 MB
MP4 | Video: 540p | Duration: 3:38:33 | English | Subtitles: VTT | 415.2 MB
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