Source: Safalta.com
The most widely used piece of data analysis software is Microsoft Excel. In addition, investment bankers and financial analysts frequently use Microsoft's spreadsheet programme for data processing, financial modelling, and presentation.Download these FREE Ebooks:
1. Introduction to Digital Marketing
2. Website Planning and Creation
7 Simple Excel Formulas
Let's check some basic Excel functions to get you started now that you can accurately insert your favourite formulas.1. SUM
The first Excel calculation you need to master is the SUM function. It typically averages numbers from a few of the columns or rows in the range you've chosen.
=SUM(number1, [number2], …)
Example:
=SUM(B2:G2) – A simple selection that sums the values of a row.
=SUM(A2:A8) – A simple selection that sums the values of a column.
=SUM(A2:A7, A9, A12:A15) – A sophisticated collection that sums values from range A2 to A7, skips A8, adds A9, jumps A10 and A11, then finally adds from A12 to A15.
=SUM(A2:A8)/20 – Shows you can also turn your function into a formula.
2. AVERAGE
The AVERAGE function should bring to mind straightforward averages of data, such the typical proportion of shareholders in a particular shareholding pool.
=AVERAGE(number1, [number2], …)
Example:
=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)
3. COUNTA
The COUNTA function, like the COUNT function, counts every cell in a given rage. However, regardless of cell type, it counts every cell. In other words, it counts dates, times, strings, logical values, errors, empty strings, and text in addition to numbers, unlike COUNT, which only counts numbers.
=COUNTA(value1, [value2], …)
Example:
COUNTA(C2:C13) – Counts rows 2 to 13 in column C regardless of type.
However, like COUNT, you can’t use the same formula to count rows.
You must make an adjustment to the selection inside the brackets – for example, COUNTA(C2:H2) will count columns C to H
4.
COUNT
The COUNT function totals the number of cells in a given range that are empty of any other data.
=COUNT(value1, [value2], …)
Example:
COUNT(A:A) – Counts all values that are numerical in A column. However, you must adjust the range inside the formula to count rows.
COUNT(A1:C1) – Now it can count rows.
5 .
MAX & MIN
The MAX and MIN functions assist in determining the highest and lowest value within a range of numbers.
=MIN(number1, [number2], …)
Example:
=MIN(B2:C11) – Finds the minimum number between column B from B2 and column C from C2 to row 11 in both columns B and C.
=MAX(number1, [number2], …)
Example:
=MAX(B2:C11) – Similarly, it finds the maximum number between column B from B2 and column C from C2 to row 11 in both columns B and C.
6.
TRIM
The TRIM function ensures that additional spaces in your data won't cause your functions to return errors. It guarantees that there are no open spots. TRIM only works on a single cell, unlike other functions that can work on a variety of cells. As a result, it has the drawback of populating your spreadsheet with duplicate data.
=TRIM(text)
Example:
TRIM(A2) – Removes empty spaces in the value in cell A2.
7.
IF
When you wish to sort your data based on a certain logic, the IF function is frequently employed. The ability to embed formulas and functions makes the IF formula the best.
=IF(logical_test, [value_if_true], [value_if_false])
Example:
=IF(C2
=IF(SUM(C1:C10) > SUM(D1:D10), SUM(C1:C10), SUM(D1:D10)) – An example of a complex IF statement.
First, it sums C1 to C10 and D1 to D10, then it compares the sum.
If the sum of C1 to C10 is greater than the sum of D1 to D10, then it makes the value of a cell equal to the sum of C1 to C1
