Books > Gift Ideas > Computers & Technology

Price: $3.60

(as of 2012-10-06 20:35:33 PST)

Usually ships in 24 hours

Computers & Technology

Rating: 4.3 / 5.0 (3 votes)

Released: 2011-02-18

Buying Choices

5 new from $3.28
4 used from $2.94

(as of 2012-10-06 20:35:33 PST)

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


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.

Check All Offers Add to Wish List Customer Reviews

Book Details

Author: Beezix Inc Publisher: Beezix, Inc. Binding: Pamphlet Language: English Pages: 2

Similar Books

Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on exampl..
Microsoft Excel 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts..
Microsoft PowerPoint 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shor..
Microsoft Excel 2010 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shor..
Microsoft Excel 2010 Charts & Sparklines Quick Reference Guide (Cheat Sheet of Instructions, Tips & Sh..


Become a fan of Your #1 Source for Kindle eBooks from the Amazon Kindle Store! on Facebook for the inside scoop on latest and most exclusive books.