What are Excel Macros and how can they be useful?

Instruction: Explain what Macros are in Excel and describe a simple scenario where using a Macro could save time and increase efficiency.

Context: This question is aimed at understanding the candidate's familiarity with Excel's automation capabilities via Macros and their ability to apply them to optimize workflows.