A macro is a programming language that runs in MS excel environment. The tool we used to write macros is VBA editor.
High Quality Video Tutorials on Learn VBA macros.
Includes links to source file
VBA Editor: The editor is built in MS excel, all you need to install Ms excel (2010 or later).
Nothing, as this course is for the beginners. But the knowledge of MS Excel will help you