Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
IPMT Function
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. […]
Continue readingBitcoin Price in Excel 365
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 […]
Continue readingImportance of having Dry Powder for Investing
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 […]
Continue readingAmortization Schedule in Excel
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 […]
Continue readingCombo Box in Excel with Form Control
A Combo Box in Excel is a drop-down list, you can select a value from the list. There are multiple ways you can add a combo box in […]
Continue readingLearn about XLOOKUP
Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.
- XLOOKUP with Multiple Criteria
Perform an XLOOKUP with multiple Criteria using concatenate features in Excel - XLOOKUP Horizontal Lookup
With XLOOKUP, you no longer have to use the very limited HLOOKUP function. - XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! - Fix XLOOKUP #SPILL Error
Learn to easily fix an XLOOKUP #SPILL Error in Excel.
camera tool ceiling criteria date DAYS dynamic effect end_date exact format_text holidays index indirect ltv mass delete match minute months multiple named ranges number num_digits pmi pmt range range_lookup return_type rounding search_key second separate serial_number significance start_date Subtract if sumif sum_range table text tips value weekend xlookup year _xlfn