OVERVIEW
Many advanced Excel users know how to use Macros to automate tasks
by recording them using the Macro recorder, and running them at
a later date.
However more advanced automation - particularly tasks that link
the spreadsheet and other office applications together - require
VBA programming.
This Excel Visual Basic for Applications (VBA) course is designed
to give a good working knowledge of Visual Basic for Applications.
During this VBA for Excel Course students will learn to create and
edit macros, and gain an understanding of VBA code.
PRE-REQUISITES
Delegates must have attended the Advanced Excel Course (Link) and
have a good understanding of IF Statements, Horizontal and Lookup
Tables, Excel functions and Templates.
RELATED COURSES
Excel 2013 Advanced
Dashboarding
with Excel 2013
Finance
for Non Financial Managers
Accounting, Financial
Modelling and Excel Training Course
|
