Excel for Mac 2011

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. Topics include:

• Creating charts with one click
• Selecting the right chart types
• Changing chart type or source data
• Choosing a chart layout and style
• Saving charts as templates
• Editing titles, legends, and labels
• Adding a data table
• Analyzing data with trendlines
• Formatting the chart
• Customizing different chart types
• Creating Gantt and frequency charts
• Creating in-cell charts
• Moving charts