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)

Beezix Inc.

ISBN 10: 1936220253 ISBN 13: 9781936220250

Publisher: Beezix Inc., 2011

Synopsis

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.

About this title

About the Author

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. The cards were intended to meet the needs both of trainers in the classroom, and of software users at their workstations.

Edition details

• Publisher: Beezix Inc.
• Publication date: 2011
• ISBN 10: 1936220253
• ISBN 13: 9781936220250
• Binding: Pamphlet
• Language: English
• Number of pages: 4