***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 -- ...
Do you have a chart that you want to easily modify the range on, without needing to manually select the data again? Thanks to a new Excel feature, there are now multiple ways you can do that. https://youtu.be/Xnta274XO7U 1. Creating the cha ...
Excel's date and time functions make it easy to calculate the difference between two dates. And in this post, I'll show you how you can calculate age in Excel. This can include a person's age, or the interval between two dates. You can also break th ...
There are numerous ways to display numbers in your reports. Using percentages and decimals are two common ways to do so. In this post, I'll cover when it might makes sense to use percentages and when to decimals may be more appropriate. I'll also pr ...
Warren Buffett fans like to track the billionaire investor's moves, and a good way to do that is through Berkshire Hathaway's 13f filings. His company reports its holdings every quarter, showing where there were changes in its positions. By looking ...
