Creating a dashboard can be an effective and efficient way to pool in many data points. In this post, I'll show you how to create a dashboard that factors in several economic indicators, including inflation, interest rates, housing starts, GDP, unem ...
Duplicate and unique values can be difficult to find in a large data set. In this post, I'll show you how you can find and highlight duplicate values, as well as how to extract unique values, in Google Sheets. In this example, I'm going to use a lis ...
A key performance indicator (KPI) is a way to track how well you're progressing towards a particular goal. Oftentimes, you might have many KPIs that you will want to track. You can create these visuals in Excel using donut charts, and below, I'll sh ...
If you've ever looked up historical stock prices on Yahoo Finance, you know that there is both a closing price and an adjusted closing price. Sometimes the values are the same, but sometimes there's a difference In this post, I'll cover why that hap ...
***UPDATE: There is a newer version of this template available here**** For a limited time, I have a free stock trading template that is available for you to download in Excel. If you buy and sell stocks often, this is a template that will help y ...
Microsoft Excel has been around for decades but Microsoft continues to roll out new features to enhance its software. Today, I'll cover three recently released features that you need to know to be a more efficient Excel user. https://youtu.be/Zo ...
Most Excel users likely know how to do a simple VLOOKUP and pull in data where a single field is matched. But what about when you need to match multiple fields? That can be a bit more challenging to pull off and below I'll show you a couple of ways ...
Want an easy way to track your expenses? In this post, I'll show you how you can use my free expense tracking template, which is based in Google Sheets. It makes copying and pasting expenses over simple, and you can quickly see reports that summariz ...
Inflation has been on the rise and it's a popular topic these days. In an earlier post, I showed you how to create an inflation calculator to determine what something would have cost in a different year. This time around, I'll go over how to calcula ...
The World Cup is starting next month and I have a free template for you to use whether you want to track the matches or make predictions with a group of friends. The entire schedule is downloaded within the file, and you can enter the the scores -- ...
