rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9781615470075

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

by Girvin, Mike ExcelisFun
  • ISBN13:

    9781615470075

  • ISBN10:

    1615470077

  • eBook ISBN(s):

    9781615472093

  • Format: Paperback
  • Copyright: 2013-07-21
  • Publisher: Holy Macro! Books

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

List Price: $31.95 Save up to $25.95
  • Rent Book $22.76
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    IN STOCK USUALLY SHIPS IN 24-48 HOURS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

How To: Textbook Rental

Looking to rent a book? Rent Ctrl+Shift+Enter Mastering Excel Array Formulas Do the Impossible with Excel Formulas Thanks to Array Formula Magic [ISBN: 9781615470075] for the semester, quarter, and short term or search our site for other textbooks by Girvin, Mike ExcelisFun. Renting a textbook can save you up to 90% from the cost of buying.

Summary

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.

Author Biography

Mike Girvin is the author of Slaying Excel Dragons and has more than 800 Excel how-to videos on YouTube. He teaches finance, accounting, and statistics using Excel at the community college level. He lives in Seattle. Bill Jelen is an Excel expert at www.mrexcel.com, a regular on TechTV Canada’s Call for Help, and a video podcaster who is regularly listed in the iTunes top 50. He is the author of Excel Gurus Gone Wild, Pivot Table Data Crunching, Slaying Excel Dragons, and 14 titles in the Excel for Professionals series. He lives in Akron, Ohio.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program