Explanation

 An Excel macro is an action or a set of actions that can be recorded, named, saved and executed as many times as required and whenever desired.

By using macros, we are able to automate repetitive tasks associated with data manipulation and data reporting that must be accomplished repeatedly.