Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

4 avg rating
( 18 ratings by Goodreads )
 
9781936220335: Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
View all copies of this ISBN edition:
 
 

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting and filtering features in Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.
The following topics are covered:

Excel Tables: Creating an Excel Table, Changing the Table Area, Adding a New Row or Column to the Table, 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, Subtotals, and PivotTables, Removing Duplicates, Structured References in Excel Tables.

PivotTables: Creating a PivotTable or PivotChart Report, Show/Hide the PivotTable Field List, Adding/Removing a PivotTable Field, Refreshing a PivotTable, Rearranging a PivotTable, Adding a PivotChart to an Existing PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting in a PivotTable, Grouping by Dates or Time, Filtering PivotTables and Charts with Slicers.

Sorting & Filtering: Basic Sorting, Complex Sorting, Re-applying a Sort, Creating a Custom List, Creating a Custom List from Cell Data, Sorting Using a Custom List, Filtering and Advanced Filtering, Show/Hide AutoFilter, Searching for Filter Criteria in AutoFilter, Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting /Ordering Columns, Filter/Copy Unique Rows, Clearing Filtering and Sorting, Subtotals.

This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

"synopsis" may belong to another edition of this title.

About the Author:

Beezix has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for over 15 years. Founded by trainers, and with 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. Our cards are designed for casual computer users right through to trainers and trouble-shooters.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Beezix Inc
Published by Beezix, Inc.
ISBN 10: 1936220334 ISBN 13: 9781936220335
New Quantity Available: 1
Seller:
Ohmsoft LLC
(Lake Forest, IL, U.S.A.)
Rating
[?]

Book Description Beezix, Inc. Condition: New. Pamphlet. Worldwide shipping. FREE fast shipping inside USA (express 2-3 day delivery also available). Tracking service included. Ships from United States of America. Seller Inventory # 1936220334

More information about this seller | Contact this seller

Buy New
US$ 10.36
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Beezix Inc
Published by Beezix, Inc. (2011)
ISBN 10: 1936220334 ISBN 13: 9781936220335
New Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Beezix, Inc., 2011. Pamphlet. Condition: New. Seller Inventory # DADAX1936220334

More information about this seller | Contact this seller

Buy New
US$ 12.60
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

3.

Beezix/ Inc.
Published by Beezix, Inc. (2011)
ISBN 10: 1936220334 ISBN 13: 9781936220335
New Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Beezix, Inc., 2011. Pamphlet. Condition: Brand New. 2 pages. 11.00x8.50x0.10 inches. In Stock. Seller Inventory # 1936220334

More information about this seller | Contact this seller

Buy New
US$ 15.56
Convert Currency

Add to Basket

Shipping: US$ 8.36
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Beezix Inc
Published by Beezix, Inc. (2011)
ISBN 10: 1936220334 ISBN 13: 9781936220335
New Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Beezix, Inc., 2011. Pamphlet. Condition: New. Never used!. Seller Inventory # P111936220334

More information about this seller | Contact this seller

Buy New
US$ 35.21
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds