I’ve had this ‘Business Formulas’ book sitting around for years. I decided to explore the learning curve formula: (a) create it in Excel and (b) think about the factors that go into learning Excel.
Continue reading
The Learning Curve in Excel
Post Category → Articles
Excel Sorting Challenge
In this guest post Alan Murray (computergaga) compares two solutions to a challenging data sorting issue. I know my preference, what about you?
Continue reading
Concatenate Values to Create a Key
Excel users who don’t know this concept waste hours manually looking through their data. A filter helps but creating a valid lookup key is what Mr Carlson needs! Continue reading
Creating Mondrian Art in Excel
See how my vacation to Montreal inspired me to create Mondrian style art in Excel using VBA. Continue reading
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. Continue reading
Learning Power Query (Get & Transform)
This year I got serious about learning Power Query! Also known as Get & Transform. Read my post to follow my journey. Continue reading
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. Continue reading
formula or vba to add spaces?
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. Continue reading
Paste Formula Into Excel’s Name Box
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! Continue reading
Stack Groups of 3 Numbers in Excel
When faced with a challenge in Microsoft Excel it’s rare that two very different approaches can both be equally amazing! In this post I’ll review two completely different solutions from Oz du Soleil and David Hager. Continue reading