The IF function is used to perform logical test and return one value if the condition is TRUE and another for FALSE results. Combining AND, OR and IF function varies…
COUNTIF function is one of the most common excel function used for counting numbers within a specific range. The number of cells in the range should match the supplied criteria.…
In this tutorial, we will be discussing how to create a basic line graph on Microsoft Excel 2016. Line graphs are generally used to show trends of a series of…
VLOOKUP is one of the most useful Excel function. The function is used to search for specific value defined and returns the match in value from another column. The VLOOKUP…
There are various methods of returning a value from a Table array based on more than one criteria. Vlookup is used when there is only one criterion (condition). In this…
Many insights derived from data analyses include determining the number of observations that meet specific characteristics. For example, an analysis of a person’s ideal automobile purchase may require that the…
1. SUM This is the first Excel Function one should be familiar with. It basically performs the addition operation. The Syntax in which it is used is as follows: SUM…
Vlookup is a very useful Excel Function. Basically, what it does is ‘Look-up’ or searches for a value or text specified in a table (array) and returns a value or…
A pivot table in its simplest form is a program tool which permits its user to summarize selected columns and rows of data in a spreadsheet. It simply put is…