"Ctrl+Shift+Enter" by Mike "ExcelIsFun" Girvin [eBook ]

SKU: 263
Price:
$19.95
Qty: - +
   - OR -   


"Control+Shift+Enter: Mastering Excel Array Formulas" 
by Mike "ExcelIsFun" Girvin - eBook

Command The Power of the 'Array Formula' in Microsoft Excel!

Although elusive, Array Formulas can be used to solve everyday Excel problems. If you need to figure out how many times your birthday fell on a Friday, an Array Formula can solve that. If you need to return a unique list of sales reps from a Database, an Array Formula can solve that.

How does this book approach Array Formulas? 
 
This book systematically lists ...Read More.

Does the book differ from the DVD of the same title? Yes
"The DVD 'Ctrl+Shift+Enter: Mastering Excel Array Formulas' is a separate product from this book. The two products cover the same broad topics related to creating efficient array formulas. However, the video has kinetic visuals of how array formulas work and less detail than the book. The book has a more complete story and systematic presentation of array formulas. If you really want to master array formulas, study both the book and the DVD."
 
Note: this version with the blue cover is a new improved printing in July 2016. We've tightened up the layout and added a few pages about Excel 2016 functions. But 99% of the book is the same book as the yellow/green cover. 
eBook: 308 Pages
ISBN: 978-1-61547-209-3 (pdf)
ISBN: 978-1-61547-329-8 (epub)
ISBN: 978-1-61547-109-6 (mobi)
G.maheswara reddy on 02/14/2014 06:31pm
Excel
hemsh joshi on 09/06/2013 02:05am
The ONLY BOOK to Learn Array in a simple and conceptual manner. Mr.Mike Excelisfun Girvin you have really done a great job and I wish you keep doing the same. Array used to frighten me, now in just one day itself i started loving them and that's all because of you. Before this book life in excel with array was =offset(A1,-1,-1)=#REF! but now its =LARGE. Thanks a Lot
pmsocho on 07/24/2013 05:38pm
I'm a huge fan of ExcelIsFun. I learned a lot from him through his YouTube channel. If you haven't been there yet - GO!

So when Mike Girvin published news about the array formulas book I was looking forward to it. I was about to buy a paper copy but since the e-book version became available first - I went with it.

I have been using Excel for a several years so my experience with this application is quite a big. Before I read the book I could create some array formulas but because there was no good documentation out there - my knowledge on that was inconsistent and with gaps.

This is the first book about array formulas from the beginning to the end out there on the market!
It's a very good reference to this topic.

Is this book for you? - If you are dealing with regular formulas well and want more - then yes, definitely!

If you haven't written any array formula yet - do not worry - you will, but you are supposed to be more than a beginner in Excel otherwise the book will be too hard for you.

You will not find stories in this book! Just knowledge. Pure knowledge on writing array formulas and efficiency.

Array formulas aren't the gold solution for everything. Mike compares them to pivot tables, regular formulas with helper columns, database functions, advanced filter and others to find the most optimal solution to the problem (or the situation you have got). He is also timing the formulas calculation to show which solution is fastest and most efficient. In almost every example Mike describes advantages and disadvantages of varions solutions in a tabular, easy to read form.

I have read first half of the book in 2 days :) Even though I knew most of the stuff, I found a lot of small, usefull information I didn't know before. That information filled the gaps I mentioned earlier. The second half of the book gets more hardcore so I spent more time on that :)

The rule for the book is simple - the bigger page number is, the more advanced formulas and solutions you can find :).

The important thing - you can download the files accompanying the book. And what is more important - the files are well prepared and consistent with the book (I also bought Rob Collie's book on PowerPivot - the files for that book are a little mess for me and the book doesn't have good references to those files).
pmsocho on 07/23/2013 03:07pm
I'm a huge fan of ExcelIsFun. I learned a lot from him through his YouTube channel. If you haven't been there yet - GO!

So when Mike Girvin published news about the array formulas book I was looking forward to it. I was about to buy a paper copy but since the e-book version became available first - I went with it.

I have been using Excel for a several years so my experience with this application is quite a big. Before I read the book I could create some array formulas but because there was no good documentation out there - my knowledge on that was inconsistent and with gaps.

This is the first book about array formulas from the beginning to the end out there on the market!
It's a very good reference to this topic.

Is this book for you? - If you are dealing with regular formulas well and want more - then yes, definitely!

If you haven't written any array formula yet - do not worry - you will, but you are supposed to be more than a beginner in Excel otherwise the book will be too hard for you.

You will not find stories in this book! Just knowledge. Pure knowledge on writing array formulas and efficiency.

Array formulas aren't the gold solution for everything. Mike compares them to pivot tables, regular formulas with helper columns, database functions, advanced filter and others to find the most optimal solution to the problem (or the situation you have got). He is also timing the formulas calculation to show which solution is fastest and most efficient. In almost every example Mike describes advantages and disadvantages of varions solutions in a tabular, easy to read form.

I have read first half of the book in 2 days :) Even though I knew most of the stuff, I found a lot of small, usefull information I didn't know before. That information filled the gaps I mentioned earlier. The second half of the book gets more hardcore so I spent more time on that :)

The rule for the book is simple - the bigger page number is, the more advanced formulas and solutions you can find :).

The important thing - you can download the files accompanying the book. And what is more important - the files are well prepared and consistent with the book (I also bought Rob Collie's book on PowerPivot - the files for that book are a little mess for me and the book doesn't have good references to those files).

Add Your Review


Your Name:
Email Address:
Review:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Verification:
Your Name:
Your Email:
Friends Name:
Friends Email:
Message:
Verification: