One of Microsoft Excel’s most powerful
capabilities for heavy users is the
Visual
basic
Application
(VBA)
language. Learning its capabilities is an
enormous benefit in almost any field
and at all levels of experience.
Repetitive tasks can be quickly
automated with the Microsoft Excel
Macro/VBA. It can be used for various
tasks
e.g. communicating
with
databases, analyzing data, automating
worksheet construction, modeling and
simulation, creating charts/graphs,
creating wizards (i.e. dialog boxes),
creating graphic user interfaces GUI)
and many more.