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 ...
A new feature Excel has recently rolled out is the ability to create Lambda functions. In short, this is a way to create custom functions within Excel that utilize variables. Previously, you would have needed to use VBA to accomplish this. But as lo ...
Conditional formatting in Excel can help you do a lot of things. If you have a range of data, using colors can help show where the high values are and where the low ones are. It can also be used for more complex analysis, especially since you can al ...
Parsing data in Excel can be complicated, using a combination of functions ranging from LEFT, RIGHT, MID, and FIND. However, with the help of a few new functions that are available in Excel, the process is a whole lot easier for users. In this post, ...
If you want to download a company's financial statements or data, the easiest place is often straight from the source: the Securities & Exchange Commission (SEC). You can download financials in Excel format if there is an interactive option with ...
Do you have a spreadsheet that has more than 10 tabs? If so, you probably know it can be challenging and time-consuming to organize and move all those sheets around if you want to re-arrange them. Oftentimes it's just easier to leave them as they ar ...
Do you want to calculate how long a team's winning streak is, or how many cells in a row meet certain criteria? In this post, I'll show you how you can calculate streaks in Excel. Unlike a simple count function, this will require being able to reset ...
Are you wondering how much you should put down on your credit card each month to ensure you aren't taking decades to pay off your balance? With this free credit card payment calculator template, you can plug in your balance, interest rate, and your ...
Dashboards in Excel can update when a user makes a selection on a slicer or refreshes data. You can even use macros to automatically update a chart or dashboard for you. In this post, I'll share with you a template that I've created that will allow ...
In this article, I'll show you how you can download the latest prices for cryptocurrencies, along with percent and volume changes. The data will be downloaded via an API from coinmarketcap.com. Once you've set up the API, it becomes a breeze to pull ...
