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. (more…)
This year I got serious about learning Power Query! Also known as Get & Transform. Read my post to follow my journey. (more…)
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. (more…)
Add a space after each character in a cell. Excel expert Tom Urtis solved it with vba. I solved it using a formula. Let’s compare these methods. (more…)
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 reigns! What can we do? (more…)
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…)
Do you ever hold down the Ctrl key to select multiple non adjacent cells or ranges? I’ve found a way to select multiple non adjacent ranges (any sheet) by pasting a formula into Excel’s Name Box! (more…)
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…)
