Functions

In one of our previous blogs, we had learned how to use the Find and Replace dialog box in excel to find a cell containing… Read Article

Many a time, while working with text and values in excel, one may have to check if two values or text are equal or not.… Read Article

The TEXTJOIN Function in Excel is a newly introduced formula that is available in Excel 2019 and Office 365 versions of excel. It is also… Read Article

The CONCAT excel function is a newly introduced excel formula that is used to join values in multiple cells in excel.This excel function is available… Read Article

The English meaning of the word ‘Concatenate‘ is to join two or more things, and the same applies to excel as well. The CONCATENATE function… Read Article

In the previous article, we learned about the SUMIF function which finds the sum of values based on the fulfillment of a single condition in… Read Article

The Excel SUMIF function is a mathematical formula that is an advanced version of SUM function in excel. The name in itself clarifies its purpose.… Read Article

In order to get the total of numbers in excel, the SUM excel function is the most used formula.In this tutorial, we would unlock everything… Read Article

In this article, we would learn all about the SUBTOTAL function in excel. We would cover some background about usage, syntax, arguments along with examples… Read Article

To create or make a list of sequential numbers in excel, Microsoft has come up with a new formula in its Excel 365 version –… Read Article

“How to round a number up or upwards up to a specific number of digits or integers in Excel“. This is a very common question… Read Article