Tip-6

Type	Tip
Description	Enter current date (System Date)
Implementation	Select a cell(s) and press Ctrl + ;
Additional Info / Attachment

Tip-5

Type	Tip
Description	Select current region
Implementation	Select a cell in the range and press Shift + Ctrl + 8 then perform desired operation e.g. place border, create Pivot etc.
Additional Info / Attachment

Tip-4

Type	Trick
Description	Delete only constants from the selection not formula.
Implementation	1> Select range including Formulas. 2> Press F5 (Function Key) 3> Click on Special 4> Select Constants 5> Press Enter 6> Delete the selected cells or perform other operations e.g. colour format etc.
Additional Info / Attachment

Tip-3

Type	Trick
Description	Use Excel as a dictionary
Implementation	Press Alt key for a second and click left button on the mouse.
Additional Info / Attachment

Tip-2

Type	Shortcut
Implementation	Shift + F2 (Function key)
Description	Shortcut to Insert Comment on the selected cell.
Additional Info / Attachment

Tip 1

Type	Shortcut
Implementation	Alt + =
Description	1> ALT + = is used to do the AutoSum. This tip comes very handy if most of your daily calculations depend on addition of values. (Image 1) 2> AutoSum can be used not only when the values are adjacent to the result cells, but even if it's randomly displayed. All that you have to do is, press ALT + = in the cell where you want the result to be displayed and while holding the CTRL key click all the cells that you want to be included in the result. (Image 2)
Additional Info / Attachment	Image 1                                                                  Image 2

Countif