null
Loading... Please wait...
FREE SHIPPING on All Unbranded Items LEARN MORE
Print This Page

Ctrl+Shift+Enter Mastering Excel Array Formulas (Do the Impossible with Excel Formulas Thanks to Array Formula Magic)

List Price: $29.95
SKU:
9781615470075
Quantity:
Minimum Purchase
25 unit(s)
  • Availability: Confirm prior to ordering
  • Branding: minimum 50 pieces (add’l costs below)
  • Check Freight Rates (branded products only)

Branding Options (v), Availability & Lead Times

  • 1-Color Imprint: $2.00 ea.
  • Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
  • Belly-Band Wrap: $2.50 ea. (full-color printed)
  • Set-Up Charge: $45 per decoration
FULL DETAILS
  • Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
  • Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
  • Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
  • RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
  • Product Details

    Author:
    Mike ExcelisFun Girvin
    Format:
    Paperback
    Pages:
    308
    Publisher:
    Holy Macro! Books (July 21, 2013)
    Language:
    English
    ISBN-13:
    9781615470075
    ISBN-10:
    1615470077
    Dimensions:
    8.25" x 9.25" x 0.7"
    Case Pack:
    22
    File:
    Eloquence-IPG_08042026_P10436102_onix30_Complete-20260804.xml
    Folder:
    Eloquence
    As low as:
    $25.76
    Weight:
    24.64oz
    List Price:
    $29.95
    Publisher Identifier:
    P-IPG
    Discount Code:
    C
    Audience:
    General/trade
    Pub Discount:
    60
    Imprint:
    Holy Macro! Books
  • Overview

    Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.