Most Common Functions in Excel

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