A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
This episode is important! Jordan presents himself as a Contrarian, but I disagree. What Jordan brings is so much more important than being Contrarian.
‘Contrarian’ can be taken as contrary for the sake of being contrary. Over and over, Jordan says, “You don’t have to agree with me, but …”
So, really, Jordan is offering a strong invitation to be more conscious about what we do, why and what’s at stake. This shows up in everything from how we write VBA code, overuse the IF function, writing documentation in workbooks, and taking on questionable clients or projects.
As an example, Jordan describes how getting IF to work in the wrong situation really shows a misunderstanding of what the problem is. IF is a branching condition problem, but often gets used as a lookup function where MATCH, CHOOSE, VLOOKUP or INDEX would be more appropriate.
But who cares? What’s the big deal?
If there are 50 values in a lookup array, that’s easy to handle with lookup functions. However, if the same lookup is done with nested IF statements, that quickly turns into an unnecessary mess that’s hard to troubleshoot. That’s also evidence of not understanding the difference between a lookup value and a condition.
Jordan’s most compelling response to “who cares?” is the discussion around writing VBA code. Getting the code to do the work is one thing. But, Jordan warns that the code should be written for 2 people:
It’s all about being mindful. It’s in line with the conversation between Jordan and Cary Walkin on Episode 16. Jordan and Cary disagreed on 2 different way of writing VBA code.
Cary writes for ease of troubleshooting. Keep all of the code in one place because when it gets complicated, “it’s all right there.” You don’t have to go looking in named ranges and hidden helper columns.
Jordan writes for efficiency. Code runs faster, there’s less wear on the computer … and sometimes that means the code isn’t all in one place.
What’s the bottom line?
As Jordan says, “You don’t have to agree with me, but you do need to think about these things.”
Advanced Excel Essentials will question the way you attack your Excel problems. Check it out.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide