Excel 2011 for Mac: Charts, Tables & PivotTables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card). Bookseller Inventory #
Synopsis: 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:
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.
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.
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.
About the Author: Beezix was founded by trainers, and has always had a strong focus on the learner. Extensive industry experience made us aware of the need for a line of high-quality, trainer-produced courseware, and led to the creation of Beezix Quick Reference guides in 1994. The cards were intended to meet the needs both of trainers in the classroom, and of software users at their workstations.
Title: Excel 2011 for Mac: Charts, Tables & ...
Book Condition: Good
Book Description Beezix, Inc., 2011. Pamphlet. Book Condition: Brand New. 2 pages. 11.00x8.50x0.10 inches. In Stock. Bookseller Inventory # 1936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: New. book. Bookseller Inventory # M1936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: Very Good. Bookseller Inventory # P021936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: New. Bookseller Inventory # P111936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: Like New. Almost new condition. Bookseller Inventory # P011936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: Used: Good. Bookseller Inventory # SONG1936220512
Book Description Beezix Inc., 2011. Pamphlet. Book Condition: Good. Ships with Tracking Number! INTERNATIONAL WORLDWIDE Shipping available. May not contain Access Codes or Supplements. Buy with confidence, excellent customer service!. Bookseller Inventory # 1936220512