How to Calculate BMI in Excel

Posted on July 2, 2021November 13, 2021 by Paul

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

Posted on November 18, 2020February 22, 2022 by Paul

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

Posted on February 11, 2020November 13, 2021 by Paul

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

Posted on February 11, 2020November 13, 2021 by Paul

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

Posted on February 4, 2020November 13, 2021 by Paul

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

Posted on January 19, 2020November 13, 2021 by Paul

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

COUNT functions in Excel

Posted on December 17, 2019November 13, 2021 by Paul

There are a number of COUNT functions in Excel that you can use to count your records. Here are the most used ones: COUNT - count the number of cells in a range that contain...read more

10 BEST Excel YouTube Channels

Posted on December 5, 2019November 13, 2021 by Paul

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

Top 10 Excel websites

Posted on December 4, 2019November 13, 2021 by Paul

Microsoft Excel has a growing community of enthusiasts that create great content list blog posts, videos and courses to teach various aspects of Excel. These 10 websites stand out as best resources found on the...read more

Convert grams to grains

Posted on November 24, 2019November 13, 2021 by Paul

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