What is MACRO function in MS Excel and how to use it?

I would like to thank you for the question.

VBA will expand your abilities producing more convenient solutions with MS Excel.

You can solve problems like:

1. repetitive tasks 
2. custom functions
3. custom classes 
4. and more ...

Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel’s most powerful, yet underutilized feature. Using macros, you can save hours and boost productivity manifold.