Recent Tip Posts

• What is this formula doing? =SUMPRODUCT(MID(G2,{1;2;3},1)*1)  I found this formula in a notebook. Can you understand it's purpose? I'll explain it in this post. I'll also...

  ---

• False Friends in Excel The term False Friends is used in various fields including linguistics and chess. In this post I'll explain how it applies to Microsoft Excel!...

  ---

• Excel Running Template My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running. ...

  ---

• Allocating costs In this post I'll show you how to allocate expenses (or any number) over a period of time. I will use years but it could also be months, weeks or...

  ---

• Ken Puls Power Query Challenge #2 In this post I'll review my solution to Ken Puls' Power Query challenge #2. Online challenges are fun and it's a great way to learn from others....

  ---

• free data from Data.world MOMA artists In February my wife and I were planning a trip to New York City. I stumbled upon an interesting data-set that MOMA had shared with data.world. ...

  ---

• Normalize Data using Excel Get & Transform In my last post I used formulas to solve a messy data disaster. In this post/video I'll show you how to use Excel's amazing Get & Transform...

  ---

• Data Disaster: non normalized data Imagine a weekly task of sending out a simple report. To do this you rely on data from someone else. When the layout of the data changes chaos...

  ---

• Overlap of Binning and Rounding in Excel Binning numbers and rounding numbers are two separate things in Microsoft Excel. However, there is one interesting binning twist that can be solved...

  ---

• 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...

  ---