I found this useful article on 5 Must Know Excel Macros  in PC World.

These macros are a time saver in so many ways.

The article takes you through step by step how to set up these Macros in Excel.

I hope you enjoy it