Editorial Reviews:
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:BRBRConditionally Summing Data (SUMIF, COUNTIF)BRBeing Precise (Rounding functions)BRImproving Clarity with Range NamesBRMerging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)BRChanging Results: IF, AND, ORBRTable Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)BRError Recovery (ISNA, ISERROR)BRArray Formulas (Single Cell Multi-Cell Arrays)BRDates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAY)BRUsing a Formula for Data ValidationBRTroubleshooting: 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.BRBRThis 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.
