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
Index of Ignorance
Post Category → Articles
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 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
Learn Microsoft Excel with Twitter!
We all have down time while we wait in line or while we commute. How do you use this time? In the past two years I’ve used part of my down time to learn Excel by reading tweets.
Continue reading
12 Different Binning Solutions & Ideas
What does binning numbers into groups have in common with TV? Well…probably nothing but I had fun combining these ideas while creating this Excel file. Continue reading
True Vlookup Tragedy
The vlookup function is often used to prove a bare minimum of Excel knowledge because it’s both useful and common. Continue reading
ModelOff Comes to Toronto – Friday Night Drinks
On Friday after work I attended a ModelOff Meetup in Toronto at The Rum Exchange located on 67 Richmond St W. It was a fun event! Continue reading
Mr Excel (Bill Jelen) Power Excel Seminars
Last week I attended one of Bill Jelen’s Power Excel Seminars. The event was hosted by Excel4Apps at the SoHo Metropolitan Hotel in Toronto. Continue reading