Macros

Macros allow you to write program scripts that automate the work you would normally do manually. The advantage is when you have a lot of calculations that would take lots of time to do manually, macros can do in seconds or minutes depending how large or complex.

Macros help to reduce the you need to perform repetitive tasks regularly as a part of your job. A macro is a stored series of commands and functions that enables you to carry out your routine chores faster.

I think it's important to have a good knowledge of basic Excel first.