### 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 weight in imperial units, you'll...read more

### A Simple Excel VLOOKUP example

In this example, I will show you a simple way to use VLOOKUP that even a beginner would understand. VLOOKUP represents Vertical Lookup. That means Excel will look for a value on the vertical, from...read more

### 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 in several countries. For simplicity,...read more

### How to update Excel 365

If you think you may not be running the latest version of Excel as part of the Office 365 subscription, follow he steps below to check and update your desktop version. Note: If you are...read more

### XLOOKUP Release Date

XLOOKUP was announced as a replacement for the iconic VLOOKUP formula in August of 2019. As of February 2020, XLOOKUP is now available to some Office 365 users (see below) but even if you don't...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 more conditions). All conditions evaluated...read more

### 10 BEST Excel YouTube Channels

Video is a great way to learn Excel. Learning Excel through video is one of the best methods. When I need to do something in Excel that I'm not familiar with I always go to...read more

### Convert grams to grains

Learn how to convert in Excel from grams to grains and vice-versa and how to incorporate the conversion in your spreadsheets. 1 gram = 15.4324 grains and 1 grain = 0.0647989 grams The CONVERT function...read more