Whether you're using VLOOKUP or XLOOKUP, one limitation you're going to face with those functions is that you can't search within a range or use multiple criteria in your lookups. For example, suppose you're looking at a stock's history and wanted t ...
If you're looking to buy stocks, a one of the more common ratios you'll likely consider in your analysis is the price-to-earnings, or P/E multiple. You can look at either the trailing P/E or the forward P/E. Below, I'll look at what the difference b ...
Do you need to calculate the time that that has elapsed between two date values in Excel? In this post, I'll show you how you can show the difference in hours, minutes, and seconds. This can be useful if you need to determine hours on a work shift o ...
Pivot tables do a good job of summarizing your data and showing you the totals based on various splits and categories. In some cases, however, you may want to add calculated fields to your pivot table if it doesn't go far enough in analyzing your da ...
Doing a simple summation in Excel is as easy as clicking on the AutoSum button or just using the SUM function. But in some cases, you don't want to be summing up everything within a range. In those situations, you may want to use the SUBTOTAL functi ...
A drop-down list is a way you can control a user's input in Excel, to ensure that they don't make a mistake when entering in data. It can also serve as a helpful way to make your chart more dynamic. In this post, I'll show you how that's possible. ...
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 ...
