Excel tricks

Look at the picture below in the picture there are different parts are highlighted and their name were also mentioned. Now look at th...

“$” Used for – “$” is used tell MS excel that a cell / row / column has been fixed for reference in a formula throughout the sheet in...

“ “ ” ” Used for – “” is used so that MS excel can read text in any one of its formula. Syntax – “text” – here you have to replac...

“ ’ ” Used for – ‘ is used to convert number into text so that MS excel read number as text. Syntax – ‘ is syntax in itself i.e. n...

“& ” Used for – “&” is used for combining two or more values/text/alphanumeric of two cell to make it as single. Syntax – ...