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.

4.00 out of 5 stars

39 ratings by Goodreads

9781936220250: 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)

ISBN 10: 1936220253 ISBN 13: 9781936220250

Publisher: Beezix Inc., 2011

View all copies of this ISBN edition

0 Used

2 New

From US$ 10.55

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.

"synopsis" may belong to another edition of 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.

"About this title" may belong to another edition of this title.

Publisher

Beezix Inc.

Publication date

2011

Language

English

ISBN 10

1936220253

ISBN 13

9781936220250

Binding