Top 10 Excel formulas for analysts

The first step to using Excel is to understand the formulas. Excel functions and formulas are inserted into the cells. If you are an aspiring business or data analyst, then…

Comments Off on Top 10 Excel formulas for analysts

Excel formula for average based on criteria

The AVERAGEIF function is one of the most useful functions since it enables Excel users to perform averages only on cells that meet the specified criteria. This function accepts a…

Comments Off on Excel formula for average based on criteria

Excel formula for percentage gain or loss

A gain is usually an increase from the previously recorded value. The ability to manipulate Excel's Arithmetic Power is one of the greatest skills needed to calculate the gain or…

Comments Off on Excel formula for percentage gain or loss

10 Best formulas in Excel

Excel has provided a vast formula to perform different operation.   1. Sum Used for adding numbers Syntax Sum(Number 1, Number 2.,Number 9) or SUM( Starting location of data: Last…

Comments Off on 10 Best formulas in Excel

Nested If and Vlookup Function

If formula can be used together with VLookup formula to return an exact match of values and an empty string if the value not found. Combination of these formula makes…

Comments Off on Nested If and Vlookup Function

IF Formula with Four Conditions

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…

Comments Off on IF Formula with Four Conditions

Microsoft Excel Basic Formulas List

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…

Comments Off on Microsoft Excel Basic Formulas List