Excel 2016: Charts in Depth

By: Dennis Taylor

Level: Intermediate

Duration: 4h 36m

Released: Feb 16, 2016

Updated: Mar 1, 2016

Description:

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. In Excel 2016, there are six brand-new chart types to learn. 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. 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. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker.

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
Analyzing data with trendlines
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

Introduction
1. Review the Basic Elements of an Excel Chart
2. Create Basic Charts
3. Style Your Charts with the Design Tab
4. Fine-Tune Your Chart Elements
5. Format Tab: Insert Pictures, Shapes, and Text Boxes
6. Adjusting Specific Chart Types
7. Other Specialized Excel Charts
8. New Chart Types in Excel 2016
9. Change a Chart’s Data Source
10. Print and Share Charts
Conclusion

Author:

Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.

Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.

Get Download Dennis Taylor – Excel 2016: Charts in Depth at Forimc.net today!

Salepage:

Archive: https://web.archive.org/web/20170107110118/https://www.lynda.com/Excel-tutorials/Excel-2016-Charts-Depth/431184-2.html

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.
– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from esy[GB].
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!