EXCEL FORMULAS

11 Reasons Why You Should Check Out The VLOOKUP Book From Chandoo.Org

by Brad Edgar | Jul 11, 2014 | EXCEL ADVANCED, LEARN EXCEL FORMULAS

I recently purchased a copy of Chandoo’s The VLOOKUP Book and realized that it was the first piece of material that I had read that covered pretty much all of the bases when it came to the Vlookup formula and other lookup formulas in general. Because I was able to learn something from this book I figured you may be able to benefit from purchasing the book. Since I believe in Chandoo’s products and what he is doing, I decided to become an affiliate (the links in this post are affiliate links) and to provide you with some insight as to whether or not it may be something that you are interested in. I will say that although the book is not perfectly written, it does a great job at showing all of the available options that you can use to run lookup formulas in Excel.

My hope in this post is to provide you with an overview on what this book has to offer. Let’s get started with our 11 reasons and if you have any questions about the book or about the Vlookup formula in general, please feel free to leave any comments or to email me at brad@bradedgar.com.

By the way please be patient with the page slider below, it does take a little bit of time to load.

CHECK OUT THE VLOOKUP BOOK

REASON # 1

You’ll Learn How to use Vlookup to Lookup a Value and Find Corresponding Information About that Value

REASON # 2

You’ll Learn What the True vs. False Portion of the Vlookup Statement Truly Means and How To Use it

REASON # 3

You’ll Learn How to Use the IFERROR and IFNA Formulas with Vlookup to Display Any Value you Please If Your Formula Doesn’t Not Find a Match

REASON # 4

You’ll Learn How to Find the Second Item in a Lookup List When there Are Multiple Items

REASON # 5

You’ll Learn How to Use LOOKUP and HLOOKUP Formulas

REASON # 6

You’ll Learn the Benefits and How to Use Excel Tables with the VLOOKUP Formula – This Will Save You Time and Effort

REASON # 7

You’ll Learn How to Use Wildcards (abbreviated queries) with the Vlookup Formula Using *

REASON # 8

You’ll Learn How to Use Vlookup with Data Validation Lists, Name Ranges, Tables To Build Slick Dashboards

REASON # 9

You’ll Learn How to Preform Lookup Formulas When the Data That you Are Looking for is to the Left of Your Lookup Column

REASON # 10

You’ll Learn How to do Lookups Based on Multiple Conditions By using Formulas like SUMIF, SUMPRODUCT, INDEX MATCH, AND SUM and you Will Also Learn the Best Method.

REASON # 11

You’ll Learn How to Use Helper Columns with Vlookup to Find the Results You Are Looking For.

Excel Custom Number Formatting: Turn your values into K (Thousands)

by Brad Edgar | Feb 25, 2014 | EXCEL IN 60 SECONDS, EXCEL INTERMEDIATE, LEARN EXCEL FORMULAS, LEARN EXCEL SHORTCUTS

Happy Monday everyone! This is another very quick post about how you can use some of Excel’s awesome functionality. In this post I want to show how to use Excel custom number formatting to format a range of numbers into thousands (k). Simply follow the steps below and you’ll be right on your way. If you have any questions, feel free to leave a comment. (more…)

Excel Shortcuts: Use Alt + = to Automatically Sum Cells

by Brad Edgar | Feb 10, 2014 | EXCEL BEGINNER, EXCEL IN 60 SECONDS, LEARN EXCEL FORMULAS, LEARN EXCEL SHORTCUTS

This is just another quick and simple shortcut that you can use to make your life a little bit easier. Use Alt + = to automatically add/sum a range of cells.

(more…)

Using Excel Vlookup With Shapes and Data Validation: Building a Dynamic Salesman Dashboard (Part 2)

by Brad Edgar | Jan 29, 2014 | EXCEL ADVANCED, LEARN EXCEL DASHBOARDS, LEARN EXCEL FORMULAS

Before I get started, I had a reader mention that in versions 2007 and greater you can use Excel Tables to build dynamic data validation list which is definitely another great way of handling a validation list in Excel. (more…)

Excel Data Validation List: Building a Dynamic Salesman Dashboard (Part 1)

by Brad Edgar | Jan 23, 2014 | EXCEL INTERMEDIATE, LEARN EXCEL DASHBOARDS, LEARN EXCEL FORMULAS

Over the next couple of weeks, I will be building a dynamic salesman dashboard that allows the user to interact with the spreadsheet to get the information that they need. This post will first focus on building a data validation list that will immediately make the spreadsheet interactive. (more…)

Sumproduct Vs. Excel Pivot Tables: Which Method is Best for Calculating Highest Monthly Production Scrap Value

by Brad Edgar | Dec 18, 2013 | EXCEL ADVANCED, LEARN EXCEL FORMULAS, LEARN EXCEL PIVOT TABLES

Getting the answers to your most important business questions is imperative for achieving success. Being able to find the answers to your questions can quickly give you insight into what business processes and procedures need to be fixed in order for you to lower your costs and maximize your returns. In this post we look at using Excel Pivot Tables versus the SumProduct formula to calculate which month had the highest production scrap within a given year. Being able to get this information can allow management to dig deeper into why a given month had such a high volume of scrap and help address issues that may have caused the spike. (more…)