Excel Macros are very useful as they allow you to automate repetitive tasks with the click of a button.
The Macro tools are available in the Developer Tab within the Ribbon menu in Excel 2010. In most cases this may not be visible so you will need to activate it by going to File > Options > Customize Ribbon. See below to see how.
