Excel Tutorials - Easy Simple Smart

5 simple Excel XLOOKUP examples

Posted on February 11, 2020 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, 2020 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, 2020 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, 2020 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, 2019 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

Top 10 Excel websites

Posted on December 4, 2019January 6, 2023 by Paul

Are you looking to improve your Excel skills and become a spreadsheet pro? Look no further! In this blog post, we've compiled a list of the best Excel websites that offer a variety of resources...read more

Convert grams to grains

Posted on November 24, 2019 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

How to create a dynamic Excel drop down

Posted on November 15, 2019 by Paul

Learn how to create an Excel drop down list the right way. Yes, there is a wrong way and I will show you below. The right way to create a drop down list is to...read more

How to get data from web in Excel

Posted on November 13, 2019 by Paul

Did you know that you can get data stored on websites directly into Excel and refresh it with a click of a button? Here's how you do it Before you get into the method, it's...read more

How to convert text to date in Excel

Posted on November 5, 2019 by Paul

There are many cases when the data you have in Excel appears to contain dates but when you look closer, the dates are not in a date format. This can be problematic if you need...read more

Easy Simple Smart

Digital Products

Category: Excel