This quick example will demonstrate how to split a string by a colon, semi-colon, comma, or delimiter in Excel. The example below will split a name from the […]
Split String by colon, semi-colon, comma, or delimiter Read More »
The IPMT function in Excel is used to calculate the interest portion of a loan given a specified payment period. Syntax: Arguments: rate – Interest rate per period.
Learn how to quickly pull the live bitcoin price in Excel. This same method can be used to import other cryptocurrencies as well. As of May 2022, the
Bitcoin Price in Excel 365 Read More »
What is Dry Powder? If you have been around investing, you most likely have heard of keeping Dry Powder in your reserves. However, most people don’t actually know
Importance of having Dry Powder for Investing Read More »
This example shows you how to create an Amortization Schedule in Excel for a loan. In this email, we will look at an auto loan where we finance
Amortization Schedule in Excel Read More »
In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between
XLOOKUP with Multiple Criteria Read More »
