How do you know whether you should use Excel Formulas or Excel VBA? Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at TrumpExcel. Continue reading
Author Archives → Kevin Lehrbass
Retro 1980 Games & Correlation
What if learning statistics could be fun? Well, Omar Wagih has found a way to do this with a retro style game that teaches correlation!
Continue reading
BradEdgar_8 Search Techniques to Find Best Excel Content
We’ve all done it. We’ve wasted time looking for Excel content on the web due to inefficient searches.
Index of Ignorance
I did a quiz on The Guardian’s website called “How well do you really know your country?” The pic I saw after the quiz reminded me of Excel’s INDEX function. Yes, I see Excel function names everywhere I go! Continue reading
National Electronic Injury Surveillance System (NEISS)
This is my first post about exploring free public data sources. Knowledge really is powerful and knowing how people get injured is important in order to learn from it and avoid future accidents.
Continue reading
Video 00142 Horizontal list to Vertical list (layered transpose)
We don’t always find out how data got twisted into awkward forms. Our job is to fix it by normalizing, unwinding, transposing, etc. Once the data is in the correct format we can then get to the real job of extracting meaning from it. Continue reading
Video 00141 Formula Auditing Maestro
Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. Continue reading
The Dangers of Binning in Excel
In Excel we can bin numbers. We can also bin letters. Rare but possible. However, be careful when binning a mix of letters and symbols! What could go wrong? A student who earns a B- could end up with an A- grade! Continue reading
IFERROR post from www.MBAexcel.com
If you’ve been working with Excel long enough you’ll notice that some solutions work but can be dangerous and lead to problems. Continue reading
00127 All Combinations No Formulas No VBA
This was weird. I stumbled across my video and I thought “WHAT? Get all text combinations using just a pivot? How did I do that?” It seemed like ‘Back To The Future’ as I re-watched my own video. Continue reading