How to record macros in Excel 2007: Recording a macro in Excel 2007 is easy. You can use the recorded macro repeatedly to implement the same task. Also, there is an added advantage: you can study the code of the recorded macro and easily understand the coding if you do the recordings step by step and create many simple macros before going for the big leap. The Excel training video demonstrates the concept.