In the world of Microsoft, macros are the way many users automate various steps of their daily processes. There are two basic types of macros, recorded and coded. Recorded macros are what most users are familiar with. as they are simple to create and simple to use. Coded macros are less common, as require knowledge of Visual Basic for Applications (VBA). Recorded macros tend to be more forgiving than coded ones, especially since one character out of place in a coded macro will render the whole macro useless.
Check out this video on creating recorded macros and coded macros, and some of the differences between the two: