Excel Bookstore
 Location:  Home » Office Books » Microsoft Excel 2013 Functions & Formulas Quick Reference Card (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 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)

    Microsoft Excel 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)Author: Beezix Inc.
    Creator: Beezix Inc.
    Publisher: Beezix Inc.
    Category: Book

    List Price: $5.75
    Buy New: $4.76
    as of 6/23/2017 06:28 EDT details
    You Save: $0.99 (17%)

    In Stock


    New (1) Used (2) from $4.76

    Seller: Amazon.com
    Sales Rank: 22,438

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

    ISBN: 1936220776
    EAN: 9781936220779
    ASIN: 1936220776

    Publication Date: March 26, 2013
    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 Microsoft Excel 2013 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2013 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. This guide is suitable as a training handout, or simply an easy to use reference guide.

    Topics include:

    Controlling Order of Precedence
    Conditionally Summing/Counting Data (SUMIF, COUNTIF)
    Being Precise (Rounding functions)
    Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, 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, NOT
    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, NETWORKDAYS, EDATE)
    Using a Formula for Data Validation
    Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

    This guide is one of multiple titles available for Excel 2013: Excel 2013 Introduction (ISBN 978-1936220762); Excel 2013 Functions & Formulas; Excel 2013 Data Analysis with Tables (978-1936220786).



    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!