I visit many different Excel blogs. Every once in a while I learn something completely new that really boggles my mind! And in this case the Chess world overlaps the Excel world so it was REALLY amazing (and nerdy)! How do I start to explain how awesome this is? Continue reading
Post Category → Articles
What is the easiest way to calculate grades in Excel?
Although the VLOOKUP versus INDEX/MATCH debate gets most of the attention there are MANY more topics to debate in Excel. When calculating student grades what method is best: NESTED IF or LOOKUP/BINNING TABLE? Continue reading
Video 00161 Extract Matrix Non Blanks Into 1 Column
Have you ever visited excelxor.com ? It’s an amazing blog with a lot of Excel formula challenges. Here’s one challenge: “given the the 6-by-4 array on the left we may wish to create the single-column on the right” Continue reading
World Happiness Report
Recently I saw a link about the World Happiness Report. What is it? “…a landmark survey of the state of global happiness …which ranks 155 countries by their happiness levels” Can you guess what my first question was? Continue reading
Liam Bastick from sumproduct.com
I recently presented at ModelOff’s Global Training Camp in Toronto. One of the many great things about the training camp was that I had the pleasure of meeting Excel guru Liam Bastick. Continue reading
How Many Unique Visitors To Site Each Day?
Such a clear question originating from the classic: “How many unique items per group“? Continue reading
Hiding in Plain Site
After we get comfortable with something we create habits and then we often go into auto pilot mode. The danger is that we can fail to see things that are right in front of us! Continue reading
Formulas or VBA to create military code?
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
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