Category: MS Office

Although Excel is primarily used for Calculations, but has several in-built options to handle text also. Functions like UPPER, LOWER and PROPER can be used to covert text content …

VLOOKUP is a very powerful tool to search data but it has limitation of searching data in single Column.  VLOOKUP with multiple criteria in Excel can be performed using …

Spaces in data can sneak into your data by way of typing mistake or during copy / paste of data. To remove blank space in Excel different methods can …

Chart created using two different types of data are very useful. They can be using in finding trend between those two data set. Usually whenever you create a chart …

COUNTIF function in Excel COUNTIF function is used to count cells in a range that meets a given criterion. Data Range can contain numbers, text or date for matching. …

CONCAT is a newly introduced function available in MS office version 2019 and office 365. CONCAT unlike CONCATENATE accepts range of cell in addition to individual cells. Syntax CONCAT(text1, …

What is cell reference Cell reference is generally used in formulas where data in different cells are used for purpose of calculations. Excel has two types of references – …

Combination chart combines one or two types chart in Single chart. Use of this type of chart arises when you are using two different types of data like percentage …

To add number in excel which lies between two number, SUMIFS function of MS can be used. SUMIFS function is used to add data which meets multiple conditions or …

To add data in excel which lies between two dates, SUMIFS function can be used. SUMIFS function is used to add data which meet multiple conditions or criteria. To …