Excel Your Skill In Excel Vol - I

Hi Friends,

Want to work in excel smartly & fun... Just to make you more comfortable i am about to share daily tips which may help you to excel in excel..

Happy learning...!! Lets start with basic formatting.

Simple formatting tricks

 

To change a cell from all upper or lower case to proper case,where the first letter of each word is capitalized :


Syntax = Proper(cell)

e.g =PROPER(A2)



To change a cell so all of the letters appear in upper case:

Syntax =Upper(cell)

e.g: =UPPER(A2)



To change to all lower case:

Syntax =Lower(cell)

e.g: =LOWER(A2)