What are some examples of a macro? How are they created?

Automation is the runway to efficiency.

A macro is a way to automate a task within Excel so that you can do the task again with a single click. What are some examples of a macro? How are they created? How would they benefit a business? An individual? Share some resources that you found online and elsewhere.