Learn more Download now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Learn More Learn more Shop Fire Shop Kindle Learn More Shop now Shop now Learn more

on 22 November 2014
but in reality it deserves about 5000 stars. (I have no connection whatsoever with the author or publishers)
It's quite clear very quickly when you start working your way even through the early part of this book, that it's the product of an amazingly thorough and clear mind that really understands Excel. It also has a lovely and very friendly authorial voice. Mike Girvin is a brilliant Excel expert, who is constantly giving credit to the people on Mr Excel forum who helped him understand this trick or that.
This book is a very logical and really well laid out set of chapters on how to do increasingly clever and very powerful bits of data analysis (compiling highly selective counts and sums, excluding, including criteria in your calculations etc..) using only formulae (no macros). That is not a failing, if you want data in a column a formula is in the very DNA of Excel and the right way to go. Macros are essential as well, but you'd do well to be a formula black belt, before you tackle macros, because your macros will be that much more powerful.

The book is mainly but not exclusively about Array formulae. It explains with crystal clarity when you need an Array Forumla (using ctrl-shift-enter) and when you don't and has many explanations of how to get the same ends and avoid Array formulas. Because, in reality most people neither like nor understand array formulae, so when you can get the same formula result, without having to use an array formula, it's better to do it that way. It compares Array and non-array formuale to pivots and filters and advanced filters and even has stats on timing and which methods are powerful but slow, versus powerful (and maybe more complex) but really fast.

I'll say a couple of other things to put this book in context. This is from the stable of Mr Bill Jelen, who himself is a very fine author, but other books in the series are about Powerpivot and they are woeful in comparison to this one, so do NOT be put off this book if you have been put off those other ones.
Mike Girvin's download files for this book, are a masterclass in having well thought out examples in exceptionally well organised workbooks. (Rob Collie's download files are truly awful in comparison)
If that wasn't enough Mike Girvin has a Youtube channel where he goes through this book's entire curriculum (with a video in for each chapter, several hours worth in total) and entirely for free.

If you work your way though this book and his videos and truly digest and understand what he is explaining (there is a lot to digest) you will advance to the front-rank of Excel formula masters. All that for £16 is a steal.

My own advice is that it would take months to properly be able to understand this book from cover to cover, but that that effort would enable you to handle some truly challenging Excel situations, and for most of us, that means make us far more effective in our jobs.
A big and heart-felt thank you to Mike Girvin for all that!

this book is really all pros except for my one and only con,
his increasing side boxes of Excel "Array Formula Rules" and a whole chapter recapping the rules, is a bit overwrought, it could have done with more editing and clarity, but that's it, the examples are supreme if you internalise them and what Excel allows you to do with formulae, you won't regret buying this book.

Thank you for reading this far, I quite realise that this is a long review, but I wanted to do justice to a work of enormous quality that really deserves a proper review.
0Comment| 4 people found this helpful. Was this review helpful to you? Report abuse
on 4 January 2014
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.
0Comment| 2 people found this helpful. Was this review helpful to you? Report abuse
on 6 December 2013
This is a compressive guide for Excel users. It is easy to read and contains an amazing amount of information presented in a clear and easy to understand manner. There is something for all including those that have a very good knowledge of Excel. I have learned more here (and Mike's Youtube channel) than all other sources. I am now more competent than 90+% of the otherusers in our office of 200 people. Get this book it is worth every penny.
0Comment| 2 people found this helpful. Was this review helpful to you? Report abuse
on 8 March 2014
Great book, amazing stuff! Compliments his videos on YouTube. Mike is a really great teacher. This is a must have as I don't know of any other book dedicated to array formulas.
0Comment| 2 people found this helpful. Was this review helpful to you? Report abuse
on 31 July 2014
The contents of the book is brilliant but the actual physical quality is a bit like a cheap black and white photocopy in a posh cover. According to the text the diagrams are in colour but mine are black and white. So 5 stars for content, 1 star for quality and 3 stars on balance.
0Comment| One person found this helpful. Was this review helpful to you? Report abuse
on 30 November 2013
Feels like paying a debt back pay for this book after all the free you tube help this guy gives for free the book is also excellent if you want to learn buy this
0Comment| One person found this helpful. Was this review helpful to you? Report abuse
on 16 December 2013
If you follow Mike "Excellsfun" Girvin on his YouTube channel, then this book is for you. Full of useful tips and short cuts using arrays. There is even a downloadable excel sheet so you can follow it using excel at the same time.
Good follow up to Slaying Excel Dragons.
0Comment|Was this review helpful to you? Report abuse
on 23 December 2016
The book is fine and the explanations are good. However, not happy that I viewed a coloured book before purchase and received a black and white version. Okay it does the job but they should not be advertising a coloured version if it's not available.
0Comment|Was this review helpful to you? Report abuse
on 25 February 2015
A good insight into Excel's capabilities that is fun! Be prepared to have to do some work on the technicalities involved. Do not buy this unless you are a fairly able User of Excel as the details my boggle you. Good add-on though.
0Comment|Was this review helpful to you? Report abuse
on 23 May 2014
I will recommend to buy this book everyone who watns to improve Excel skills. This book is easy for reading and the author explains how to create formulas in every detail.
0Comment|Was this review helpful to you? Report abuse

Sponsored Links

  (What is this?)