In a previous post, we looked at some of the limitations of XLOOKUP() and other Excel "duct tape" lookup functions. Relational joins in Power Query were introduced as a more robust alternative. This …
How to understand relational joins in Excel Power Query
In my book Advancing into Analytics I called VLOOKUP() the "duct tape of Excel:" Technology tactics move quickly. Excel now offers XLOOKUP() as a modern alternative to VLOOKUP(). But the theories …
Continue Reading about How to understand relational joins in Excel Power Query →
How to understand the RELATED()
function in Excel Power Pivot
Power Pivot is a fantastic tool that lets you build relational models right from Excel. This negates the "death by VLOOKUP()" that many large workbooks face -- defining relationships across multiple …
Continue Reading about How to understand the RELATED()
function in Excel Power Pivot →
Three-way lookups in Excel with SUMPRODUCT()
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
Slideshare: “VLOOKUP: The Duct Tape of Excel”
Here is an introductory Slideshare to my Guide to VLOOKUP.It's one thing to know the mechanics, another to understand WHY we need to know it. VLOOKUP's importance lies in the disperse nature of …
Continue Reading about Slideshare: “VLOOKUP: The Duct Tape of Excel” →
The Guide to VLOOKUP
I call VLOOKUP the "duct tape of Excel" because it can mend and join practically any sets of data.Introductory Slideshare:Here are a few of my top posts on VLOOKUP:Why Vlookup?Vlookup: the …