Recent Tip Posts

• Excel Error “You can’t enter an array formula over merged cells” You created a cool array formula and then merged it across several cells. Later, you realize that you need to modify this array formula. When you try...

  ---

• Excel data concept taught backwards 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...

  ---

• Excel Pivot Tables Analyze Taco Data! During our recent vacation to New York City my wife and I loved eating tacos at TACOMBI. However, when I saw the menu it reminded me of a common data...

  ---

• Create Your First Pivot Table in 5 Minutes One of Microsoft Excel's most prolific features is the Pivot Table. Pivot Tables offer an efficiency and effectiveness in making sense of large...

  ---

• Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community...

  ---

• Rank within Groups in Excel 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...

  ---

• Video 00174 Ranking Values into Tiers in Excel Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution....

  ---

• Video 00158 Keyword Data Validation List Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review...

  ---

• Video 00167 Sliding Formula Ranges Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your...

  ---

• Video 00165 Show Column Header for Matrix Value Last week I saw an interesting Excel puzzle from Leila Gharani on YouTube. Leila solved it using a sumproduct function. I made a video showing...

  ---