Macros are handy tools you can use to perform repetitive tasks quickly, such as inserting blocks of text.
You don't have to be a programmer to use macros; you can record your actions and have Excel 2007 save them as a macro.
Excel 2007 uses macro-enabled workbook types, which have the file extensions .xlsx (a macro-enabled workbook) and .xlstx (a macro-enabled template workbook).
If you're curious about what a macro looks like, you can display it in the Visual Basic Editor. If you know a little VBA, or if you just want to experiment, feel free to modify the macro code and see what happens.
You can create Quick Access Toolbar buttons and shapes that, when clicked, run a macro.