

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. Review: Cheat Sheet excellence - Excellent quick ref guide for formulas and functions in Excel. Got this so my dad can learn more about using spreadsheets. It has greatly reduced the number of 'can you tell me how to make it do this?' interruptions. For that alone, it would be a deal at twice the price. For the rest of you, it is worth it for the quick ref of seldom-used formulas and functions on this thing. A penny saved might be a penny earned, but a minute saved is PRICELESS. Review: Microsoft Excel 2010 Functions and Formulas cheat sheets - I repeat the same as I have filled in on all the other cheat sheets 1. I chose this rating as I consider these sheets are simple and efficient in checking information 2. My only problem is personal because of bad eyesight but if printing was larger all the information would not fit on the page 3. I would recommend these products to anyone who wants information quickly and easily
| Best Sellers Rank | #4,966,073 in Books ( See Top 100 in Books ) #737 in Microsoft Excel Guides #851 in Microsoft Office Guides |
| Customer Reviews | 4.5 out of 5 stars 300 Reviews |
A**Z
Cheat Sheet excellence
Excellent quick ref guide for formulas and functions in Excel. Got this so my dad can learn more about using spreadsheets. It has greatly reduced the number of 'can you tell me how to make it do this?' interruptions. For that alone, it would be a deal at twice the price. For the rest of you, it is worth it for the quick ref of seldom-used formulas and functions on this thing. A penny saved might be a penny earned, but a minute saved is PRICELESS.
M**S
Microsoft Excel 2010 Functions and Formulas cheat sheets
I repeat the same as I have filled in on all the other cheat sheets 1. I chose this rating as I consider these sheets are simple and efficient in checking information 2. My only problem is personal because of bad eyesight but if printing was larger all the information would not fit on the page 3. I would recommend these products to anyone who wants information quickly and easily
M**K
Helpful 'cheat-sheet'.
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.
G**E
Excellent as a Quick Reference!
This is excellent as a quick reference for people not well versed in Excel. I use it all the time as I'm learning Excel in my "older years" and the memory needs jogged at times. This is a great resource to keep on my desk and doesn't take the space of those huge Excel Bibles! I love this handy reference, it's laminated well and doesn't come apart.
L**E
Great for quick answers.
Perfect to keep as a summary. I have a binder with all my notes for my computer. This is excellent. Rather than always searching in books, I can refer to this sheet. I can put it in my binder and refer to it when I want to find a function or formula quickly. I use books, but I like to store reference sheets, information in one place. This is great
M**A
nice document and good lamination
easy to use, not much fluff at all. The infromation is presented clear and concise and the best thing is that you can place it on your office desk and it will withstand coffee spills, stains and the occasional danish pastry crumb. Once you clean it off, it will look like you respect your office enough not to spill coffee and danish all over your materials. And all the while, you will have a great reference for when you forget how to properly set up that VLOOKUP function.
A**S
Useful
The product arrived on time. It is a useful and handy. I have not used it that much, but it is a valuable piece of information to have.
R**A
Great tips
Great tips, and in a handy laminated pamphlet. I know these tips are probably available online if you search for it, but having a physical copy with so many tips together is a great resource for anyone that uses Excel regularly.
A**R
As described and fast delivery
As described and fast delivery
P**C
Five Stars
Perfect!
M**Y
Five Stars
Very helpful. Concise and well- laid out.
G**R
It is functional.
Helped with a couple of commands.
K**E
Five Stars
A helpful quick reference tool.
Trustpilot
2 weeks ago
3 days ago