Most used formulas of Excel
COUNT :
Counts the number of cells within a range that contains number.
COUNTA :
Counts the number of cells within a range that don't contains number.
COUNTIF :
Count things that satisfy one or more conditions. That is select the range, then write the criteria and we are good to go.
COUNTIFS :
Count things that satisfy one or more conditions and criteria. That is select the range, then write the criteria, repeat then again as many times as you want and we are good to go.
---------------------------------------------------------------------------------
Learn THE Most important excel tips to be a pro : Click Click !!
-------------------------------------------------------------------------------------------
AVERAGE :
Simply having a average of the selected range of a row or coloumn.
AVERAGEIF :
It's a average of numbers which satisfy a certian criteria, select the range, write the criteria and then select the numbers whose range is required.
----------------------------------------------------------------------------------
Working with text on Excel, here's the most important things to learn !!
---------------------------------------------------------------------------------------------
LEFT :
This function will be a selection of word and then writing the number to get the result of the number of words you wanted from the text.
Eg : ISHIKA is the word and I want only ISH as a pass code to be set up I will use =the cell in which "ISHIKA" is written, 3 and the result would be ISH.
RIGHT :
Exactly like LEFT Function but takes the text from right the example result would be "IKA"
MID :
It's more complex than above you need to tell the function where the mid start from,
Eg : Mid start from 3rd letter then the result would be "HIK"
UPPER :
To covert the text wholly in upper CASE.
LOWER :
To convert the text wholly into lower case.
Proper :
The first letter would be UPPER and rest lower.
& or CONCATENATE
To combine the two text strings. Two different words in a single cell together.
--------------------------------------------------------------------------
MAX
To find the Maximum number in the Array
MIN
To find the Minimum number in the Array
ROUND
To select the number of digits you want after the decimal.
-------------------------------------------------------------------------------
VLOOKUP :
To find the exact match to fill in the data,
The first in to insert in the formula is what you are looking for, like I am looking for Goa in the Renewable Energy data sheet so I will select goa,
NEXT the whole data table, then the value you look up for, so I look up for the solar energy production of the GOA. Then "True" or "False", True sees the closest match, whereas the False sees the exact match.
HLOOKUP :
Is exactly like the VLOOKUP but the only things that changes is the VLOOKUP solve the problem based on columns but HLOOKUP solve the problem by rows.
---------------------------------------------------------------------------------
MATCH :
To know the position of the cell you choose.
