Essential Excel formulas to improve office productivity

difference between formulas & functions?

below we express difference between formula and functions of Excel.

Formulas
. its expressions that you can use to calculate the value of cells. for the example below – you can add together cells by writing out the formula seen here, =A1+A2+A3.
- Functions. These are ready made formulas which are built into Excel. for fast calculations and convenient way you must use functions The example below shows the SUM function that performs the same calculation as the formula below . =SUM(A1:A3).
Basic Functions
SUM
If you need to sum a column or row of numbers, let Excel do the math for you. steps to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
MAX :- will return the largest value in a given list of arguments.
MIN:- will return the smallest value in a given list of arguments.
AVERAGE:- will return the Average value in a given list of arguments.
Count:- it will Count select no. of cells
Text Function :- Change format of Text Like Upper Lower
CONCATENATE:- join text
LEFT:- separate letters from left side
RIGHT :-separate letters from RIGHT side
LOWER:- convert cell text into small letters
UPPER:-convert cell text into CAPITAL letters
MID:-Separate Middle characters
TRIM:- remove unwanted space
DATE & TIME:- used for formatting date and time
HOUR:- separate hour from given time
MINUTE:-separate minute from given time
SECOND:-separate second from given time
DATE:- combine/join date separated by year month and day
DAY:- separate day from given date
MONTH:- separate month from given date
YEAR:- separate year from given date
NOW:- latest date with time
TODAY:- latest date
Logincal Function
SIMPLE IF :- will give true or false based statements
IF with AND :- check whether all conditions are true

Welcome to IPA-SAKSHAM Group...

Most Common Functions in Excel

Essential Excel formulas to improve office productivity

difference between formulas & functions?

Basic Functions

SUM

MAX :- will return the largest value in a given list of arguments.

MIN:- will return the smallest value in a given list of arguments.

AVERAGE:- will return the Average value in a given list of arguments.

Count:- it will Count select no. of cells

Text Function :- Change format of Text Like Upper Lower

CONCATENATE:- join text

LEFT:- separate letters from left side

RIGHT :-separate letters from RIGHT side

LOWER:- convert cell text into small letters

UPPER:-convert cell text into CAPITAL letters

MID:-Separate Middle characters

TRIM:- remove unwanted space

DATE & TIME:- used for formatting date and time

HOUR:- separate hour from given time

MINUTE:-separate minute from given time

SECOND:-separate second from given time

DATE:- combine/join date separated by year month and day
DAY:- separate day from given date
MONTH:- separate month from given date
YEAR:- separate year from given date

NOW:- latest date with time
TODAY:- latest date
Logincal Function
SIMPLE IF :- will give true or false based statements
IF with AND :- check whether all conditions are true

MSCIT

Contact Form