The Vlookup Book Pdf Chandoo Index
If you are looking for practical, in-depth educational blogs about Excel, you’ve come to the right place. Here are the top 69 best blogs to learn everything about Excel. As you already know, there’s no shortage of awesome content about Excel. However, we decided to separate the wheat from the chaff and hand-pick the very best blogs for you.
Whether you’re brand new to Excel or an “Excel-geek”, these blogs give you all the tools, tips and tricks to skyrocket your skills in Excel as quickly (and easy) as possible. UPDATE (9/1): A few links have been updated (some removed) and a few new blogs have made it to the list. Jon Wittwer / Vertex42 Jon Wittwer is the man behind “Vertex 42”. Vertex 42 is mostly focused upon different Excel-templates, such as, personal budgets and debt reduction calculators. Besides offering a lot of different templates, Jon has also written a lot of tutorials about Excel.
Nov 30, 2015 - The Vlookup eBook (Kindle or PDF version); Example Excel workbook. To expand on the standars VLOOKUP by intoducing the Index Match.
What’s really special about Jon’s blog is the financial scope he has. For example, one of his most popular blog posts is “12 Principles of Personal Finance”. Therefore, you’ll not only find Excel templates and blog posts but also get better at managing your personal finances at the same time. Sounds like a win-win, right? Niels Weterings / Excel Easy Niels Weterings is the mastermind behind the very popular website “Excel Easy”.
As the name implies, Excel Easy is all about explaining the most popular concepts of Excel, easily! Niels started Excel Easy with 2 fellow students at the University of Amsterdam in 2010. Whereas many other bloggers on this list (including ourselves) explain every single detail, Excel Easy cuts right to the chase. If you’re a new or intermediate Excel-user, make sure to check out Excel Easy! The Official Microsoft Excel Blog Recently, Gregory Appel (Product Manager), from Microsoft wrote us if we could include the official Excel blog on the list. Of course, we can, because it’s awesome!
The official Excel blog is very active and covers all news related to Excel – for instance when new features are added to Excel. The blog especially focuses on Office 365 and Excel Online which is a unique angle (and often overlooked), making this blog very cutting-edge. So, if you want to stay up to date on Excel -which we highly recommend – bookmark Microsoft’s Excel Blog and make sure to visit at least a few times a month to stay updated! Savvy Spreadsheets Savvy Spreadsheets is run by Janet Kim Dagostino. Janet has more than 10 years professional experience working with Excel. She sure doesn’t keep all her wisdom for herself – she shares it the world through Savvy Spreadsheets!
Janet has published more than 9 pages of free Excel-related content on her blog. Her primary focus, besides writing blog posts, is Excel templates. Janet believes (very correctly) that way too many Excel templates are too “spreadsheet-y” and hard to use for the average Excel user. Janet wants to change that! So, if you’re into templates and awesome blog posts, make sure to check out Savvy Spreadsheets. ExcelMadeEasy ExcelMadeEasy was created in 2008 by Laurent Winterhalter with the purpose of sharing its fascination with this great tool.
ExcelMadeEasy provides some great tutorial from basics to more detailed ones like on VBA, step by step examples, as well as many templates going from simple invoice to more complex task tracking lists, budgets, mathematical function drawing templates. The project management and business development parts are being updated on a regular base and are full of great content.
We’re positive you’re going to love ExcelMadeEasy! The Team at Analytics Demystified Behind the website “Analytics Demystified” is the founder, Eric T. Peterson, along with his team of 7 other engaged employees all striving to make data actionable. The blog isn’t an Excel exclusive blog, but the tool used on their blog is quite often Excel. The blog is very often updated with exciting topics such as “The power of combining number formatting and conditional formatting in Excel” and “Excel dropdowns done right”.
This blog mostly caters to the intermediate and advanced users. The approach in all blog posts are very analytical and step-by-step explained which we like a lot. If you are into analytics, big data and Excel, “Analytics Demystified” should be in your bookmarks already! Purna Duggirala / Chandoo Purna Duggirala – better known as Chandoo – is one of the most famous and contributing bloggers about Excel. What is really awesome about Chandoo is the diverse range of topics he’s written about. From tutorials about basic Excel to advanced training, dashboards and VBA.
Whatever you can imagine, there’s a pretty good chance Chandoo has you covered. Chandoo was one of the very first blogs we started reading when beginning our path toward Excel-mastery. Be sure to visit his website, bookmark it – you definitely won’t regret it! Bill Jelen / MrExcel Bill Jelen runs MrExcel which is Bill’s online place where he shares all his expertise with his lucky readers. Having more than 29 years of experience with spreadsheets, Bill is unavoidable when it comes to Excel bloggers.
Currently, Bill has written more than 40 books in Excel (how does he get the time?). Not only is he an author, but also a speaker frequently traveling the world sharing his knowledge and love of spreadsheets. Be sure to check our MrExcel as well as the (very) active message board. Jon Peltier / Peltier Tech Blog Jon Peltier blogs at “Peltier Tech Blog”.
Jon has been a full-time Excel developer for more than 10 years, refining his Excel-skills along the way. Jon’s educational background is just as impressive as his Excel-skills, holding a Doctor of Science degree from MIT. Jon’s blog is definitely for the advanced users of Excel who in turn can extract an immense amount of value from his blog.
However, the blog isn’t only full of advanced topics concerning statistics and plotting data, more newbie-friendly posts are also to be found. One of his most popular blog posts about is very much worth a read.
Debra Dalgleish / Contextures Debra Dalgleish is the owner of Contextures – a blog (and consulting company) with its roots in Canada. Debra has been an Excel MVP since 2001, which is really not surprising when you start reading her content. Ranging from Excel files, videos (and, of course, her blog), Debra has also released 3 books about. We think it’s fair to say that Debra has a soft spot for pivot tables, so go check out her blog if you want to learn more about these powerful things called pivot tables. Bastien Mensink / ASAP Utilities Bastian Mensink is the creator and blogger at ASAP Utilities. ASAP Utilities is a very popular Excel Add-in that helps you save time and makes Excel do things that it normally can’t. However, it’s not just because of ASAP Utilities Bastien has been picked as one of the best Excel bloggers, but also because of his blog (obviously).
Here beginners in Excel can learn the ins and outs of the program in an easy-to-follow pace. His tips and tutorials are very practical. Evans / Exinfm Matt H. Evans is the creator of “Exinfm” (short for “Excellence in Financial Management”).
Free Book Pdf
Exinfm is the place where businesses go when they need to improve how they look upon analytics and metrics. Matt has published so much information, that it’s hard to boil it down to a few sentences. From books to courses about financial modeling to dozens upon dozens of templates. There’s absolutely no question about Matt’s cunning and we highly suggest you go check out his website right now! John Walkenbach / The Spreadsheet Page John Walkenbach is the creator of The Spreadsheet Page. John has written more than 300 articles for popular PC magazines and has published an astounding number of 50 books about – yeah you guessed it – spreadsheets.
Free Ebook
John has also developed several Excel add-ins and is a Microsoft MVP. His blog is not for the absolute beginner, but for the intermediate to very advanced. His guides always include a lot of screenshots, which makes it easier to grasp the rather complex subjects.
Well done John! Chip Pearson / Pearson Software Consulting Chip Pearson ran the popular website Cpearson.com where he wrote about a wide range of topics concerning Excel. Unfortunately, in an accident in April 2018. Chip published around 500 topic pages all covering Excel. Chip’s content is primarily aimed at the more intermediate user, however, beginners and experts are sure to find great material too. Where Chip’s blog really excels, is the content about VBA.
Head over to Chip’s blog right now and be sure to check out his topic index and you’ll quickly see why this website is a perennial resource of Excel-information. Dave Hawley & Raina Hawley / Ozgrid Business Applications Dave Hawley (now deceased) and Raina Hawley are the creators of “Ozgrid”. Ozgrid is an Excel-development business, where you can get specialized applications developed for your business. Furthermore, Dave and Raina has also published books and have a highly active forum.
You’ll also find free Excel video tutorials, detailed explanations of most Excel functions and formulas as well as dozens of templates. Basically, Ozgrid is a powerhouse of Excel information and we highly suggest you go check it out! AbleBits Behind “AbleBits” is a very ambitious team creating high-quality content about Excel.
In our opinion, they write some of the very best content on the internet about Excel. Every guide is so well thought trough and executed. If you were going to read just one Excel-blog for the rest of your life – let this be it (and ours of course!). With 100s of tutorials, you are sure to find awesome content not just about Excel, but also about PowerPoint and Outlook.
The content tends to err on the side of the intermediate to advanced, so be sure to know what a spreadsheet is before reading their blog! Dick Kusleika / Daily Dose of Excel Dick Kusleika runs the awesome blog “Daily Dose of Excel” where you get daily tips and tricks for Microsoft Excel (Access also gets mentioned frequently). The blog started back in 2004 and ever since Dick – and his team of other awesome writers – has been contributing with great information about Excel. The blog covers several different topics such as automation, formulas and VBA. If you already have some experience with Excel and know your way around a spreadsheet, we highly recommend you go check out the blog right away! Ken Puls / Excelguru.ca Ken Puls runs Excelguru.ca which is a great place to explore if you are really looking to up your game in Excel. At Ken’s site, you won’t find any rushed guides.
All guides are thoroughly written (and tested) and are definitely for the advanced Excel user and developer. If you have several years of Excel-experience under your belt, reading Excelguru.ca is an absolute must.
Besides all the great blog posts, there’s also a huge, active community at Excelguru.ca so be sure to check that out too! Charley Kyd / ExcelUser Charley Kyd is a Microsoft MVP who blogs at “ExcelUser”. Charley has been using spreadsheets since almost forever (35 years) – even before Excel was invented!
He is also the proud creator of the first spreadsheet dashboards and the author of several books and articles published in magazines like Inc. And PC World. Charley writes about many diverse subjects about Excel and there’s so much great information to extract. The blog has many great articles, especially about dashboards (obviously), formulas and functions for more or less all skill levels. Whether you’re a novice or more experienced with using spreadsheets, there’s heaps of information to be extracted from Charley’s blog.
Daniel Ferry / Excel Hero Daniel Ferry runs the blog “Excel Hero” and is a Microsoft MVP. As Daniel bluntly states “The point of the site is to give you the inspiration and knowledge to become an Excel Hero in your workplace. As a tool, Excel is not used anywhere near its potential by 99.999% of its users”. Daniel’s fix? His awesome blog of course!
Daniel has written more than 120 articles about almost anything from dashboards, PowerPivot and VBA. Daniel also runs a very popular LinkedIn group with more than 7.000 members.
Nice work Daniel! Go check out his blog now.
The Team at ExcelWithBusiness “ExcelWithBusiness.com” is an awesome resource for learning Excel. Behind the website is currently a team of 21 employees, all highly motivated towards bringing you awesome content about Excel. The blog is full of great practical tutorials, such as “When Life Offers You Lemons, Do You Invest?”.
The tutorials about Excel are down to earth – and that’s what really makes this blog stand out. ExcelWithBusiness makes it easy to integrate Excel as part of your business processes and planning.
Go check them out if you’re interested in entrepreneurship or already have your own business! Andy Pope Andy Pope is definitely a guy to follow when it comes to learning Excel. For 12 years straight, Andy has been named an MS Excel MVP and it’s not hard to see why! He’s created an absolutely astounding number of tutorials concerning Excel. There’s information from everything to charts, general tips and tricks, VBA and – perhaps one of the funniest categories – “Fun and Games”. Be sure to check out all his categories. Despite many MVP’s creating very advanced content, Andy also has something for the most casual user of Excel which we really like.
Benjamin Currier / Excel Exposure Benjamin Currier is the man behind “Excel Exposure”. At Excel Exposure, you’ll find heaps of free information, for example, an entirely free online Excel course. This free online course in itself is reason enough for you to go check out Benjamin’s website right away and bookmark it! The course contains information for the beginner, intermediate and expert. Not only is there a lot of lessons, each lesson consists of videos making it highly enjoyable and easy to learn Excel.
Mike Alexander / DataPig Technologies Mike Alexander started “DataPig Technologies” back in 2004 with the ambition to help improve the data analyst community’s skills. Mike is a (perhaps not surprising!) MVP and has written several books on advanced business analysis using Microsoft Access and Excel. Mike’s blog – called Bacon Bits (we love that name) – is primarily for the most advanced users of Excel and Access. He writes about VBA, business statistics, add-ins, charts and a whole lot more! We really like the way Mike accomplishes to explain rather complex subject matters in an easy to digest and fun way – always using a lot of illustrations. Keep it up Mike and be sure to check his website out. Jorge Camoes / Excel Charts Jorge Camoes runs the blog “Excelcharts.com”.
As you’ve probably already guessed, this blog is about visualizing data – or perhaps, even more, saying, “knowing how to make sense of data” as Jorge writes on his blog. Jorge’s blog is always really up to date and a great resource when it comes to making data actionable. If you work with data and want to make sense of it, be sure to check our Jorge’s blog (especially his post about the classification of chart types is great!). Phil Treacy and Mynda Treacy / My Online Training Hub Phil Treacy and Mynda Treacy is an awesome couple, who both loves Excel (Word and Outlook too!) and blogs at “My Online Training Hub”. As you’ve probably guessed, My Online Training Hub is focused on helping you get as good at Excel at quickly and easy as possible.
My Online Training Hub does offer paid material – which looks really great – but they give most of their content away for free. Their website is really well designed and so are their tutorials on the blog. Many Excel-bloggers often “forgets” to use images, but not Phil and Mynda. A big thumbs up from us – be sure to check them out! Adrian Miric / Audit Excel Adrian Miric is the creator of “Audit Excel” which is a consultancy focused on the safe and efficient use of Excel.
The ambition of the website is to be the one-stop shop for all Excel users’ requirements, and they have certainly done an effort to live up to this ambition! On the website, you’ll find 22 pages full of videos explaining different situations in Excel.
The videos range from 2-5 minutes and is an efficient (and free!) way to learn Excel (so is the blog too). We highly suggest you go check it out! Jeff Lenning / Excel University Jeff Lenning is a Microsoft Certified Trainer, who loves helping people get productive and efficient in Excel. Jeff has been featured in numerous magazines and is a bit of a “number crusher” having been a senior financial analyst.
Excel University has everything from online training, books and, of course, a well-updated blog with close to 200 blog posts (all published by Jeff as far as we have seen). Despite many Excel blogs primarily catering to the advanced users of Excel, Jeff makes it easy for beginners too by describing his ways in Excel very carefully always including heaps of screenshots. Excel University’s blog is a great place to start out for the beginner and advanced user.
Glen Feechan / Not Just Numbers Glen Feechan is the person behind “Not Just Numbers” and has been publishing blog posts since 2008. What we really like about Glen’s posts is his practical, step-by-step approach to explain Excel. If you’re new to Excel, Glen’s blog has a lot of great tutorials. Just to mention a few, Glen’s written about, how to make the same change to multiple worksheets, explanation of the most important functions and so on. In short, go check out Glen’s blog if you’re new to Excel! Jordan Goldmeier / Option Explicit VBA Jordan Goldmeier is the creator of “Option Explicit VBA”. Jordan’s blog is about dashboards, VBA, data analysis, operations research and visualizations.
Jordan is a busy guy having published books about dashboards in Excel as well as advanced Excel essentials, doing consulting, speaking and obviously blogging too. Jordan’s blog is for the intermediate user, who is looking to step up his skills in Excel. In the tutorials you’ll find plentiful of examples and images, that makes the rather complex subjects a lot easier to understand and use.
Tom Urtis / Atlas Programming Management Tom Urtis is the creator of “Atlas Programming Mangement” – a consulting company focusing on primarily Microsoft Excel. Tom Urtis is also an Excel MVP and has been blogging about Excel since 2011. Despite Tom and Atlas Programming Management being Excel developers, the blog is full of tutorials even beginners in Excel can extract a lot of value from. Problems such as “evaluating numbers as whole or decimal” and “using VLOOKUP with MIN, MAX and Average” are answered on the blog.
Even though Tom hasn’t published that much content on his blog recently, his published content has certainly withstood the test of time and is just as important now as it was when published. Jon Acampora / Excel Campus Jon Acampora is the creator of “Excel Campus” and a self-proclaimed “Excel geek”. Jon’s ambition with Excel Campus is to help you learn Excel so that you can work smarter and save time (that’s an ambition we really like!). Jon is truly passionate about Excel and has (much deserved) been named an MVP by Microsoft. All of his tutorials on the blog are explained in a way so that even the beginner can follow along by using a lot of screenshots as visual aids as he goes along.
Oscar Cronquist / Get Digital Help Oscar Cronquist is the creator of “Get Digital Help” (and a fellow Scandinavian!). Oscar writes about anything from automation, charts, conditional formatting, tables and VBA. Some of his most popular articles include creating dynamic charts, list of random unique numbers and auto refresh pivot tables. The breadth of content is wide and accessible, even for the beginner. All tutorials are well written, include a lot of images (which we love) and are very concise.
Furthermore, Oscar is very active in the comments section helping people out with their problems. Be sure to check out Oscar’s blog! Nick / ExcelExperts.com Nick launched “ExcelExperts.com” back in 2008 and has put an enormous amount of effort into publishing great content about Excel ever since. Nick is a proponent of prototyping systems in Excel, as this can be done very cost-efficiently and quickly. Nick has created 100s of free training videos about the basics of Excel as well as more advanced subjects such as VBA and finance. If that’s not enough, you’ll also find heaps of free spreadsheet templates as well as a thriving community of Excel-users on his forum, always very willingly to lend out a helping hand.
Rory Archibald / Excel Matters Rory Archibald is a self-proclaimed “Excel addict”. Luckily for Rory, being an Excel addict is perhaps not the worst thing in the world?! Since 2007, Rory has been a Microsoft MVP. Rory’s most popular posts are about VBA. One of his posts that we really like is his guide to the best Excel forums on the web.
Rory both lists some of his favorite forums as well as providing guidelines as to how you should ask and behave in these forums. Great guidelines, that will most certainly help you get much better answers and solutions to your problems. Ayush Jain / DiscussExcel.com Ayush Jain is an Associate Manager at EY and was awarded Microsoft MVP in 2010-2011. He is visiting faculty in many reputed institutes and an expert in training Excel, more specifically VBA. Ayush is passionate about spreading knowledge about Excel and has even created a Google Group (called “MS Excel and VBA Macros”) with more than 8.500 members!
Quite a feat if you ask us. Ayush has been busy writing a lot of tutorials about Excel. The tutorials are for both beginners, intermediates and experts. We really like his introduction to macros that you can read and learn for free at his website. Zack Barresse & Kevin Jones / ExcelTables.com Zack Barresse and Kevin Jones are the creators behind “ExcelTables.com”.
As the name implies, this blog is all about Excel tables. It’s, therefore, no surprise, that Zack and Kevin also have published a book about tables too. The blog isn’t solely about tables, but also, general Microsoft Office updates and important going on in the realm of Microsoft. One of their latest posts about the release of Office 2016 meticulously analyzes the recent changes to Office 2016 and what’s good about the new software – and what is less desirable.
Gašper Kamenšek / Excel Unplugged Gašper Kamenšek is the creator of the blog “Excel Unplugged”. Gašper uses Excel daily and shares his findings on Excel Unplugged. Excel Unplugged is a great place to be if you’re a beginner or intermediate to Excel.
What we really like about Gašper’s blog is the very intuitive menu that highlights the different subjects he’s written about. Every tutorial is also very well illustrated with step-by-step actions, which makes it a lot easier to follow along and actually learn something!
Mike Girvin / Excel Is Fun Mike Girvin is the creator of the very popular YouTube-channel ExcelIsFun. Mike, unfortunately, doesn’t have a blog, but we simply couldn’t create a list of the most awesome Excel blogs, without mentioning Mike. His YouTube-channel includes more than 2.500 videos with almost 60 million plays (!), Mike is one of the leading authorities in learning people Excel. And it’s no coincidence! His videos are very educational, without being boring (which is quite an achievement in the realm of Excel).
We highly suggest you go check out Mike’s videos on his YouTube channel right now! Chris Newman / The Spreadsheet Guru Chris Newman from The Spreadsheet Guru was one of the first people, we stumbled upon when we created our blog. Chris has also been so nice, to let us publish a guest article on his site. Overall, Chris is an absolute machine, when it comes to Excel. His blog primarily caters to advanced users of Excel.
What’s really unique about Chris’ site is, that he programs add-ins for Excel himself, for example, a. So if you’re looking for advanced topics such as VBA and macros, definitely go check out Chris’ blog! Oz du Soleil / DataScopic When we first published this guide to the best Excel-bloggers in the world, somehow we hadn’t stumbled upon Oz. A few hours after this list being live, we started receiving several messages about adding Oz to the list. And of course, Oz deserves to be on this list. Besides having an awesome sense of humor, he’s quite the character!
What Oz accomplishes, that few others don’t, is to talk about Excel and spreadsheets with such a burning passion that is so contagious! Oz’s content is really unique and we highly suggest you go check him out right away! Especially his video tutorials (found by clicking “Tutorials” in the menu) are so much fun and full of value. Liam Bastick / SumProduct SumProduct is a website brought to our attention by a fellow Spreadsheeto reader (thanks, Jorge!). If you’re an intermediate/advanced user of Excel, you probably want to go ahead right away and visit SumProduct.
Tibco ems windows. Because their content is really great for the advanced Excel user! From data tables, chart labels all the way to concatenation, SumProduct is definitely a place you want to check out (you can even submit a question if you click “Thought” in the menu). Grab a cup of coffee and upgrade your Excel skills now!
Jeff Robson / Access Analytic Jeff Robson is the CEO of Access Analytic. Access Analytic is the home of many, great free resources about Excel. The site has anything from free Excel templates, tests, white papers and ebooks. Access Analytics is especially interesting for the intermediate business user of Excel, where we’re sure blog posts such as “6 Signs your Financial Model Needs Auditing” will sure ring your bell! Besides the more financial focused topics, the blog also runs through some of the latest additions to Excel 2016 such as. Rick Grantham / EXCELTV Rick is the owner of Excel TV, which is the home of more than 40 interviews of Excel experts from all around the globe.
Just by watching a few minutes of Rick’s interviews, you can feel his (and the guests!) passion for spreadsheets. Not only has Rick produced more than 40 interviews, Excel TV is also the home of a frequently updated Excel blog. Besides each blog post being well-illustrated and beautiful, they are also often complimented by a video. A great (and quite unique) mix. Excelxor Excelxor is the home of the writer XOR LX (we weren’t able to find the exact person behind the site.
If you know him, let us know!). We were made aware of Excelxor by fellow Spreadsheeto reader (who also has a great blog btw!). We think his description of Excelxor is much better than anything we could write: “Hi guys, nice work on Excel blogs list, but you’ve missed excelxor.Com.
This guy is a MASTER in excel formulas”. Of course, this caught our attention and upon closer inspection, we can nothing but agree with Maxim’s words! Excelxor is full of Excel-wisdom and is definitely a blog to bookmark and read closer!
Kevin Lehrbass / My Spreadsheet Lab Kevin Lehrbass is a Data Analyst in Toronto. His most common thought is “can I solve this in Excel?”.
Kevin likes to consider different approaches when solving an Excel puzzle. It might be a single array formula or a series of formula helper columns to reduce the complexity so that a beginner can understand. He occasionally plays around with VBA (‘Add check boxes using VBA’). His blog contains a variety of posts for different skill levels as well as several creative uses of Excel (‘Font Formatter’, ‘Closest Super Bowls’, etc). Michael Grogan / Data Scientist Michael Grogan is a data science consultant and educator specialising in Python, R, and SQL.
His educational background is a Master’s degree in Economics, and as such he has a particular interest in the application of data science to implementing business solutions. His work has been featured on Data Science Central, Sitepoint, and O’Reilly’s Safari Platform.
Michael’s website provides advanced tutorials on how these languages can be used for data manipulation, as well as data science and machine learning. So, if you’re well-versed in Excel, and ready to go beyond spreadsheets, “Data Scientist” is the right place to be looking!
Index Vs Vlookup
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?