Nov 30, 2015 - A book/video I have had in my possession for a while is Chandoo's VLOOKUP. The Vlookup eBook (Kindle or PDF version); Example Excel. Dec 25, 2017 - The Vlookup eBook. Excel Vlookup Book by Chandoo, ebook version. What you get? The Vlookup eBook (Kindle or PDF version); Example.
Now I have been an Excel enthisiast and user for around 20 years now, but one of the most talked about features in Excel I have experienced is the VLOOKUP table. I recently changed over offices in my day job, and one of the first things someone said to me when they found out about my Excel exploits was ohhh so you know all about them VLOOKUPS and stuff. Love them or hate them they are awesome in their power of analysis from just a few clicks of the mouse! A book/video I have had in my possession for a while is Well there are actually two versions of this book, there is the actual Ebook and also an Ebook+Video Combo Pack.
![]()
I have used it a good deal and it is a good Excel book, on a specialised subject, which is sometimes just what you need. Excel books can try to cover too much subject matter, but Chandoo really expores the Pivot Table Function well in his offering. It is and warants a review. So here it is – my review ? As I said there are two flavours of the Book, the first is the – downloadable as a PDF or for your Kindle. Included in this bundle is the below-.
The Vlookup eBook (Kindle or PDF version). Example Excel workbook with more than 50 formulas The purpose of the book he states is to give you an understanding of how to answer any data lookup problem using Excel LOOKUP. The book is not overly theoretical but poses problems and walks you through the Excel solutions. He very quickly gets you past the basics of the VLOOKUP, building confidence in understanding the concept from the start. I was impressed with how quick he gets you to thinks about solutions to data lookup situations you may have yourself and moves to expand on the standars VLOOKUP by intoducing the Index Match functions to feel you have even more Data Superpowers! To give you an idea of content here are the details. Who is Chandoo & What is Chandoo.org?.
5 A note about downloadable workbook.7 Oh! Why should you bother reading this book?!? 8 What is VLOOKUP?9 What about LOOKUP, HLOOKUP. 14 Using VLOOKUP with Excel tables.
17 Wild card searches with VLOOKUP. 20 Let’s mix VLOOKUP with Data Validation for fun & wow factor. 22 Look right, look left oh forget!. 26 What is the sales of Joseph in North for product “Fast car' in Jan 2013?.29 I want to lookup my cake and eat it too!.
37 2 way lookups won’t give you hiccups. 41 2nd time lucky? No how about third time?. 46 Lookup Tips & Gotchas. 50 How to learn more about Excel?. 52 Appendix 1: INDEX Formula Explained.
54 Appendix 2: Excel 2013 Data model.55 I loved the Fact there a meaty Excel workbook download to work along with. A must I think for any Excel book or course. The Extra Feature COMBO pack as well as the PDF or Kindle book gives you access the following material below. The Vlookup Book – PDF (right click and choose save as).
Chapter 1: Introduction to VLOOKUP 30mins. Chapter 2: What about HLOOKUP and LOOKUP?
Friends, readers & supporters of Chandoo.org, I am very glad to announce my newest book – the vlookup book to help you become awesome in answering any lookup related question. What is this book? These days, any kind of work involves understand data & answering questions. Whether you are a school teacher or drilling site manager, you are always answering questions like, “What is the GPA of Sam in Grade 6?”, “Who dug the hole number 6925?”. And how do we answer these questions?
Using Excel of course. And this is where the ubiquitous VLOOKUP formula comes in to picture. Along with few other formulas like MATCH, INDEX & SUMIFS, VLOOKUP can let you answer almost any data related question you have. And my latest book helps you do this better.
The vlookup book is a no-nonsense guide to demystifying VLOOKUP formula and its cousins, so that you can answer any question related to your data without wasting too much time. Comprehensive and easy to understand This is a book for everyone who uses Vlookup. Most of us think Oh. I already know the function. But this book will open your eyes to some brilliant techniques which can be used across Excel. If you use Excel but have never used Vlookup, then you need this book desperately. Nitin Paranjape, Microsoft MVP Get your copy of the vlookup book.
Combo Offer How this works? If you are buying from Amazon: Then your payments, delivery and receipts (invoice) are handled by Amazon website. They will send the ebook to your kindle app or device in few minutes after purchase. Everything works like clockwork & magic.
If you are buying from us: Your payments are handled by nice folks at gumroad. They are 100% secure and safe.
![]()
As soon as you purchase, you will receive your payment receipt and a download link to the ebook or vbook. If you are buying the combo pack, keep in mind that it is heavy (350 MB), so give it sometime to download. If you have trouble downloading the file, email us at [email protected] for support.
What do customers say about this book? Read the testimonials. Solid introduction to lookup functionsThis books does a wonderful job of taking each of the lookup functions available in Excel, breaking them down to a simple, easy-to-understand level, and then showing many examples of how these functions work. Things I loved most: – Having an example workbook to follow along with. We all learn better by actually doing the problem, and dealing with Excel is no exception. – Reference links embedded in book. As you read through the chapters, there are lots of hyperlinks to articles that give additional information about different topics.
This adds to the usefulness of this book as a sort of “roadmap” to learning about these functions. =) Chandoo knows that not everyone absolutely LOVES working with Excel, so injecting some humor into the reading helps break up what might otherwise by a dry subject, into a fun read. – Lucas Moraga Excellent Excel Resource Buy it.
I’ve been a longtime student of Chandoo and his new book will not disappoint you. There are other Excel books, but none will explain lookup functions to you in such simple and easy to understand format. If you are really serious about learning Excel (lookup functions make magic happen in your workbook), purchase the videos also. Chandoo has a very straight forward way of teaching in his videos. In addition, go to his website and check out the forums. He has amazing contributors that are quick to respond and help you learn Excel. Why are you still reading this?
Go buy the book!!! – Dana Von Scoy I bought and read your book, including doing all of the homework tasks, within a few hours. I enjoyed it as you have a very engaging style, including your humorous interludes. – Duncan W Bought the book in PDF format and had my first quick look; already have learned some useful tricks. – Matt Healy I got my VLOOKUP book from Amazon yesterday and it looks like a great book! I’m especially impressed by the example file that goes with the book, extremely easy to follow, especially with the formulas shown right next to your examples.
It makes it very easy to translate your examples into my real-world need.Thanks! – John Hi Purna, So glad that you have created this book for people like me who spend lot of time using Excel to conduct basic data mining using VLOOKUP function a lot. – Guru Thank you & Enjoy Thank you so much for your support and encouragement to Chandoo.org. Without you, I could not have written this book and published it. Go ahead and get a copy of the book.
Enjoy it and become awesome in lookup formulas.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |