Ctrl+Shift+Enter Mastering Excel Array Formulas: Do the Impossible with Excel Formulas Thanks to Array Formula Magic
Original price was: $29.95.$25.64Current price is: $25.64.
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.
Publisher : Holy Macro! Books
Publication date : July 21, 2013
Language : English
Print length : 308 pages
ISBN-10 : 1615470077
ISBN-13 : 978-1615470075
Item Weight : 1.54 pounds
Dimensions : 8.25 x 0.7 x 9.25 inches
Best Sellers Rank: #2,349,314 in Books (See Top 100 in Books) #499 in Spreadsheet Books #10,125 in Computer Science (Books)
Customer Reviews: 4.6 4.6 out of 5 stars (174) var dpAcrHasRegisteredArcLinkClickAction; P.when(‘A’, ‘ready’).execute(function(A) { if (dpAcrHasRegisteredArcLinkClickAction !== true) { dpAcrHasRegisteredArcLinkClickAction = true; A.declarative( ‘acrLink-click-metrics’, ‘click’, { “allowLinkDefault”: true }, function (event) { if (window.ue) { ue.count(“acrLinkClickCount”, (ue.count(“acrLinkClickCount”) || 0) + 1); } } ); } }); P.when(‘A’, ‘cf’).execute(function(A) { A.declarative(‘acrStarsLink-click-metrics’, ‘click’, { “allowLinkDefault” : true }, function(event){ if(window.ue) { ue.count(“acrStarsLinkWithPopoverClickCount”, (ue.count(“acrStarsLinkWithPopoverClickCount”) || 0) + 1); } }); });
10 reviews for Ctrl+Shift+Enter Mastering Excel Array Formulas: Do the Impossible with Excel Formulas Thanks to Array Formula Magic
Fast, Reliable, and Convenient
Enjoy seamless delivery with Amazon Store. Whether you're shopping for everyday essentials, electronics, fashion, or gifts, your order is delivered straight to your door—fast and hassle-free. With options like Standard Delivery, Express Shipping, and even Same-Day Delivery in select areas, Amazon makes it easier than ever to get what you need when you need it.
Artcell –
Learning Excel Formulas from Ground Up
Mike has made my career. Period.I have a very specific way of learning. Mike syncs perfectly with my style and will do so with anyone.Mike’s is effective because:- He breaks every detail down (Most instructors never seem to accomplish this)- He does not rush but does is not slow either- Mike is patient and teaches in a way that makes complex problems seem easy- Mike will repeat basics even when teaching complex problems. This repetition grills into your head.- Mike is enthusiastic and gives you a vibe Excel is fun. So you are never intimidated by Excel and his enthusiasm will brush on you.- Mike is focused on teaching issues that you will actually use in professional life.I found Excel extremely hard when starting and tried for a year without getting anywhere until I found Mike. He has literally made my career and today’s I find myself in the top 10% of the job market as an analyst.I have moved over to advanced VBA programming now but I would have never gotten here if it wasn’t for Mike Girvin. This review is the least I could do for you Mike. I love you! It’s been couple of years I saw a video of yours (as I can write my own arrays now 🙂 but I will check you out today or tomorrow.
John –
There is no book like this one
Well Mike has attempted to write the unwritable book on complex Array formulas. His videos are great and have a “fun feel” but hard for this to come through in what is a non nonsense practical book on a tough topic. I guess it’s hard to write about because so much example detail is required to get across the concepts. But it is an important subject if you are serious about getting into advanced Excel formulas and advanced financial modelling. What a collection of examples it is. And Mike is a guru on formulas if you have ever seen he and Bill Jelen in those Excel Duelling podcasts where they both tackle the same problem in their own ways in blistering speed and Mike’s use of native Excel formulas is really amazing. You may not need these kind of formulas every day, but if you have to work with someone else’s spreadsheets that you can’t change much and need to get a report together in a hurry, you need Array formulas. Or you have written a spreadsheet but your boss wants something at the last minute. Or you need dynamic formulas for interactive models. But you need to have a sound understanding of them or you will get too frustrated trying to get them to work as situations change. This book will give you that understanding, if you work through the book. Also it helps with formulas generally and shows you so many situations it helps with a general understanding of which formula to use when. Other books have array formulas as a chapter but here is a whole book devoted to them with lots of practical examples.I reckon its an important book to buy, digest, and is not bad value as well. But you need to work through the examples with strong expresso on tap given it’s practical workbook style. And unless you are an insomniac don’t read it in bed like I did a few times, as it will bruise your forehead!
J Nguyen Knight –
It is highly visual without all of the distracting colors that take away from its focus.
This book has got to be single-handedly, the best organized and laid out, and most useful instructional/reference type books that I’ve come across in many years. The book covers the most useful array functions and formulas for advanced Excel users, and does it in such a plain, easy to follow and understand manner. Throughout the book, the author is mindful of the reader and how he/she may process an integrate new information. Not only are the example abundant and highly relevant, the formulas are highlighted and zoomed in large fonts so that you don’t strain your eyes trying to read all of the details. It is highly visual without all of the distracting colors that take away from its focus.One of its best features is the “Notes About the Formula…” section that follows each of the complex formula examples which breaks down why you might choose to use a particular formula; what it does and how it does it; and in many cases, how it needs to be entered. This is then followed by a Conclusion section, and some comparative cross reference notes regarding the use of the included Function arguments verssus some others. I can’t say enough about this book. I really ought to be reviewed more widely so that more Excel users are made aware of what they’re missing out on. Thank you Mike “Excelisfun” Girvin for offering such a great product.
hannah kw li –
Not fully concentrate on CSE formula
The book shows many useful info about CSE formula. However, the authur always recomends using alternative functions, and use many resource to explain the functions, instead of using CSE formula. I would like to learn CSE formula and decide to use them or not myselves.
Chuck –
Lots of good information. The only problem I had was that …
Lots of good information. The only problem I had was that some of the examples were using functions that I do not use and probably will never use. That’s not the author’s fault, but lessened the usefulness to me.
Armando –
El libro es muy explícito en cada capítulo, Mike es un excelente profesor y experto en el tema de Excel y más
Nishidha –
Very good book for array workLearning is very easy from this book..I expected to get more functions to know about..Which is lacking..But it involves all magic you can do with an array.. you won’t regret to buy it
Salonikios Robert –
I just received the text and I wish to extend my sincerest gratitude to the staff of Amazon.co.uk for their assistance and follow up in delivering it.The contextual material is very good.Although, I had purchased the electronic version of the text a few weeks ago, I decided to purchase the hard copy as I believe it is worth keeping as a resource to my existing books on the subject of excel formulae.This is the first text I find and buy that tackles the subject of Array formulas.I recommend it to all of those who wish to expand their horizon on the way advanced formulae are constructed and used.Overall, I am very satisfied with the product and the seller service.Robert
peten Constant –
J’y ai découvert des trésors de formules et des fonctions que j’ignorais totalement. Très didactique et expliqué pas à pas.
Luis Gustavo Deyust –
This is go trhough all the concept you have seemn and changes the way you see things on Excel. Good also for intermediates….but I dont think it is for begginers