There are a couple of useful tricks that you should know about while using Excel. In this video I demonstrate a few.
Here is a brief pdf that contains many useful information. We really only need point 1 to 8 in the first few pages.
Excel primer