Dennis Taylor – Excel 2016: Charts in Depth

Description

Dennis Taylor – Excel 2016: Charts in Depth

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

Contents:

• 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.

Digital Download Dennis Taylor – Excel 2016: Charts in Depth at coursebing.shop Now!

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