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