Articles

In this tutorial, we will discuss how to use the SUM function. In addition, we include several ways to use this function, such as handling … Read More

In this tutorial, we will show you how to find the closest match to a target value in a column of data using different lookup … Read More

The INDIRECT function can be used to return a reference to a range of cells based on a text string. In this blog post, we … Read More

In this tutorial, we will be learning how to separate strings of text. There are several functions that can be used to accomplish this task, … Read More

The SWITCH function is a useful tool in Excel that allows you to evaluate an expression against a list of values and return the result … Read More

In this tutorial, we will demonstrate how to easily generate random numbers in Excel. In three easy ways, you can use the RAND() function to … Read More

In this tutorial, we will cover how to use the SUMIF function with different types of criteria, including numeric, text, and date criteria. We will … Read More

Are you looking for a way to extract the domain names from a list of email addresses in Excel? In this tutorial, we will walk … Read More

In today’s tutorial, we will learn about the COUNTIF function. This function is convenient for counting and sorting data. The COUNTIF function allows you to … Read More

Comparing values in Excel is a common task that can be done using comparison operators. This tutorial will cover the following comparison operators: equal to, … Read More