How to build macros?
If you need Excel to automate a repetitive task in Excel you may need to create a macro. A macro is a way in Excel, to record steps and replay them at your convenience.
Macros can be very simple: changing a date format for a column.
Macros can be also very complicated and involve coding and web access etc.
All macros are first recorded, then saved, and finally replayed when you need them.
The official Microsoft documentation can be found here.
In the video below, we show how to create, save and replay a simple macro. The macro changes the format of dates for a given column.
Note: On YouTube, you can find tons of videos on macros for specific use cases.