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:

• 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

Fees:

INR 15, 00 (assuming $ = INR 60)

Duration:

3 hour 38 minutes

• Excel

• Dennis Taylor