An Excel macro is simply a series of instructions. After you’ve created a macro, Excel will execute those instructions, step-by-step, on any data that you give it.
For example, we could have a macro that tells Excel to take a number, add two, multiply by five, and return the modulus.
Now, whenever we tell Excel to run that macro, we don’t have to manually do each step; Excel will do them all.
It might not seem like a big deal at first, but macros can save you a huge amount of time if you do the same series of steps on a regular basis.
It might be formatting raw data, filtering and sorting information, or applying the same series of functions and operations to your sheets.
And they’re great for sharing, too—because macros can be stored in Excel spreadsheets, you don’t need to worry about sending additional files to your colleagues. You can just write a macro, send the spreadsheet over, and let them work with it.
If you work with spreadsheets on a regular basis, there’s a good chance you could save a lot of time by working with macros.
Let’s get started by recording an example macro.