Let’s review basic picture links in Excel and then explore alternative solutions to picture link limitations. I’ve also included a fun Dashboard to help Oz du Soleil reassess his wardrobe! (more…)
Tips
Last week I was helping a friend build a World Cup pool in Excel. It was fun debating the pool’s scoring rules. I also taught him a few Excel tricks along the way. (more…)
Binning numbers and rounding numbers are two separate things in Microsoft Excel. However, there is one interesting binning twist that can be solved using a rounding function. (more…)
A data validation drop down list has ‘Beverage’, ‘Food’, ‘Dessert’. You select ‘Food’. In the 2nd drop down list you want to see only ‘Food’ items (‘Chicken’, ‘Meatloaf’, ‘Seafood’). The 2nd list depends on the 1st. This is a dependent drop down list in Excel. I’ll explain my favorite way to solve this. (more…)
I’ve been a data analyst since 2001. It’s often challenging to accurately & quickly explain certain concepts. There is one that is a classic. I’m going to explain it with the help of Hugh MacLeod’s book “Evil Plans”. No nerdy data terms. The concept first. (more…)
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…)
Do You Excel?
