Category: MS Office

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 …

Para adicionar dados no excel que fica entre duas datas, a função SUMIFS pode ser usada. A função SUMIFS é usada para adicionar dados que atendem a várias condições …

The WEEKDAY function in excel when used to input value of a date returns a number between 1 and 7 for day on that date. By default 1 refers …

Mail Merge is a process of using a single data file and creates multiple documents with similar layout and text. Sections of the merged documents are personalized as provided …