How to use COLUMN Function in Microsoft Excel

In Microsoft Excel, COLUMN function returns the column number of the specified reference or first column of supplied reference. In case when no reference...

How to use Excel EDATE Function

This article explains the syntax and the use of the EDATE function in Microsoft Excel. The Excel EDATE function returns the serial number that represents...

How to use RIGHT function in Microsoft Excel

The Excel RIGHT function returns one or more character, based on the specified number of characters from the end of a supplied text string. Syntax: =RIGHT(text,...

How to use Vlookup Function in Microsoft Excel

In this article, you will see the exciting and interesting use of one of the powerful Excel VLOOKUP function. The article covers real life...

How to combine multiple cells into one cell

The Excel CONCATENATE function is a part of TEXT family and used for merging two or more text string into one string. The most commonly...

Randbetween Function in Microsoft Excel

Use RANDBETWEEN function to create random number between two numbers (bottom and top). Whenever we work on worksheet it calculates for new number every time....

How to use ROUND function in Microsoft Excel

This tutorial illustrates the syntax and examples of Excel ROUND function. You will also learn how to use this function on the real-life data. The...

How to use Excel MROUND Function

This tutorial explains the usage of Excel MROUND function with syntax and examples. The Excel MROUND function returns a number rounded up or down...

How to use Excel ROUNDDOWN Function

In this article, I am going to cover how to use Excel ROUNDDOWN function. You will also explore the syntax and examples of ROUNDDOWN. The...

How to use Excel TRIM function

This Excel tutorial explains the use of TRIM function to get rid of unnecessary spaces. You will learn a quick and easy way to...