Recent Tip Posts

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

  ---

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

  ---