Cover art for Ctrl+Shift+Enter Mastering Excel Array Formulas
Published
Holy Macro Books, July 2013
ISBN
9781615470075
Format
Softcover, 308 pages

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

Not in stock
Fast $7.95 flat-rate shipping!
Only pay $7.95 per order within Australia, including end-to-end parcel tracking.
100% encrypted and secure
We adhere to industry best practice and never store credit card details.
Talk to real people
Contact us seven days a week – our staff are here to help.

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.

Related books

  • Microsoft Excel 365 Bible by &

    Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365

    Excel 365 is Microsoft's latest cloud-based version of its ...

    2 in stock - ships Wed 06th!
  • 100 Top Tips - Microsoft Excel by

    100 Top Tips - Microsoft Excel will help you boost your productivity and get more value from your spreadsheets with this powerful book of tips. It ...

    2 in stock - ships Wed 06th!
  • Microsoft Excel in easy steps: Illustrated using Excel in Microsoft 365 by &

    Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel - whether you are new to Excel and the spreadsheet concept, or ...

    2 in stock - ships Wed 06th!
  • Excel All-in-One For Dummies by

    Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel Microsoft Excel offers unsurpassed functionality and accessibility for ...

    1 in stock - ships Wed 06th!
  • Microsoft Excel Inside Out (Office 2021 and Microsoft 365) by

    Conquer Microsoft Excel-from the inside out!

    Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This ...

    1 in stock - ships Wed 06th!
  • Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) by &

    Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever.

    Use this guide to ...

    1 in stock - ships Wed 06th!