Dynamic charts automatically adjust when new data is added in Excel. I’ll show you several ways to create dynamic charts and a few bonus tricks. Continue reading
Dynamic Charts
Let Excel’s Solver do the heavy math!
HOW DO WE SOLVE THIS PUZZLE? I’m 7 times as old as Lisa is now. In 20 years Lisa will be just half the age I will be then. How old is Lisa now? Continue reading
Using Microsoft Excel for your hockey pool
See how my Microsoft Excel template can give you an big advantage in your hockey pool! 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
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 days. 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
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 feature (aka Power Query) to re-arrange the data. Continue reading