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 …