Title: Ctrl+Shift+Enter Mastering Excel Array Formulas: Do the Impossible with Excel Formulas Thanks to Array Formula Magic
Publisher: Holy Macro! Books
Publication Date: 2013
Language: English
ISBN 10: 1615470077
ISBN 13: 9781615470075
Binding: paperback
Condition: Fair
Weight: 25 ounces

About this title

Synopsis

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.

About the Author

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.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Booktrolls LLC
9600 Bamboo Rd, None, Houston, TX, 77041, U.S.A.

Sale & Shipping Terms

Terms of Sale

We guarantee the condition of every book as it's described on the Abebooks web
sites. If you're dissatisfied with your purchase (Incorrect Book/Not as
Described/Damaged) or if the order hasn't arrived, you're eligible for a refund
within 30 days of the estimated delivery date. If you've changed your mind about a
book that you've ordered, please use the Ask bookseller a question link to contact
us and we'll respond within 2 business days.

Shipping Terms

Orders usually ship same or next business day. If you place an expedited order for a heavy or over-sized book, we may contact you to request that you cover the extra shipping cost.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	4 to 8 business days	2 to 6 business days
First item	US$ 0.00	US$ 0.99

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.