Geared toward the intermediate to advanced Mac Excel 2011 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2011 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. See topics below.
Price: $5.75
Volume Price
Quantity
Price
1 – 49
$5.75
50 – 99
$4.65
100 – 499
$3.85
500 – 999
$3.30
1000 +
$3.15
Note: Quantity discounts are by title.
ISBN # : 978-1-936220-46-5
Topics include:
Glossary. Conditionally Summing/Counting Data (SUMIF, COUNTIF). Being Precise (Rounding functions). Improving Clarity with Range Names: Name Rules, Creating Names, Using and Selecting Names, Managing Names, Indirectly Referring to a Named Range (INDIRECT). 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) Why to use them, Entering, Editing, Expanding, Deleting. Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS). Using a Formula for Data Validation, Limit to a List. Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Displaying Cell Relationships, Selecting Related Cells, Removing Relationship Arrows.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
