Excel 2013: Charts in Depth – Lynda

Charts allow you to communicate information visually, in a way that’s more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart’s color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.

Course Program:

• Selecting the right chart type
• Choosing data to display as a chart
• Creating charts fast with the Quick Analysis tool
• Choosing a chart layout
• Changing the location of the source data
• Dealing with empty and hidden cells
• Moving and resizing charts
• Adding data labels
• Analyzing existing and future data with trendlines
• Adding shapes and arrows
• Working with column, bar, line, pie, and area charts
• Working with specialized chart types: Gantt, Pareto, and Frequency charts
• Creating dynamic charts
• Printing and sharing your chart

Fees:

INR 15, 00 (assuming $ = INR 60)

Duration:

3 hour 46 minutes

• Excel

• Dennis Taylor