Product Review

Laminated quick reference card showing step-by-step instructions and shortcuts for Charts (graphs) and Lists features of Microsoft Excel 2011 for the Mac. This card is suitable as an accompaniment for Intermediate level Excel training.

The following topics are covered:
Excel Charts:
Creating a Chart, Charting Non-Adjacent Data, Deleting a Chart, Resizing a Chart Object, Moving a Chart Object in the Worksheet, Changing Chart Type, General Editing of Chart Objects, Adjusting Axis Scale, Creating a Chart with Two Scales, Adding Explanatory Text; Adding, Removing, Moving a Legend; Adding a Data Series, Exploding a Piece of a Pie Chart, Adding Data Labels, Creating a Chart Sheet Using the Default Chart Type, Switching a Chart Object to a Chart Sheet, Adding Projection to a Data Series.
Excel Tables:
Creating an Excel Table, Adding a New Row or Column, Deleting a Table Row or Column, Turning On/Off the Total Row, Changing the Total Row, Convert a Table to a Normal Range; Using a Normal Range for Sorting, Filtering, and Subtotals; Removing Duplicates, Structured References in Excel Tables, Basic Sorting, Complex Sorting, Filtering and Advanced Filtering, Show/Hide Autofilter, Filtering with Autofilter, Searching for Filter Criteria in Autofilter, Advanced Filtering: Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting/Ordering Columns. Clearing Filtering, Subtotals.
Excel PivotTables:
Creating a PivotTable Report, Adding/Removing a PivotTable Field, Show/hide the PivotTable Builder, Refreshing a PivotTable, Rearranging a PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting in a PivotTable.
This guide is one of two titles available for Excel 2011: Excel 2011 Introduction and Excel 2011 Charts, Tables & PivotTables.