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
Post Category → Tips
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
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
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! Continue reading
2018 World Cup and Excel !
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. Continue reading
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 using a rounding function. Continue reading
Dependent Drop Down List in Excel
A data validation drop down list has ‘Beverage’, ‘Food’, ‘Dessert’. You select ‘Food’. In the 2nd drop down list you want to see only ‘Food’ items (‘Chicken’, ‘Meatloaf’, ‘Seafood’). The 2nd list depends on the 1st. This is a dependent drop down list in Excel. I’ll explain my favorite way to solve this. Continue reading
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 going to explain it with the help of Hugh MacLeod’s book “Evil Plans”. No nerdy data terms. The concept first. Continue reading
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 amounts of data in almost no time. With that in mind, we now turn our attention to a scenario where we will create a Pivot Table in five minutes. Continue reading
Who Won the 2018 Winter Olympics?
I watched the closing ceremonies of the Olympics last night. It was very nice…but who won the Olympics? Continue reading