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 ...
Conditional formatting cells can be an effective way to highlight values so that they can easily stand out. You can apply similar logic to charts, and in this post, I'll show you how you can use conditional formatting with Excel charts. By doing so, ...
Switching back between Celsius and Fahrenheit can be cumbersome if you haven't memorized the formula. There are multiple steps involved and you can easily make a mistake. And while you could use shortcuts to try and approximate roughly how it is, yo ...
The Annual Percentage Rate (APR) on a loan tells you what your total borrowing cost is per year. It's different from just the interest rate because it will include other expenses and fees relating to a loan. And for that reason, the APR will be high ...
Nested IF statements aren't always the most efficient way to structure your formulas. And they can make it difficult later on if you need to fix a formula or make a change to it. What's worse, is if you inherit someone's spreadsheet and try to disse ...
Are you creating a chart that shows progress, with a certain goal in mind? In this post, I'll show you how to create a chart with a target line so that you can see how close you are progressing toward your goal. A common example for this type of ...
You can add lots of automation to your spreadsheet by utilizing visual basic (VBA) and running macros. One of the more common macros you might run include loops. In particular, using for loops in VBA can allow you to cycle through a range of data, c ...
