Category: MS Office

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 …

Using excel first things which comes to mind is working with numbers but excel can do a lot with text. Excel has several text function to access these use …

HLOOKUP can be used to search for data in a table and return value from any specified cell in same row. The data which is searched for should be …

Vlook is a very powerful tool to search data but it has limitation of searching data in single Column.  A search similar to vlookup can be performed using INDEX …