Do you want to do a lookup in Power Query, or just join multiple tables together? In this post, I'll show you how you can do that. The first thing you need to do is set up each individual query so that it is accessible in Power Query. https://yo ...
Waterfall charts are an effective way to display data visually. They are particularly useful if you're analyzing an income statement and want to see which parts accounted for the bulk of the change in profitability from one period to the next. In th ...
Want to know how much something was worth decades ago? Or how much something costs in today's dollars? Using inflation data, you can estimate that. And in this post, I'll show you how you can create your own inflation calculator template in Excel. I ...
A VLOOKUP function is simple: you enter criteria and select a range that it should extract values from. However, there are multiple reasons why your VLOOKUP cannot find the correct value. Below are seven common reasons your formula may not be workin ...
Did you know that you can easily add checkboxes to Google Sheets? In this post, I'll show you how you can do that. Plus, I'll share a google sheets script that can automatically update other cells when you tick and untick checkboxes in Google Sheets ...
A chart in Excel can be a quick and easy way to display information. In this example, I'm going to use a bar chart to show a range of values, displaying both the highs and lows. Whether you want to show the range of a stock price's highs and lows ov ...
Power Query can allow you to easily import data from another spreadsheet. But did you know that you can load multiple files from a folder at once? All you need to do is load the files you want to import into a folder, and Power Query can do the rest ...
Regular 2D charts in Excel can be useful if you want to compare two metrics. But if you want a third, that's where knowing how to make 3D bubble charts can be incredibly effective. It can allow you to pile in a lot of data into just a single visual. ...
Want to find the latest trending items on Google? You could go to trends.google.com, or you could import that data into your Excel file. In this post, I'll show you how. https://youtu.be/wIkD8LOUZ10 To get the latest trending topics on Goog ...
Power Query is a useful way to pull in data and make changes to it. The steps get recorded as you make them to your data set. But by doing so, you can also be hardcoding some of those steps along the way. That's a no-no. When possible, you should ma ...
