A macro is a series of commands that Excel can perform automatically. You can create simple macros to automate repetitive tasks, like entering data or formatting cells.
Although macros are created with Excel's built-in Visual Basic programming language, you don't need to be a programmer to create them. Excel's Macro Recorder will record your keystrokes, menu choices, and dialog settings as you make them and will write the programming code for you. This makes macros useful for all Excel users, even raw beginners.