Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Beezix Inc , Beezix Inc.

Price: CDN$ 3.60 & FREE Shipping on orders over CDN$ 25. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 5 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Friday, October 31? Choose One-Day Shipping at checkout.
Join Amazon Student in Canada


Book Description

Feb. 18 2011
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.

Frequently Bought Together

Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) + Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide) + Microsoft Excel 2010 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Price For All Three: CDN$ 12.95



Product Details


Product Description

About the Author

Beezix Inc. - Publishers of quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for over 15 years. Through working with top trainers and product specialists, we've distilled years' worth of experience into these sleek, durable cheat sheets. Our cards have all the shortcuts, quick tips, and step-by-step instructions for Microsoft® Office products such as Outlook, Excel, PowerPoint, as well as Lotus Notes and many others at your fingertips.

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. Our cards are designed for casual computer users right through to trainers and trouble-shooters.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more


Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars  49 reviews
6 of 7 people found the following review helpful
4.0 out of 5 stars Very good quick reminder June 15 2012
By Theodore Shoemaker - Published on Amazon.com
Format:Pamphlet|Verified Purchase
While those with no knowledge of Excel 2010 tables and pivot tables would be better served by a text guide, this is a great resource as a reminder for those functions you once learned, but rarely use.
3 of 3 people found the following review helpful
5.0 out of 5 stars Excell 2010 Cheat Sheet - Perfect March 23 2012
By Mary A. Dorman - Published on Amazon.com
Format:Pamphlet|Verified Purchase
This 2-sided plastic sheet is perfect as a summary of all the commands - those that we use frequently enough to remember them but especially those that we use so infrequently that we forget them. Those that I forget call for a trip to the book or the help system - both of which can be slow. The Quick Reference Guide is a great and compact tool to keep near my computer. I strongly recommend it for those new to Excel 2010 as there have been many changes from 2003 and 2007.
3 of 3 people found the following review helpful
4.0 out of 5 stars Excel 2010 Reference Guide - Jan. 8 2012
By Mike - Published on Amazon.com
Format:Pamphlet|Verified Purchase
These come in very hand when you are learning the application or just need quick information on how to do something.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great product... June 16 2013
By Eric F. Cunningham - Published on Amazon.com
Format:Pamphlet|Verified Purchase
The is a great reference for those who need to look up a quick shortcut on how to perform a function, using Excel. Very helpful, for the novice or an intermediate user,
2 of 2 people found the following review helpful
5.0 out of 5 stars Pivot Tables Oct. 24 2013
By Patricia L. Utso - Published on Amazon.com
Format:Pamphlet|Verified Purchase
I didn't even know what a pivot table was used for, how to create or anything. This has made it so easy to figure out. Thank you!

Look for similar items by category


Feedback