Do you want to change how your Power Query table looks? In this post, I'll show you how you can flip your data so that you can turn a table that looks like this: Into this: In the second table, it's a bit easier to see all your fields ...
In a previous post, I went over how to modify the Excel ribbon with some basic buttons. This time, I'm going to focus specifically on a toggle button that can change the value of a cell or trigger a calculation or macro. In this example, I'll show y ...
A pie chart can be a great way to show percentages, such as how much significant an individual's product sales are to the total number. However, if you're dealing with more than 10 items, a pie chart can start to get a bit messy. But there is a way ...
Billionaire investor Warren Buffett is the CEO of Berkshire Hathaway. And what trades his company is making is always big news among his followers and fans. In this post, I'll show you how you can use Excel, and specifically Power Query, to determin ...
Do you need to find the smallest value but want to skip over any zero values? In this post, I'll show you how you can do just that. The MIN function in Excel does a good job of finding the lowest value but if you have any zero values, those will get ...
In Excel, there are multiple different stock charts you can create. All you need is some combination of the date, opening price, high price, low price, closing price, and volume to generate what you need. In this post, I'll show you how you can util ...
In a previous post, I showed how to make a forecast chart in Excel with a dotted line. This time around, I'm going to go one step further and show you how to create a chart that shows a range of possible values. This is useful in the event that you ...
Charts are an effective tool in forecasting. In this post, I'll show you can show you can make an actual and forecast chart in Excel look like one continuous line chart, with the forecasted numbers being shown on a dotted line. https://youtu.be/ ...
Excel can be a useful tool in helping you make investment decisions. And in this post, I'll use it to show you five excellent dividend stocks that you can buy on the Toronto Stock Exchange (TSX) that can help generate some strong recurring income fo ...
VLOOKUP is a popular function in Excel because of how powerful and easy it is to use. You can even use it to look up values on different sheets. And in this post, I'll show you how you can do so dynamically so that you don't always need to be adjust ...
