Unfortunately, there's no Excel formula that can add stock quotes for you. However, there is a workaround for that which can help you get what you're after. In a previous post, I covered how to pull stock quotes using Google Sheets which is able to pull ...
If you want to customize the ribbon in Excel then you know simply changing doing it through the front end is only going to work on your computer. The customization isn't technically saved within the file and it won't move from one file to another unless ...
If you deal with credit card transactions a lot then you know that trying to get the vendor name out of the descriptions can be challenging to say the least. Companies can sometimes cram a lot of information into their doing business as (DBA) name that c ...
Whether you're building a dashboard or just wanting another chart to add to your disposal, the gauge chart is always a popular choice. In this post, I'll show you how you can create it painlessly and add it to your disposal next time you want to use a ch ...
To find correlations between data points is useful when you're trying to find a pattern or any sort of relationship. Below, I'll show you how you can quickly do a correlation matrix as well as how to do a calculation if you're only looking at two data ...
If you do a lot of driving and you need to expense it for tax purposes, then you know you need a good log to keep track of it. That's what the mileage log template will help you do. Along with tracking all your trips, it will let you do the following: ...
When you're doing financial analysis, it's helpful to add some context to growth numbers. That's where using a Compounded Annual Growth Rate (CAGR) is very useful. Rather than saying a company has grown 50% over 10 years, you could say instead that they' ...
If you're looking to hire someone and want to know whether they know how to code in Excel using Visual Basic (VBA), it's not too hard of a task to quickly evaluate whether they know it or not. The first step is to ask them to send you a sample of somethi ...
Knowing how to copy and paste is one of the most basic things you can learn to do in Excel. And while everyone is familiar with doing it, you might be surprised that there are several ways to do it, some more common than others.Using Ctrl + C and Ctr ...
If you’re looking for a way to compare worksheets in excel and find the differences between them, then this is the template for you. It will quickly highlight any changes between the worksheets and also note the differences. With just a push of a butt ...
