Top 10 Excel formulas for analysts

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 you should have good knowledge of Excel and the formulas therein. There are several formulas that are specially designed for business analysis, and it is … Read more

Excel formula for average based on criteria

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 minimum of two parameters. However, you can choose to add the third parameter if you like. The compulsory parameters include Range and criteria. The range … Read more

Excel formula for percentage gain or loss

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 loss. We can, therefore, calculate %gain using the following general mathematics formula: %gain or loss= (Gain or loss/previous value) *100. To find gain all we … Read more

IF Formula with Four Conditions

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 price is below a specific dollar amount, the engine has a minimum horsepower rating, and the transmission to be automatic. While it is possible to … Read more

Microsoft Excel Basic Formulas List

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 (number1, [number2], …) Generally, arguments in square brackets are optional, the other ones are required. See it used in the example below   2. SUMIF … Read more