One of Microsoft Excel’s most prolific features is the Pivot Table. Pivot Tables offer an efficiency and effectiveness in making sense of large amounts of data in almost no time. With that in mind, we now turn our attention to a scenario where we will create a Pivot Table in five minutes. (more…)
I watched the closing ceremonies of the Olympics last night. It was very nice…but who won the Olympics? (more…)
How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. (more…)
By default, Excel’s SEARCH function looks for one value inside of one cell. Jon Acampora from ExcelCampus (one of my favorite blogs) demonstrates how to look for various values within one cell with this formula:
=IFERROR(LOOKUP(1E+100,SEARCH(tblFilterList[Filter List],[@Name]),tblFilterList[Filter List]),””) (more…)
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. (more…)
This post from Tom Urtis reminded me of a crazy Excel puzzle I once solved. The concept was similar except for one tiny twist! First of all, let’s review the original puzzle from Tom: (more…)
Who knows what could happen in the future but for now humans using software cleanup and analyze data (not nerdy robots!). This post reviews examples of awkwardly twisted data that require transposing, rotating, repeating, etc before it can be properly analyzed.
Otis is looking for a date but he can’t find it! Let’s review four solutions that help Otis find a date. (more…)
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! (more…)
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! (more…)
