XLOOKUP function is a powerful lookup function in Microsoft Excel that allows you to search and retrieve data from a range of cells. It was introduced in Microsoft Office 365 as a replacement for the traditional VLOOKUP and HLOOKUP functions, offering improved functionality and flexibility. XLOOKUP offers various options to retrieve data based on different […]

Understanding SUMIF and SUMIFS functions in Excel is easier than you think and provides great flexibility and increased speed when performing quick analysis.

SUMIF is considered one of the important Excel functions to learn. This tutorial explains how to use SUMIF function in Excel, and it’s intended to be a comprehensive guide with many real-life SUMIF formula examples. SUMIF adds more functionalities to the basic SUM formula by introducing selection criteria. The SUMIF function returns the sum of […]

This is a step-by-step guide on how to use IF function in Excel. It shows you how to create a formula using the IF function, it includes several IF formula examples, an introduction on how to use nested IF formulas, and the exercise file I used when creating this tutorial. The Excel IF function performs […]

Excel's EOMONTH function returns the last day of a month, N months in the future or the past.

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.

VLOOKUP was created to lookup and retrieve data from a specific column in a table. It support approximate and exact matching and wildcards (* ?)

The tutorial shows how to use PPMT function in Excel to calculate and return the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. This tutorial applies to the following Microsoft Excel versions: Excel for Microsoft 365, Excel 2021, 2019, 2016, 2013, 2010, […]

The tutorial shows how to use IPMT function in Excel to calculate the interest portion for a given period of a loan, mortgage, or investment. The function uses constant payments and a constant interest rate. This applies to the following Microsoft Excel versions: Excel for Microsoft 365, Excel 2021, 2019, 2016, 2013, 2010, 2007, and […]

Step by step instructions on how to use COUNTIF function in Excel. Download the example workbook to better understand how to use COUNTIF.

The tutorial shows how to use PMT function in Excel to calculate the annuity for a loan or the cash flows for investments based on a fixed interest rate, number of payments, and the total loan or investment amount. This applies to the following Microsoft Excel versions: Excel for Microsoft 365, Excel 2021, 2019, 2016, […]