NB: There are Video Tutorials supporting this eBook. Links to video tutorials are inclusive.
Charts allow you to communicate information visually, in a way that is more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In Excel 2016, there are six brand-new chart types to learn. Let us 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. Learn how to fine-tune your chart's colour and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box and Whisker. The training wraps up with lesson on changing data sources for charts and printing and sharing charts.
Topics include:
• Identifying chart elements
• Selecting the right chart type
• Creating basic charts
• Creating sparklines
• Styling charts
• Moving and resizing charts
• Modifying axes
• Adding labels and gridlines
• Analysing data with trend lines
• Inserting pictures, shapes, and text boxes
• Customizing column, bar, line, and pie charts
• Creating Gantt charts and other specialized Excel charts
• Changing data sources
• Printing and sharing charts
You will learn how to add greater impact to your charts with pictures and shapes, and then how to effectively use titles, labels, legends, axes, and gridlines.
We will look at analytical tools that will help you make sense of chart data and show you how to create dynamic charts that reflect fast-changing business environments. We will give you a ton of shortcuts and tips that will make your use of this popular tool more efficient and productive. So, join us in Excel 2016: Charts in Depth.
