Learn how to use Excel for Mac 2011 to create different kinds of charts—from column, bar, and line charts to Gantt and exploded pie charts—and understand how to decide which type works best for your data. Plus, find out 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. Author Dennis Taylor also introduces analytical tools that will help you make sense of your data and a few dynamic controls that allow you to adapt your charts on the fly. Along the way, he provides tips and tricks to be more productive and efficient. Instructor •.
Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator.
Jan 25, 2013 - This post is brought to you by Robin Wakefield, a Program Manager in the Excel Team. Have you ever had two different types of data that you.
Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US 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. By: Dennis Taylor course • 4h 31m 16s • 1,413 viewers • Course Transcript - [Voiceover] Hi, I'm Dennis Taylor, and welcome to Excel for the Mac 2011: Charts in Depth. Creating charts is one of Excel's most powerful, yet easy to use features.
In this course, we'll be looking at the concepts underlying charts, and the tools to implement those concepts. I'll show you how to create standard and useful charts, and then how to fine tune those charts with a variety of techniques. We'll see how to add greater impact to your charts with pictures and shapes, and then examine the most effective use of titles, labels, legends, axes, and grid lines. We'll 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, and we'll give you a ton of shortcuts and tips that will make your use of this popular tool more efficient and productive. So, join me in Excel for the Mac 2011: Charts in Depth. • Practice while you learn with exercise files. Watch this course anytime, anywhere.
Course Contents • Introduction Introduction • • • 1. Creating Basic Charts Quickly 1. Creating Basic Charts Quickly • • • 2. Understanding Excel Chart Concepts 2. Understanding Excel Chart Concepts • • • • • 3. Creating and Adjusting Chart Appearances with Charts Tab Choices 3.

Creating and Adjusting Chart Appearances with Charts Tab Choices • • • • • • • • 4. Using Chart Layout Tab Options 4. Using Chart Layout Tab Options • • • • • • • • • • • 5. Using Format Tab Options and Other Visual Features 5. Juice mac sticker. Using Format Tab Options and Other Visual Features • • • • • • • • • 6. Customizing Specific Chart Types 6.