### 5 simple Excel XLOOKUP examples

Let's put the new XLOOKUP in Excel to the test with these 5 simple examples. The data below represents a list of serial numbers shipped in boxes to various companies...read more

### What is xlookup in Excel

XLOOKUP is the newest addition to the lookup formulas in Excel. If VLOOKUP is a Vertical lookup function and HLOOKUP is a Horizontal lookup function, XLOOKUP is capable of replacing...read more

### What is an Excel Pivot Table

Pivot tables are Excel's most powerful feature. A pivot table lets you summarize detailed data automatically. In this tutorial you will learn what is an Excel Pivot table and how...read more

### Today’s date and time in Excel

Use Excel to calculate today's date and today's date and time with the functions TODAY() and NOW() plus variations and keyboard shortcuts. These guides work for Google Sheets as well....read more

### Multi-row and Multi-column Pivot Table

In the previous tutorials for Pivot Tables we looked at the simple Pivot tables with one row and one column, then we added a category to the data-set to create...read more

### How to use multiple conditions in the Excel IF function

If you want to use multiple conditions in an IF function in Excel, you have to use the AND or the OR function to evaluate all the conditions (two or...read more

### Excel Formula: Get day name from a date in Excel

Here are a few methods to get a day name (Monday, Tuesday, Wednesday etc) from a date field in Excel. If you prefer video, see the tutorials below. Use Excel...read more

### How to use VLOOKUP in Excel

Excel Vlookup is the most powerful formula in Excel. Also vlookup is one of the formulas that are least used because so many users are scared of it. In this...read more

### How to Calculate BMI in Excel

The BMI calculation formula is =weight(kg)/height(m)^2. In this example, we'll apply this formula in Excel. The formula works for the metric measurements. If you have your measurements for height and...read more