Excel Bookstore
 Location:  Home » Excel Books » 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)    
Other Locales
  • Canada
  • U.K.
  • USA
  • Categories
    Bill Jelen Books
    Excel Books
    Excel 2007 Books
    VBA Books
    Pivot Table Books
    Charting Books
    Access Books
    Office Books
    Holy Macro! Books
    Office Software
    Computers
    Kindle
    Related Categories
    • Microsoft Excel
    Microsoft
    Software
    Computers & Technology
    Subjects
    • Microsoft Office
    Microsoft
    Software
    Computers & Technology
    Subjects

    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)

    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)Author: Beezix Inc.
    Publisher: Beezix Inc.
    Category: Book

    List Price: $5.75
    Buy New: $4.72
    as of 6/23/2017 06:29 EDT details
    You Save: $1.03 (18%)

    In Stock


    New (2) Used (4) from $4.72

    Seller: Amazon.com
    Sales Rank: 23,812

    Languages: English (Published), English (Unknown)
    Media: Pamphlet
    Pages: 4
    Shipping Weight (lbs): 0
    Dimensions (in): 11 x 8.5 x 0.4

    ISBN: 1936220253
    EAN: 9781936220250
    ASIN: 1936220253

    Publication Date: April 15, 2011
    Shipping: Eligible for FREE Super Saver Shipping
    Availability: Usually ships in 24 hours

    Similar Items:


    Editorial Reviews:

    Product Description
    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.



    CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
    Thank you for browsing ExcelBookstore.com!