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


or
Sign in to turn on 1-Click ordering.
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 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide) [Pamphlet]

Beezix Inc

Price: CDN$ 5.75 & 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
Usually ships within 1 to 4 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.
Join Amazon Student in Canada


Book Description

April 15 2011
Geared toward the intermediate to advanced user, this example-rich 4-page laminated quick reference guide provides explanations and context for many powerful functions and formulas. Step-by-step instructions for many function/formula-related features. This guide is suitable as a training handout, or simply an easy to use reference guide.

The following topics include:

Conditionally Summing Data (SUMIF, COUNTIF)
Being Precise (Rounding functions)
Improving Clarity with Range Names
Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)
Changing Results: IF, AND, OR
Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)
Error Recovery (ISNA, ISERROR)
Array Formulas (Single Cell & Multi-Cell Arrays)
Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAY)
Using a Formula for Data Validation
Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Show/Hide Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

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 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 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) + Microsoft Excel 2010 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Price For All Three: CDN$ 12.95

Some of these items ship sooner than the others. Show details



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  66 reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars Great product May 21 2013
By Ian van Niekerk - Published on Amazon.com
Format:Pamphlet|Verified Purchase
this card covers all the things you need when doing functions or formulas in excel - great to have it in one card
4 of 4 people found the following review helpful
4.0 out of 5 stars Excal Quick Guide May 1 2012
By Tough Lady - Published on Amazon.com
Format:Pamphlet|Verified Purchase
Niffy tool to help with newer version of Excel, which has dramatically changed from prior version. Can't go wrong with the price either!
3 of 3 people found the following review helpful
4.0 out of 5 stars Helpful 'cheat-sheet'. Oct. 31 2011
By Rick Mclaughlin - Published on Amazon.com
Format:Pamphlet|Verified Purchase
This sheet is a great tool that eases the need to remember certain formula configurations. Been looking for something like this for some time and now use it constantly. I recommend this for the simple reason that it is simple, concise and easy to read/use.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Guide!!! Dec 15 2013
By Snowbird - Published on Amazon.com
Format:Pamphlet|Verified Purchase
This is a great reference tool and you don't need to spend time looking up in a handbook or QUE book.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Reference Nov. 21 2013
By Wanda Patterson - Published on Amazon.com
Format:Pamphlet|Verified Purchase
Ordered this for my husband to have at his office. He started a new job and had limited experience with Excel. This quick reference is just what he needed to "excel" in his new position!

Look for similar items by category


Feedback