control+A-select all
control+B-bold
control+C-copy
control+D-copy downwards
control+F- find
control+G-goto in particular cell
control+H-find and replace
control+I-italic
control+k-hyperlink
control+l-create list
control+U-underline
control+N-new workbook
control+W-close entire workbook
control+X-cut
control+V-paste
control+Y-redone
control+Z-undo
insert comment in cell- Shift+F2
data validation- alt+D+L
current time- ctrl+shift+ ;
insert todays date- ctrl + ;
conditional formatting- alt+O+D
current time and date- =today( ) and other =now( )
Sort the data- alt+D+S
Filter data- alt+D+F+F
Subtotal – alt+D+B
Pivot table- alt+D+P
Find the no of letters in above word- =len(text)
find left two letters in above word- =left(text,2)
find the right two letters- =right(text,2)
find average- =avg( )
find the count – =count( )
protect and hide cell from editing- alt+T+P+P
Protect sheet names from renaming- alt+T+P+W
Creating chart- alt+I+H